compare a datagridview with a datatable

Question

i need to compare a gridview with a datatable, and when its matched i need to check a checkbox control the exact row that is matched. so can anyone give me an opinion on this??

currently im using a foreach() and datatable.select(). and the code is here..

 foreach (GridViewRow grdrwCr /*dtrwCr1*/ in grdCr.Rows /*&dtCr1.Rows*/)
        {string TxnNo = grdrwCr.Cells["TxnNo"].ToString();
            string TxnDate = grdrwCr.Cells["TxnDate"].ToString();
            string TxnID = grdrwCr.Cells["TxnID"].ToString();
            string ChequeNo = grdrwCr.Cells["ChequeNo"].ToString();
            string CrAmount = grdrwCr.Cells["lblCrAmount"].ToString();

DataRow[] drResults= dtCrExcel.Select("TxnNO ="+TxnNo+"AND (Date="+TxnDate+"AND Type="+TxnID+"AND CheckNo="+ChequeNo+"AND Amount="+CrAmount+")"); — Dennis CriXus Batiatus, Jun 18 '12 at 08:29

score 0 · Answer 1 · answered Jun 18 '12 at 08:36

In the first time when you bind control, you must to print primary key (column with visible = false ) for each row in your gridview.

In the second time when the user select checkbox or row, you take the primary key corresponding with event.

and with primary key ,,, you select yours data in the datatable.

score 0 · Answer 2 · edited May 23 '17 at 12:12

Just a thought. If you can bind the GridView with dataTable as datasource, then you can merge this 2 datatables and check the row state decide the checkbox logic.

MSDN link for merging 2 datatables - http://msdn.microsoft.com/en-us/library/fk68ew7b.aspx

Already discussed in following link- C# - Merge two DataTables where rows are duplicate

var intersection = table1.AsEnumerable() 
                         .Intersect(table2.AsEnumerable(), DataRowComparer.Default);

compare a datagridview with a datatable

2 Answers2