I would like to know wich way I can use to delete a row in a database ?
My problem is that I have some items that need to be removed.
I know I can use a database like doing
but using a database that need to read all the lines in it
and remove the one not necessary is stupid and it's take way too much time for the program. And I also got a bug when I remove 2 or + items and that I try to access to the next item in the table.
What I was thinking of using is a OleDbCommand and OleDbReader with a query that will only search the objects that I need in SQL. and then compare them and delete the ones I don't need.
but if I use a OleDb, how do I remove the items I don't want ? is there a command for that ?
or is my only possibility the DataSet and DataRow ? or is there other way to do it ? other method or something ? if you know any others that might help me. please tell me ! every opinion and idea is welcome.
I got an headache just for thinking about how I could solve all those problems.