On Sun, 10 Feb 2008 07:34:15 +0100, "Cor Ligthert[MVP]"
<notmyfirstname@planet.nlwrote:
Quote:
>AW,
>
>A database has nothing to do with an AcceptChanges, what an accept changes
>does is setting all the rows to unchanged and removing all rows that have
>the rowstate deleted. All first state information is removed from the Row.
>
>Deleting a row in a database goes in fact with a SQL statement.
>
>If you use a datatable however, then the delete is done by the DataAdapter
>in the Update of the TableAdapter (which I never have used) or the
>DBDataAdapter (which I always use).
>
>Therefore, show some code.
>
>Cor
OK, I followed some of your advice - I created a DeleteQuery in the
TableAdapter. Then I looped thru the rows of the DataGridView and when
I found a row to delete, I called the Sql DeleteQuery with Where
(ColSym=string) - TableAdapter.DeleteQuery(str)
And then ran the program again - deleted stuff gone.
Amazingly simple but try finding it in "help".