BindingManagerB ase Problem

[dbuchanan52]

My newly added row will not become current.

I have several textboxes bound to a DataGrid1 and a couple of buttons
including 'btnNewRecord'. The datagrid is bound to a table in a
dataset.

What happen is that btnNewRecord adds a new row to DataGrid1 as
expected, however the active row does not move to the newly added row!
What am I missing?

Here is pertainent code...

===== Code 1 ===
Public Class frmJobCustomer
Inherits frmForm1

[" Window Form Designer generated code "]

Private _bmb As BindingManagerB ase

Private Sub btnNewRecord_Cl ick(ByVal sender As System.Object, ByVal
e As System.EventArg s) Handles btnNewRecord.Cl ick
_bmb.AddNew()
End Sub

Private Sub DataGrid1_Curre ntCellChanged(B yVal sender As Object,
ByVal e As System.EventArg s) Handles DataGrid1.Curre ntCellChanged
Dim _currentRow As Integer = DataGrid1.Curre ntCell.RowNumbe r
Me.DataGrid1.Se lect(_currentRo w)
_bmb.Position = _currentRow
End Sub

Private Sub btnCancelChange s_Click(ByVal sender As System.Object,
ByVal e As System.EventArg s) Handles btnCancelChange s.Click
_bmb.CancelCurr entEdit()
End Sub

Private Sub btnSaveChanges_ Click(ByVal sender As System.Object,
ByVal e As System.EventArg s) Handles btnSaveChanges. Click
_bmb.EndCurrent Edit()
End Sub

Private Sub JobCustomer_Loa d(ByVal sender As System.Object, ByVal e

As System.EventArg s) Handles MyBase.Load

'Get ds from the DAL
Dim JobCustomerDB As New DALCL.Tables
localDsTables1 = JobCustomerDB.G etDaJobCustomer
Me.DataGrid1.Da taSource = localDsTables1. tblJobCustomer

Call CreateBindings( )
End Sub

Private Sub CreateBindings( )
' Add control configuratioins to the collection
Me.lblpkJobCust omerId.DataBind ings.Add("Text" ,
Me.localDsTable s1.tblJobCustom er, "pkJobCustomerI d")
Me.txtJobNumber .DataBindings.A dd("Text",
Me.localDsTable s1.tblJobCustom er, "JobNumber" )
Me.txtJobDescri ption.DataBindi ngs.Add("Text",
Me.localDsTable s1.tblJobCustom er, "JobDescription ")
Me.txtShopPSI.D ataBindings.Add ("Text",
Me.localDsTable s1.tblJobCustom er, "ShopPsi")
Me.chkApproved. DataBindings.Ad d("Checked",
Me.localDsTable s1.tblJobCustom er, "Approved")

_bmb = Me.BindingConte xt(Me.localDsTa bles1.tblJobCus tomer)
_bmb.Position = 0
End Sub

End Class
=== End Code 1 ===

I have also tried this code for the btnNewRecord with no success.

=== Code 2 ===
Private Sub btnNewRecord_Cl ick(ByVal sender As System.Object, ByVal
e As System.EventArg s) Handles btnNewRecord.Cl ick

'Add a row and go to it
Me.BindingConte xt(Me.DataSet1. *Customers).Add New()
Me.BindingConte xt(Me.DataSet1. *Customers).Pos ition = _
Me.DataSet1.Cus tomers.Rows.Cou *nt - 1
End Sub
=== End Code 2 ====

I want to be able to edit the new row with my bound textboxes. What can
I do to correct the behavior and have the selected datagrid row become
the newly created row?

- Doug

[Cor Ligthert]

Doug,

When you show something, than delete all duplicates and try to not to use
all kind of synonimes of tables. At first sight I will see looking at what
you are showing that you are binding apples and pears.

However I made a little simple sample for you. Try that.

\\\needs a datagrid and two buttons on a form
Dim cma As CurrencyManager
Dim dv As DataView
Private Sub Form1_Load(ByVa l sender As System.Object, _
ByVal e As System.EventArg s) Handles MyBase.Load
Dim dt As New DataTable
Button1.Text = "New"
Button2.Text = "Accept"
dt.Columns.Add( "Name")
dt.LoadDataRow( New Object() {"Dough"}, True)
dt.LoadDataRow( New Object() {"Peter"}, True)
dt.LoadDataRow( New Object() {"Cor"}, True)
dv = dt.DefaultView
DataGrid1.DataS ource = dv
dv.AllowNew = False
dv.AllowEdit = False
cma = DirectCast(Bind ingContext(dv), CurrencyManager )
TextBox1.DataBi ndings.Add("Tex t", dv, "Name")
End Sub

Private Sub Button1_Click(B yVal sender As System.Object, _
ByVal e As System.EventArg s) Handles Button1.Click
dv.AllowNew = True
cma.AddNew()
dv.AllowNew = False
End Sub

Private Sub Button2_Click(B yVal sender As System.Object, _
ByVal e As System.EventArg s) Handles Button2.Click
cma.EndCurrentE dit()
End Sub
///

I hope this helps a little bit?

Cor