Help with ADO.NET - Please..

[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..

 

[Cowboy \(Gregory A. Beamer\)]

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!
|
*************************************************

 

[sp]

Thank you for you generous help Gregory.

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!
|
*************************************************

 

[Cowboy \(Gregory A. Beamer\)]

I only hope it stirred the pot and you ended up with soup.

--
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!
|
*************************************************