Help with ADO.NET - Please..

  • Thread starter Thread starter sp
  • Start date Start date
S

sp

I have a table A in Database with 5 columns. I have a CSV file with same
structure as of table A. I need to compare these two table in ado.net after
csv file is loaded into a datatable object. Can any body help me please..
 
Make sure they are sorted the same way and then run through the objects.
This can be done with either business objects or a DataTable. The objects
may be better, as you can easily override the Compare method rather than
check each property/column.

You can do this without the sort, but it is a royal pain in the rear. If one
might only have part of the records of the other, you will have to stagger
one or both as your crawl through.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************
 
Thank you for you generous help Gregory.

Cowboy (Gregory A. Beamer) said:
Make sure they are sorted the same way and then run through the objects.
This can be done with either business objects or a DataTable. The objects
may be better, as you can easily override the Compare method rather than
check each property/column.

You can do this without the sort, but it is a royal pain in the rear. If one
might only have part of the records of the other, you will have to stagger
one or both as your crawl through.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************
Click to expand...
 
Back
Top