How to compare two TXT files before send it to SQL

Posted by adopilot on Stack Overflow See other posts from Stack Overflow or by adopilot
Published on 2010-05-04T21:01:33Z Indexed on 2010/05/04 21:08 UTC
Read the original article Hit count: 403

Filed under:
|
|
|

I have to handle TXT dat files which coming from one embed device, My problem is in that device always sending all captured data but I want to take only difrences between two sending and do calculation on them. After calculation I send it to SQL using bulkinsert function. I want to extract data which is different according to first file I got from device. Lats say that device first time device send data like this in some.dat (ASCII) file

0000199991
0000199321
0000132913
0000232318
0000312898

On second calls to get data from device it is going to return all again (previous and next captured records) something like this

0000199991
0000199321
0000132913
0000232318
0000312898
9992129990
8782999022
2323423456

But this time I do want only to calculate and pass trough data added after first insert. I am trying to make Win Forms app using C# and Visual Studio 2008

© Stack Overflow or respective owner

Related posts about c#

Related posts about winforms