vb.net - Editing current data in a data table -
i using following data add new data table
me.tblresulttableadapter.fill(me.dbresultdataset.tblresult) dim drnewroweditsummary datarow drnewroweditsummary = dbresultdataset.tblresult.newrow drnewroweditsummary.item(1) = "test" dbresultdataset.tblresult.rows.add(drnewroweditsummary) tblresulttableadapter.update(dbresultdataset.tblresult)
how can edit data using similar method above? furqan
datarowcollection has find-method returns datarow given primary key(s). should define pk column, row with:
dim drresult datarow = dbresultdataset.tblresult.rows.find(1) 'if pk 1' drresult.item(1) = "test2" tblresulttableadapter.update(dbresultdataset.tblresult)
btw, same way if want delete row: drresult.delete()
Comments
Post a Comment