VB.Net, ADO .NET won't update table

ADO .NET won't update table

Author	Message
Bob Schil #1 / 4	ADO .NET won't update table As a demo, I've created a OleDbConnection, OledbDataAdapter, and a dataset named dsEmployees that selects 3 fields from an Access database. The data is displayed in textboxes on a form. I can load the dataset and navigate through all of the records. I have the following code in an Update button event and it doesn't update the access database table: Try OleDataAdapter1.Update(dsEmployees) msgbox "Table Updated" Catch e as Exception Msgbox(e.ToString) End try The message nox displays the "Table Updated" message, but when I open Access the change to the record is not made.
Wed, 29 Sep 2004 21:43:07 GMT

Brainwav #2 / 4	ADO .NET won't update table Shouldn't you include the table name in the update as well? Try OleDataAdapter1.Update(dsEmployees, "myTableName") msgbox "Table Updated" Catch e as Exception Msgbox(e.ToString) End try Quote: > As a demo, I've created a OleDbConnection, OledbDataAdapter, and a dataset > named dsEmployees that selects 3 fields from an Access database. The data > is displayed in textboxes on a form. I can load the dataset and navigate > through all of the records. I have the following code in an Update button > event and it doesn't update the access database table: > Try > OleDataAdapter1.Update(dsEmployees) > msgbox "Table Updated" > Catch e as Exception > Msgbox(e.ToString) > End try > The message nox displays the "Table Updated" message, but when I open Access > the change to the record is not made.
Wed, 29 Sep 2004 21:50:54 GMT

Bob Schil #3 / 4	ADO .NET won't update table I tried both forms of the update method and both failed the same way. Quote: > Shouldn't you include the table name in the update as well? > Try > OleDataAdapter1.Update(dsEmployees, "myTableName") > msgbox "Table Updated" > Catch e as Exception > Msgbox(e.ToString) > End try > > As a demo, I've created a OleDbConnection, OledbDataAdapter, and a dataset > > named dsEmployees that selects 3 fields from an Access database. The data > > is displayed in textboxes on a form. I can load the dataset and navigate > > through all of the records. I have the following code in an Update button > > event and it doesn't update the access database table: > > Try > > OleDataAdapter1.Update(dsEmployees) > > msgbox "Table Updated" > > Catch e as Exception > > Msgbox(e.ToString) > > End try > > The message nox displays the "Table Updated" message, but when I open > Access > > the change to the record is not made.
Thu, 30 Sep 2004 02:33:46 GMT

Kathleen Dollar #4 / 4	ADO .NET won't update table Bob, Search your code for "AcceptChanges" and remove it unless you understand specifically why you are using it (it is uncommon to use it). If you don't find it, then look at hte rowstate, because it is incorrect on your altered rows. It is also possible that you need an EndCurrentEdit if you are only losing data from the last row edited. Kathleen
Thu, 30 Sep 2004 10:55:12 GMT

Page 1 of 1

[ 4 post ]