BeginLoadData()?????

[Twyce]

The following code is supposed to be comparing two datasets and then load the rows that are not duplicates into a third datatable.Instead it repeats the rows that are already in the database(making more duplicates).Could someone tell me what i am doing wrong. foreach (DataRow parentrow in dsImport.Tables[2].Rows) { DataRow[] childrows = parentrow.GetChildRows(r); if (childrows == null || childrows.Length == 0) dtImport.LoadDataRow(parentrow.ItemArray, true); } foreach (DataRow databaseRow in dsImport.Tables["StudentModule"].Rows) { foreach (DataRow spreadRow in dsImport.Tables["Sheet1$"].Rows) { if (spreadRow != databaseRow) { dtImport.BeginLoadData(); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } return dtImport

[Harvey Saayman]

first off, PLEASE use pre tags for code blocks... second, why not create primary or unique keys on your datatables? that should help with the duplicates

Harvey Saayman - South Africa Junior Developer .Net, C#, SQL you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer) 1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111