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!
|
*************************************************
"sp" <(E-Mail Removed)> wrote in message
news:9DC1EA4A-005A-4D85-B81B-(E-Mail Removed)...
>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..

Thank you for you generous help Gregory.

"Cowboy (Gregory A. Beamer)" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:9DC1EA4A-005A-4D85-B81B-(E-Mail Removed)...
> >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..
>
>
>

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!
|
*************************************************
"sp" <(E-Mail Removed)> wrote in message
news:FADC9B57-C6E5-459D-BE31-(E-Mail Removed)...
> Thank you for you generous help Gregory.
>
> "Cowboy (Gregory A. Beamer)" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:9DC1EA4A-005A-4D85-B81B-(E-Mail Removed)...
>> >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..
>>
>>
>>