DataAdapter.Upd ate works w/ datagrid but not w/ textboxes

[johnb41]

I have a very simple application where i just want to display records
from a database, and be able to edit the records.

Here's the code for the "update" button:

Private Sub btnUpdate_Click (ByVal sender As System.Object, ByVal e
As System.EventArg s) Handles btnUpdate.Click
DA.Update(DataS et, "mytable")
End Sub

If I display the records in a DATAGRID, and edit a record and then
click my Update button, it updates perfectly.

However, if i bind the data to a series of textboxes, the Update button
does not work.

I actually made a form that included both a datagrid and textboxes
(displaying the same data). For some reason, the Update would just not
work when edited from a textbox.

Note: the DataAdapter and connection were created using the IDE, so i
didn't need to create a commandbuilder. The updatecommand.c ommandtext
was created automatically when i created the DataAdapter.

Any help w/ this problem will be greatly appreciated!

Thanks!
John

[Kevin Hodgson]

Make sure in your update button event, that you End the current edit.
Add
BindingContext( DataSet.Tables( 0)).EndCurrentE dit()
Before you do the DataAdapter.Upd ate

"johnb41" <or****@informa tik.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .

I have a very simple application where i just want to display records
from a database, and be able to edit the records.

Here's the code for the "update" button:

Private Sub btnUpdate_Click (ByVal sender As System.Object, ByVal e
As System.EventArg s) Handles btnUpdate.Click
DA.Update(DataS et, "mytable")
End Sub

If I display the records in a DATAGRID, and edit a record and then
click my Update button, it updates perfectly.

However, if i bind the data to a series of textboxes, the Update button
does not work.

I actually made a form that included both a datagrid and textboxes
(displaying the same data). For some reason, the Update would just not
work when edited from a textbox.

Note: the DataAdapter and connection were created using the IDE, so i
didn't need to create a commandbuilder. The updatecommand.c ommandtext
was created automatically when i created the DataAdapter.

Any help w/ this problem will be greatly appreciated!

Thanks!
John

[johnb41]

Thanks Kevin, that solved the problem! :)

John