Deleting rows from database

[sillysod]

Hi There,

I am using vb.net to load a list of orders from a database.

I am able to delete rows from within the datatable and the row disappears from the datatable (i have checked using a bound datagrid)

However when i call myda.update the records arent deleted from the underlying table, when i refill the dataset they are still there

i have tried calling myds.acceptchanges before doing the update


I am able to amend / add records without any problem

Does anyone have any ideas?>

 

[sillysod]

NB No exceptions are returned / errors occur

 

[sillysod]

doh, though remove and delete did the same thing