Compare Datatables

Is there any way 开发者_运维技巧that I can compare 2 datatables with each other, both will have the same columns but I would like to check the rows in them to see which ones exist and which ones don't in each of the tables, is there an elegant way to do this?

I am using c# ASP.NET too.

Refer this..

http://forums.asp.net/t/1541581.aspx

Compare two DataTables to determine rows in one but not the other

Try this product, I've used it in the past and its great for this kind of thing. There is a free 14 day trial so might be what you are after.

http://www.red-gate.com/products/SQL_Compare/

Cheers Tigger

For comparing the schema of the database, SQL Compare is great.

If what you are comparing is the data, you can use SQL Data Compare, another product from Red Gate:

http://www.red-gate.com/products/SQL_Data_Compare/

I have been using these products for about 4 years and they are almost a complete replacement for a DBA. They work great for deploying databases and data from DEV>TEST>PROD or for making live backups for testing against.

The best part is you never have to worry if something is different between your staging and production environment - this tool will find and fix nearly any difference.

Full Disclosure: I don't work for Red Gate, I am a happy customer.