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