DataTable Comparision

[Jigna]

Hello All,

I am working in C#.NET 2.0
I need to Compare two databases, in which one is of Oracle Database and another is of SQL Server 2000 database. I want to delete records from SQL Serever which are not in Oracle database.

I created two datatables - SQLdt and ORAdt,I did upto filling these two datatables using Query but i dont know how to compare two datatables.

Can anyone help me to solve this?

[jmcilhinney]

How are you identifying that rows are the same? Must they have all fields match? ...just an ID? ...some other field or fields?

[Jigna]

Thank you for yr reply...

I have a common field - ID - in both DataTables but i dont know how to compare two rows of different DataTables

[jmcilhinney]

Presumably that column is the primary key. In that case you can do this:

DataRow row2;
 
foreach (DataRow row1 in table1)
{
    row2 = table2.Rows.Find(row1("ID"));
 
    if (row2 != null)
    {
        // A matching ID was found.
    }
}

[RaviIntegra]

Try to bind 2 tables ID's in 2 comboboxe and then you can easily compare both the combobox.