bound textbox

[Guest]

Hi

I am using the ADO.NET OoledbConnection, oledbDataAdabter and a Typed
oledbDataSet to access data from an MS Access db using the Jet 4 provider in
a VS.NET 2003 Windows Forms project on XP Pro Sp2.

I simply have 3 bound textboxes on a form. A button which fills the dataset,
a couple of navigation buttons which use the CurrencyManager Position
property to scroll through the records and a Save button which calls the
DataAdapter.Update method to send the updates to the database.

The database is only updated if the current record is moved off first before
the Save button is clicked. Otherwise the changes are not saved to the
database.

I would be very greatful if someone could advise me on this.

 

[Miha Markic [MVP C#]]

Hi,

Hi

I am using the ADO.NET OoledbConnection, oledbDataAdabter and a Typed
oledbDataSet

Nah, you are using typed dataset (without oledb prefix).

to access data from an MS Access db using the Jet 4 provider in

a VS.NET 2003 Windows Forms project on XP Pro Sp2.

I simply have 3 bound textboxes on a form. A button which fills the
dataset,
a couple of navigation buttons which use the CurrencyManager Position
property to scroll through the records and a Save button which calls the
DataAdapter.Update method to send the updates to the database.

The database is only updated if the current record is moved off first
before
the Save button is clicked. Otherwise the changes are not saved to the
database.

I would be very greatful if someone could advise me on this.

CurrencyManager.EndCurrentEdit() should do the trick.

 

[Guest]

Thanks Miha
Yes the End CurrentEdit did the trick - and you noticed I got carried away
with the oledb prefixes - well spotted!