Dataset update problem

[Rich]

Hi

I have a Windows form that has a number of controls on that are bound to a
dataset. I'm using the code below to save the data back to the database:

connDB.Open()
da.Update(ds, "EQUIPMENT")
connDB.Close()

The problem I have is that if I update a record and move to the next record
then save it works fine, however if I update a record and then click the
save button it does not save the changes. Can anyone tell me how to update
the dataset to see the changes to a record and save them without me having
to move to the next record first.

Hope this makes sense?

Thanks
Rich

[Cor Ligthert]

Rich

probably when I understand you well

Give it a try?

Cor

connDB.Open()
DirectCast(BindingContext(ds.Tables(0)), CurrencyManager).EndCurrentEdit()
da.Update(ds, "EQUIPMENT")
connDB.Close()

[Cor Ligthert]

Rich

probably when I understand you well

Give it a try?

Cor

connDB.Open()
DirectCast(BindingContext(ds.Tables(0)), CurrencyManager).EndCurrentEdit()
da.Update(ds, "EQUIPMENT")
connDB.Close()

[Rich]

Hi Cor

Yes that works fine now. Thank you

Rich

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:O0*************@TK2MSFTNGP10.phx.gbl...

Rich

probably when I understand you well

Give it a try?

Cor

connDB.Open()

DirectCast(BindingContext(ds.Tables(0)), CurrencyManager).EndCurrentEdit()

da.Update(ds, "EQUIPMENT")
connDB.Close()

[Rich]

Hi Cor

Yes that works fine now. Thank you

Rich

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:O0*************@TK2MSFTNGP10.phx.gbl...

Rich

probably when I understand you well

Give it a try?

Cor

connDB.Open()

DirectCast(BindingContext(ds.Tables(0)), CurrencyManager).EndCurrentEdit()

da.Update(ds, "EQUIPMENT")
connDB.Close()