oCommand.CommandText = "delete from students where recordid = " + Row["RecordId", DataRowVersion.Original].ToString();
HTH>>// Delete the test row >>oDS.Tables[0].Rows[oDS.Tables[0].Rows.Count - 1 ].Delete(); >> >>foreach (DataRow Row in oDS.Tables[0].Rows) >>{ >> oCommand.Parameters.Clear(); >> >> switch (Row.RowState) >> { >> case DataRowState.Added: >> break; >> >> // Do the same for DataRowState Deleted and Modified >> case DataRowState.Deleted: >> oCommand.CommandText = "delete from students where recordid = " + Row["RecordId"].ToString(); >> break; >> >> case DataRowState.Modified: >> break; >> } >> >> oCommand.ExecuteNonQuery(); >>} >>>>