DataTable Comparision

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?

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

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

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

C# Code:

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

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