mark jones

mark jones

  • NA
  • 31
  • 0

find a row in the datatable

Jul 11 2006 6:03 PM
Can someone please help with the following problem. I am trying to locate a row in the datatable to delete but am not sure how to go about this. I have decided to use a for loop to iterate through the datatable until a match is found with the entered ID number. However, when the matching ID number is found, the code that I use to delete the found row doesnt seem to work. I get a thrown exception saying that the row at position (n)does not exist in the table and the datagrid on the form goes blank. The code that I am using to try to delete the found row is shown below. int RowCount = 0; foreach(DataRow dr in mydataset.Tables[1].Rows) { RowCount ++; if (txtStudID.Text == dr[0].ToString()) { mydataset.Tables[1].Rows[RowCount].Delete(); mydataset.WriteXml("C://Student1.xml"); mydataset.WriteXmlSchema("C://Student1.xml"); } } //end of for loop mydataset.Tables[1].Rows[RowCount].AcceptChanges(); f2.dataGrid1.DataSource = mydataset; return; Any help will be very much appreciated.

Answers (1)