Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DataAdapter doesn't update.

Status
Not open for further replies.

qwert231

Programmer
Sep 4, 2001
756
0
0
US
With this code:
Me.daCustomer.Update(Me.DsGlobal1, "Customer")
Me.daEvent.Update(Me.DsGlobal1, "Event")
Me.daSport.Update(Me.DsGlobal1, "Sport")
Me.daUnderclass.Update(Me.DsGlobal1, "Underclass")

The first Update does it fine, but the rest do nothing. No
errors, but no changes.

I am creating the DataAdapter (da) command like this:
Me.daSport.UpdateCommand = New OleDb.OleDbCommand()
Me.daSport.UpdateCommand.Connection = OleDbConnection1
Me.daSport.UpdateCommand.CommandText = tmpStr.ToString

What am I doing wrong? Or what haven't I done?
Please...
 
Do you have ContinueUpdateOnError property set to true for the data-adapters? If you do, set it to false and try to catch the error.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top