compare two columns contents from two tables

Question

I want to compare two tables column contents if the contents are same show message
the following code only check if records exist
if (dtBu.Rows.Count > 0 && dtConsignee.Rows.Count > 0)
{
showMessage("We have same data");
}

Krishna Garad · Accepted Answer

try this
if(dtone.Rows.Count>0&&dtsecond.Rows.Count>0)
{
List dtonecolumn=new List ();
List dttwocolumn=new List ();
foreach (DataRow dr in dton.Rows)
{
dtonecolumn.Add(dr["ColumnName"].ToString());
}
foreach(DataRow dr in dtsecond.Rows)
{
dttwocolumn.Add{dr["ColumnName"].ToString();
}
if(dtonecolumn.Items.Count>0 &&dttwocolumn.Items.Count>0)
{
for(int i=0;i<dtonecolumn.Items.Count;i++)
{
string valone=dtonecolumn[i].ToString();
string valtwo=dttwocolumn[i].ToString();
if(valone==valtwo)
{
// True until the contents are same
}
else
{
//false
}
}

MaxPayne · Answer

but the the list variable do not have "dtonecolumn.items.count" it should be "dtonecolumn.count"
anywere nice stuff

MaxPayne · Answer

Great thanks man