retrieving row based on input
- by christine33990
public void RemoveTask(int index)
{
SQL = "DELETE FROM Task where (...) = " +index;
dbConn.Open();
dbCommand = new SqlCeCommand(SQL, dbConn);
dbCommand.ExecuteNonQuery();
dbConn.Close();
}
What i want to do is to delete the record based on the index which specified the row number but I don't know what function or variable should be used ( note the blank ), i try something like rowNum but it does not work.
any help will be appreaciated
