How comparing database table rows using nested loop?

Question

H!, How to comparing two different table rows using nested loop to prevent duplication?

Vulpes · Answer

The code to do that would be something like this: // insert code to create and fill a new DataRow, row2, of dataTable2 // now check whether there's already a similar row in dataTable1 bool hasSameRow = false; foreach(DataRow row1 in dataTable1.Rows) { bool hasSameColumns = true; for(int i = 0; i { object item1 = row1.ItemArray[i]; object item2 = row2.ItemArray[i]; if(item1 == null && item2 == null) continue; else if(Convert.IsDBNull(item1) && Convert.IsDBNull(item2)) continue; else if(item1.ToString() != item2.ToString()) { hasSameColumns = false; break; } } if(hasSameColumns) { hasSameRow = true; break; } } if (!hasSameRow) dataTable2.Rows.Add(row2); // OK to add it to dataTable2

Black Diamond · Answer

hi vulpes, Thank a lot for your code it work's perfectly ....

Black Diamond · Answer

hi everyone, I just want to compare two different table rows to avoid duplicate in the two tables, i want that if one record is already add in table1, it should not be added in table2, what should i do?, is that right to use nested loop to read one of each table? Can anyone help me out this problem?

Sam Hobbs · Answer

More input please.

How comparing database table rows using nested loop?

Answers (4)