I have tried to use the "DELETE" statement to delete a row from the table, which satisfies part_number not equal to EA*. But this part is not working.


OleDbDataAdapte r MyAdapterBasic = new OleDbDataAdapte r("SELECT part_id, part_number, description FROM parts;DELETE FROM parts WHERE part_number LIKE 'EA%'", MyConnection);


I have used two SQL statements seperated by ; symbol.
...