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(); >} >>