Saving a new record clears form

[Brian]

I have been able to Add a new row to a dataset, and then save the new
row back to the data source. The problem is, after the data source is
updated, all the text fields in the form clear. Any ideas?

Here's my code:

Private Sub mnuAddNewPerson_Click(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles mnuAddNewPerson.Click
...
Dim personRow As DataRow
...
ds.Tables(0).Clear()
personRow = ds.Tables(0).NewRow
ds.Tables(0).Rows.Add(personRow)
...
End Sub

***

Private Sub mnuSave_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles mnuSave.Click
...
cmPeople.EndCurrentEdit()
daPersonMain.Update(ds, "PersonBasic")
...

End Sub

[steve]

you obviously have the form bound to the data source...i don't do binding,
but there should be an overwriteable interface on the form class so that
when the "recordNew()" (or whatever the interface) event is raised, you can
intercept it and substitute your code in lieu of what is undesireably
happening behind the scenes when you are adding a new person.

hth,

steve
"Brian" <br*********@yahoo.com> wrote in message
news:be**************************@posting.google.c om...

I have been able to Add a new row to a dataset, and then save the new
row back to the data source. The problem is, after the data source is
updated, all the text fields in the form clear. Any ideas?

Here's my code:

Private Sub mnuAddNewPerson_Click(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles mnuAddNewPerson.Click
...
Dim personRow As DataRow
...
ds.Tables(0).Clear()
personRow = ds.Tables(0).NewRow
ds.Tables(0).Rows.Add(personRow)
...
End Sub

***

Private Sub mnuSave_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles mnuSave.Click
...
cmPeople.EndCurrentEdit()
daPersonMain.Update(ds, "PersonBasic")
...

End Sub

[Cor]

Hi Brian,

Dim personRow As DataRow You create a new empty row
ds.Tables(0).Clear() The whole Table(0) is cleared (I asume that it is your only table)
personRow = ds.Tables(0).NewRow You fill the personRow with the structure of the dataset
ds.Tables(0).Rows.Add(personRow)

You add an empty row to your dataset Table(0), who exist of zero rows.

What do I see wrong?

Cor

[Fergus Cooney]

Hi Brian,

Perhaps the Form loses track and you need to navigate it 'back' to the
record it was just on??

Regards,
Fergus