I'm new to .NET development and need some info on using
the dataadapter. I've got a Dataset object that was built
using a join of two tables. I'm having trouble getting the
data to update after changes have been made in the dataset.
dim oDataset as dataset
dim oSQLAdapter as new SQLDataAdapter(SELECT
Users.sUserid, Forms.sFormID inner join on ....)
odsqlAdpater.fill(oDataset)
dim oCommand as new SQLCommandbuilder(oSQLAdapter)
oCommand.DeleteCommand = ocommandbuilder.getdeletecommand
....
oSQLAdapter.update(odataset,"Users")
odataset.acceptchanges
oSQLAdapter.update(odataset,"Forms")
odataset.acceptchanges
Thanks,
Jon
|
