VB.NET and Data Adapter Update Method Not "Updating"

[pooba53]

I have a VB .NET application that is communicating properly with an Access DB. I have a slew of textbox controls bound to a dataset and when the application launches, the fields are correctly populated.

If someone changes a value in one of the text boxes, I need to have a button capture the change and commit the update to Access. I know I'm close, but something is missing. I have a data adapter called:
OleDbDataAdapter1

and a dataset called:
DsMyMonthlyIncome1

My button function is:
Try
OleDbDataAdapter1.Update(DsMyMonthlyIncome1)

Catch ex As Exception
MsgBox(ex.ToString)
End Try

No error occurs, but the changed information in the text field never gets communicated to the Access DB. Have I not captured the changes by having the textbox controls bound?

I've searched quite a bit today, and not found the information I seek. I am lost here and appreciate the help.

[pooba53]

Anybody help me here?

[pooba53]

Anybody help me here?

Anyone at all...

[pooba53]

Anyone at all...

Seriously, no waiting :-)

[yorkshire2510]

pooba,

Does the updates involve updating several tables within the database? If so, then you need to update the tables one at a time, by adding the name of the table to the update parameters:

OleDbDataAdapter1.Update(DsMyMonthlyIncome1, "tableName")

I hope this helps

[gerrymad]

This messed me up for quite a while. Basically VB creates a temp file at run time when in the developer mode. There is a good explanation at this URL:
https://blogs.msdn.com/smartclientdata/archive/2005/08/26/456886.aspx

[pooba53]

All I needed to do is something like this before doing the update:

Dim cm As CurrencyManager
cm = DirectCast(BindingContext(DsMyMonthlyIncome1, "Budget Items"), CurrencyManager)
cm.EndCurrentEdit()

-Dan

This messed me up for quite a while. Basically VB creates a temp file at run time when in the developer mode. There is a good explanation at this URL:
https://blogs.msdn.com/smartclientdata/archive/2005/08/26/456886.aspx