C# datatable & sql Database Comparison...

Accepted answer

foreach(DataRow Dr in objCustomers2.Rows)

{

foreach(DataRow Dr2 in dtCustomer.Rows)

{

if(Dr["CustomerCode"].ToString() == Dr2["CustomerCode"].ToString() && Dr["CustomerName"].ToString() == Dr2["CustomerName"].ToString())

{

DataRow DrTemp = Common.NewRow();

DrTemp["CustomerCode"] = Dr["CustomerCode"];

DrTemp["CustomerName"] = Dr["CustomerName"];

Common.Rows.Add(DrTemp);

}

}

cHECKK THIS IS CORRECT ANSWER IF IT HELPED

0

Sukesh Marla14y ago

Always welcome dear

0

Gopal Mahadak14y ago

thnks.. Fine working code..

0

Gopal Mahadak14y ago

Not Run Correctly.. help

0

Sukesh Marla14y ago

First take your database table records into C# DataTable(MyDataTable)
and then Compare two them as

DataTable Common=MyDataTable.clone()

foreach(DataRow Dr in Datatabl1.Rows)
{
foreach(DataRow Dr2 in MyDataTable.Rows)
{
  if(Dr["Col1"]==Dr2["Col1"] && Dr["Col2"]==Dr2["Col2"])
  {
   DataRow DrTemp=Common.newRow();
   DrTemp["Col1"]=Dr["Col1"];
   DrTemp["Col2"]=Dr["Col2"];
   Common.Rows.add(DrTemp);
  }
}
}

Hope this helped, Check this is correct answer

0