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

Re: Help with ADO.NET - Please.. by Cowboy

Cowboy
Fri May 02 10:15:10 CDT 2008

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" <sp@discussions.microsoft.com> wrote in message
news:9DC1EA4A-005A-4D85-B81B-2B9FFDCD161A@microsoft.com...
>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..



Re: Help with ADO.NET - Please.. by sp

sp
Fri May 02 14:41:01 CDT 2008

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" <sp@discussions.microsoft.com> wrote in message
> news:9DC1EA4A-005A-4D85-B81B-2B9FFDCD161A@microsoft.com...
> >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..
>
>
>

Re: Help with ADO.NET - Please.. by Cowboy

Cowboy
Mon May 05 17:01:50 CDT 2008

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" <sp@discussions.microsoft.com> wrote in message
news:FADC9B57-C6E5-459D-BE31-32EF546D32D3@microsoft.com...
> 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" <sp@discussions.microsoft.com> wrote in message
>> news:9DC1EA4A-005A-4D85-B81B-2B9FFDCD161A@microsoft.com...
>> >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..
>>
>>
>>