problem in datatable.acceptchanges

i am using the following code:
if i use this code it deletes the row in dataset.tables(0) but after that i am using to update the dataset da.update(ds) but it is not gettting updated. value remais i dont know why? please help me to solve this please

Where's your code?

dear mendhak,

sorry fo rdidn't attach friend, i have resolved the problem. thanks for the attention.

Another job well done by yours truly. :afrog:

Most likely it's because you're calling AcceptChanges() before updating your database. You need to know that AcceptChanges will reset the rowstates of any new or modified datarows to unchanged, and remove the rows with rowstate = deleted from the datatable. So once you call AcceptChanges on your datatable, you your dada adapter will see no new/modified/deleted rows in the datatable and nothing will be changed in your database.

thank you friends for attention to my thread