I have a typed dataset and a table pulled from sql database.
This table is presented on a grid on the interface where the user can interact (add/delete/update rows). At run time, i add a few rows programmatically (say these rows have a name that starts with "donotinsert - " in the name column) to this table that is meant for run-time only. I do not want these rows to be saved back to the database. The problem arises when a user deletes a row in the grid (i've checked the rowstate to be "deleted") and i do a tableadapter.update(table.select("name not like 'donotinsert -%'"), the deleted row in the grid does not get deleted in the sql table. If I however just use a straight tableadapter.update(table), then everything works as expected, but those "donotinsert - " rows will get added to the sql table.
How do i get around this??