dataset1.table1 is filled from a table in a database
dataset2.table1 is filled from a table in a database

How can I programatically compare the two tables to see if their schemas are
compatible (Same column definitions and contraints and keys...) and can be
merged or not?

Perhaps the easiest and cheapest way is to perform the merge. If the schemas
are the same, all is well. Otherwise, they are not and you will get an
exception that you can handle appropriately.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET - MS Press
Professional VSTO 2005 - Wrox/Wiley
OWC Black Book www.lulu.com/owc

"Leon_Amirreza" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> dataset1.table1 is filled from a table in a database
> dataset2.table1 is filled from a table in a database
>
> How can I programatically compare the two tables to see if their schemas
> are
> compatible (Same column definitions and contraints and keys...) and can be
> merged or not?
>

Hello!

> Perhaps the easiest and cheapest way is to perform the merge. If the
> schemas are the same, all is well.

I agree with Alvin, this is probably the easiest way to proceed. However,
depending on your needs, the ConstraintException that is raised (in case of
schema mismatch) might not give you enough details what's different in the
schemas.

Then, the remedy would be to loop through the elements in the Table.Columns
collection, and after that check for example primary keys, etc.

Hope this helps!

--
Regards,

Mr. Jani Järvinen
C# MVP
Helsinki, Finland
(E-Mail Removed)
http://www.saunalahti.fi/janij/