Compare 2 datatable Cells and return boolean values in c#

Question

Hi All,

Please provide your inputs the feasible way to compare two datatables in C#.

Datatable1:

EmpID EmpName Age
1 AAA 22
2 BBB 23
3 CCC 25

DataTable2:

EmpID EmpName Age
1 AAA 20
2 BBB 23
3 CCD 25

Result datatable should be as given below:

EmpID EmpName Age
True True False
True True True
True False True

Thanks in advance.
Suresh Sankaran

Answer 1

Typically, a SQL query is used to work with set data not a DataTable. Can you explain the use case or the problem you are trying to solve?

class Program  
{  
    static void Main(string[] args)  
    {  
  
        DataTable table1 = PopulateDataTable();  
        DataTable table2 = PopulateDataTable2();  
  
        var query = from t1 in table1.AsEnumerable()  
                    join t2 in table2.AsEnumerable()  
                    on t1.Field<int>("EmpId") equals t2.Field<int>("EmpId")  
                    select new CompareDataTablesResults()  
                    {  
                        EmpID = t1.Field<int>("EmpId"),  
                        EmpName = t1.Field<string>("EmpName") == t2.Field<string>("EmpName"),  
                        Age = t1.Field<int>("Age") == t2.Field<int>("Age")  
                    };  
  
        foreach(var item in query)  
        {  
            Console.WriteLine($"{item.EmpID}\t{item.EmpName}\t{item.Age}");  
        }  
  
    }  
  
    public static DataTable PopulateDataTable()  
    {  
        DataTable table = new DataTable();  
        table.Columns.Add("EmpID", typeof(int));  
        table.Columns.Add("EmpName", typeof(string));  
        table.Columns.Add("Age", typeof(int));  
  
        table.Rows.Add(1, "AAA", 22);  
        table.Rows.Add(2, "BBB", 23);  
        table.Rows.Add(3, "CCC", 25);  
  
        return table;  
    }  
  
    public static DataTable PopulateDataTable2()  
    {  
        DataTable table = new DataTable();  
        table.Columns.Add("EmpID", typeof(int));  
        table.Columns.Add("EmpName", typeof(string));  
        table.Columns.Add("Age", typeof(int));  
  
        table.Rows.Add(1, "AAA", 20);  
        table.Rows.Add(2, "BBB", 23);  
        table.Rows.Add(3, "CCC", 25);  
  
        return table;  
    }  
  
}  

Results

1       True    False  
2       True    True  
3       True    True  

Answer 2

Hi AgaveJoe,

Thank you for the support.

I need more clarity on the statement "CompareDataTablesResults()".

var query = from t1 in table1.AsEnumerable()
join t2 in table2.AsEnumerable()
on t1.Field<int>("EmpId") equals t2.Field<int>("EmpId")
select new CompareDataTablesResults()
{
EmpID = t1.Field<int>("EmpId"),
EmpName = t1.Field<string>("EmpName") == t2.Field<string>("EmpName"),
Age = t1.Field<int>("Age") == t2.Field<int>("Age")
};
This is statement shows an error. I have removed the CompareDataTablesResults() and tried. It is working but the "query" is empty.

Answer 3

I need more clarity on the statement "CompareDataTablesResults()".

CompareDataTablesResults is a class.

    public class CompareDataTablesResults  
    {  
        public int EmpID { get; set; }  
        public bool EmpName { get; set; }  
        public bool Age { get; set; }  
    }