I used statements like 'Update' and 'Insert Into' to change the data in my data source. Like I updated a certain field like this:
ds.Tables("tblUsers").Rows(2)(3) = "xyzzzz"
and then I executed an sql statement on the same field like this:
objCmd.UpdateCommand = new OleDbCommand
objCmd.UpdateCommand.CommandText = "Update tblUsers " & _
"SET City='xyzzzz' WHERE UserID=3"
objCmd.UpdateCommand.Connection = Conn
And finally I update the data source:
(where objcmd is an instance of oledbdataadapter object)
What should I do to delete a record in my data source through asp.net (in VB) with the same technique as above? The data source that I am using is MS Access. Please, help.
View Complete Post