dataset - Deleting a row from datatable, then the database is not updated -

dataset - Deleting a row from datatable, then the database is not updated -

deleting row datatable next syntax:

dim look string = "fulltag = 'itemtag'" dim row() datarow = mydataset.tables("mytable").select(expression) dim row2 datarow = row(0) row2.delete() iwdataset.tables("mytable").acceptchanges()

then attempting update corresponding database file (.sdf) following:

dim myadapter new sqlcedataadapter("select * mytable", connstr) sqlcommbuilder.dataadapter = myadapter myadapter.updatecommand = sqlcommbuilder.getupdatecommand myadapter.update(mydataset, "mytable") iwdataset.acceptchanges()

the corresponding database (.sdf) not update, row should have been deleted, still nowadays in database.

some suggestions?

thankyou

ok, problem solved myself.

the error in:

iwdataset.tables("mytable").acceptchanges()

the method acceptchanges() removes in permanent way rows table after deleting them, equivalent perform remove() method. @ time of updating database (.sdf file), removed rows no longer available dataadapter deletion .sdf file.

following right code:

deleting row:

iwdataset.tables("[mytable]").rows.find(mykey).delete()

updating databae (.sdf file):

dim myadapter new sqlcedataadapter("select * mytable", connstr) sqlcommbuilder.dataadapter = myadapter myadapter.updatecommand = sqlcommbuilder.getupdatecommand myadapter.insertcommand = sqlcommbuilder.getinsertcommand myadapter.deletecommand = sqlcommbuilder.getdeletecommand myadapter.update(mydataset, "mytable") iwdataset.acceptchanges()

database dataset sql-server-ce