Form updates are never saved using the binding navigator


S

sandal

I've watched the "VB How Do I" series and there is seems very simple to
create an updateable form by dragging a table from the Data Sources tab,
as either a grid or a detail, to a form. However when I do it, using an
Access mdb as the data source, nothing is ever saved to the database.
The edits persist as long as the form is open but if closed and
reopened, nothing was committed. The expected code is in place

Me.TblProjectBindingSource.EndEdit()
Me.TblProjectTableAdapter.Update(Me.ConsultDataSet.tblProject)

It's kind of strange to have such a simple attempt fail...what could be
causing this? I've already uninstalled and reinstalled vs. This is the
trial edition (vs 2005 pro, sp1); but I can't believe MS would configure
the trial with edits disabled.
 
Ad

Advertisements

S

sandal

I've watched the "VB How Do I" series and there is seems very simple to
create an updateable form by dragging a table from the Data Sources tab,
as either a grid or a detail, to a form. However when I do it, using an
Access mdb as the data source, nothing is ever saved to the database.
The edits persist as long as the form is open but if closed and
reopened, nothing was committed. The expected code is in place

Me.TblProjectBindingSource.EndEdit()
Me.TblProjectTableAdapter.Update(Me.ConsultDataSet.tblProject)

It's kind of strange to have such a simple attempt fail...what could be
causing this? I've already uninstalled and reinstalled vs. This is the
trial edition (vs 2005 pro, sp1); but I can't believe MS would configure
the trial with edits disabled.
I've installed on a couple of other boxes, with and without sp1, and
none save updates when the save icon is pressed.

I'm not exactly getting overwhelmed by responses here...maybe no one
uses the binding navigator, or the wizard generated implementations are
known to be useless?
 
Ad

Advertisements

G

Guest

Did you wrap it in a try catch, put a break on the catch and read the message
That will tell you why it didn't save
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top