DAtaset comparision ??

27 Oct 2007 9:41 AM

calderara

Dear all,

What is the best way to compare 2 dataset ?

What I mean by that is not comparing that its teh same object but allso that
rows data values in both .
In other words I need an effeective way which tells me if records between 2
dataset are the same or different

thnaks for help
regards
serge

27 Oct 2007 10:55 AM

Mansi Shah

Hi calderara,

Following link may help you:

http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.ado
net/topic4082.aspx

Then after you have any queries then feel free to ask..

Regards,
Mansi Shah.

*** Sent via Developersdex http://www.developersdex.com ***

27 Oct 2007 5:19 PM

Cor Ligthert[MVP]

Caldera,

A non serialized dataset is in fact nothing more then a wrapper that holds
in opbjects nothing more than references to datatables and datarelations.

DataTables holds references to datacolumns and datarows.

DataRows hold references to items, and items contains data.

If you want to check this, then it will be a loop in a loop etc. However
completely depending what is in the dataset.

In my opinion are you mixing up a dataset with a recordset, while you are
speaking of records. A dataset is completely different from a dataset, the
dataset is not even a resultset.

Cor

28 Oct 2007 6:16 PM

calderara

All right I understand cleary what a dataset is..
Lets keep it simple, I just would like to know if there is straigh forwars
solution to compare items in rows between 2 different rows colelction in
order to know if tehre are equal.

Show quote

"Cor Ligthert[MVP]" wrote:

> Caldera,
>
> A non serialized dataset is in fact nothing more then a wrapper that holds
> in opbjects nothing more than references to datatables and datarelations.
>
> DataTables holds references to datacolumns and datarows.
>
> DataRows hold references to items, and items contains data.
>
> If you want to check this, then it will be a loop in a loop etc. However
> completely depending what is in the dataset.
>
> In my opinion are you mixing up a dataset with a recordset, while you are
> speaking of records. A dataset is completely different from a dataset, the
> dataset is not even a resultset.
>
> Cor
>
>
>
>

29 Oct 2007 5:43 AM

Cor Ligthert[MVP]

Caldera,

As I wrote already in a (for) loop.

You wrote that you want the compare the contents of objects, those are in
the DataRow Item Collection.

Cor