Datagrid binding problem

[no]

Hi all,

I have a dataset that contain 2 tables and a relationship between them
(master detail).
I bind this dataset to a form that include some textboxes that bind to the
parent record, and a datagrid that is binded to the detailed records.

Here is the code:

Code:
Private Sub FillHeader(ByRe f dsDataSet As DataSet)
Try
txtKey.DataBind ings.Add(New Binding("text", dsDataSet , "header.key "))
txtNo.DataBindi ngs.Add(New Binding("text", dsDataSet , "header.no" ))
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

Code:
Private Sub FillLines(ByRef dsDataSet As DataSet)
Try
dsDataSet.Table s("lines").Colu mns("key").Colu mnMapping =
MappingType.Hid den
dsDataSet.Table s("lines").Colu mns("product_id ").ColumnNa me = "Product
Id"
dsDataSet.Table s("lines").Colu mns("quantity") .ColumnName = "Quantity"
dgLines.SetData Binding(dsDataS et.Tables!lines , "HeaderLine s")
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

The sub I use to navigate is (For example I put only the next command):

Code:
Sub cmdNext() Implements ICommandNext.cm dNext
Try
bdRecordNavigat or = BindingContext( dsHeader, "header")
bdRecordNavigat or.Position += 1
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

My problem happens when I navigate between the master records. The textboxes
show the correct values, but there is no change in the datagrid. What do I
miss here, that this sub will handle the datagrid as well?

Thanks

[Ken Tucker [MVP]]

Hi,

You need to use datagrid.setdat abinding to get the child grid to
only display the filtered records.

http://www.vb-tips.com/default.aspx?...7-7bc3068aca2c

http://www.vb-tips.com/default.aspx?...e-e8335682ad3a

Ken
-----------------

"no" wrote:

Hi all,

I have a dataset that contain 2 tables and a relationship between them
(master detail).
I bind this dataset to a form that include some textboxes that bind to the
parent record, and a datagrid that is binded to the detailed records.

Here is the code:

Code:
Private Sub FillHeader(ByRe f dsDataSet As DataSet)
Try
txtKey.DataBind ings.Add(New Binding("text", dsDataSet , "header.key "))
txtNo.DataBindi ngs.Add(New Binding("text", dsDataSet , "header.no" ))
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

Code:
Private Sub FillLines(ByRef dsDataSet As DataSet)
Try
dsDataSet.Table s("lines").Colu mns("key").Colu mnMapping =
MappingType.Hid den
dsDataSet.Table s("lines").Colu mns("product_id ").ColumnNa me = "Product
Id"
dsDataSet.Table s("lines").Colu mns("quantity") .ColumnName = "Quantity"
dgLines.SetData Binding(dsDataS et.Tables!lines , "HeaderLine s")
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

The sub I use to navigate is (For example I put only the next command):

Code:
Sub cmdNext() Implements ICommandNext.cm dNext
Try
bdRecordNavigat or = BindingContext( dsHeader, "header")
bdRecordNavigat or.Position += 1
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

My problem happens when I navigate between the master records. The textboxes
show the correct values, but there is no change in the datagrid. What do I
miss here, that this sub will handle the datagrid as well?

Thanks

[Ohad Weiss]

Ken Tucker,
Thanks for your reply
The tips you supplyed heled me a lot.

All I had to do was to add a line before the catch statement that solved the
whole problem:
dgItems.SetData Binding(dsPOHea der, "purchase_order _header.POHeade rLines")

Thanks again

Ohad

"Ken Tucker [MVP]" <Ke**********@d iscussions.micr osoft.com> wrote in message
news:B5******** *************** ***********@mic rosoft.com...

Hi,

You need to use datagrid.setdat abinding to get the child grid to
only display the filtered records.

http://www.vb-tips.com/default.aspx?...7-7bc3068aca2c

http://www.vb-tips.com/default.aspx?...e-e8335682ad3a

Ken
-----------------

"no" wrote:

Hi all,

I have a dataset that contain 2 tables and a relationship between them
(master detail).
I bind this dataset to a form that include some textboxes that bind to
the
parent record, and a datagrid that is binded to the detailed records.

Here is the code:

Code:
Private Sub FillHeader(ByRe f dsDataSet As DataSet)
Try
txtKey.DataBind ings.Add(New Binding("text", dsDataSet ,
"header.key "))
txtNo.DataBindi ngs.Add(New Binding("text", dsDataSet , "header.no" ))
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

Code:
Private Sub FillLines(ByRef dsDataSet As DataSet)
Try
dsDataSet.Table s("lines").Colu mns("key").Colu mnMapping =
MappingType.Hid den
dsDataSet.Table s("lines").Colu mns("product_id ").ColumnNa me = "Product
Id"
dsDataSet.Table s("lines").Colu mns("quantity") .ColumnName = "Quantity"
dgLines.SetData Binding(dsDataS et.Tables!lines , "HeaderLine s")
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

The sub I use to navigate is (For example I put only the next command):

Code:
Sub cmdNext() Implements ICommandNext.cm dNext
Try
bdRecordNavigat or = BindingContext( dsHeader, "header")
bdRecordNavigat or.Position += 1
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

My problem happens when I navigate between the master records. The
textboxes
show the correct values, but there is no change in the datagrid. What do
I
miss here, that this sub will handle the datagrid as well?

Thanks

[Ohad Weiss]

Ken Tucker,
Thanks for your reply
The tips you supplyed heled me a lot.

All I had to do was to add a line before the catch statement that solved the
whole problem:
dgLines.SetData Binding(dsDataS et, "header.HeaderL ines")

Thanks again

Ohad

"Ken Tucker [MVP]" <Ke**********@d iscussions.micr osoft.com> wrote in message
news:B5******** *************** ***********@mic rosoft.com...

Hi,

You need to use datagrid.setdat abinding to get the child grid to
only display the filtered records.

http://www.vb-tips.com/default.aspx?...7-7bc3068aca2c

http://www.vb-tips.com/default.aspx?...e-e8335682ad3a

Ken
-----------------

"no" wrote:

Hi all,

I have a dataset that contain 2 tables and a relationship between them
(master detail).
I bind this dataset to a form that include some textboxes that bind to
the
parent record, and a datagrid that is binded to the detailed records.

Here is the code:

Code:
Private Sub FillHeader(ByRe f dsDataSet As DataSet)
Try
txtKey.DataBind ings.Add(New Binding("text", dsDataSet ,
"header.key "))
txtNo.DataBindi ngs.Add(New Binding("text", dsDataSet , "header.no" ))
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

Code:
Private Sub FillLines(ByRef dsDataSet As DataSet)
Try
dsDataSet.Table s("lines").Colu mns("key").Colu mnMapping =
MappingType.Hid den
dsDataSet.Table s("lines").Colu mns("product_id ").ColumnNa me = "Product
Id"
dsDataSet.Table s("lines").Colu mns("quantity") .ColumnName = "Quantity"
dgLines.SetData Binding(dsDataS et.Tables!lines , "HeaderLine s")
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

The sub I use to navigate is (For example I put only the next command):

Code:
Sub cmdNext() Implements ICommandNext.cm dNext
Try
bdRecordNavigat or = BindingContext( dsHeader, "header")
bdRecordNavigat or.Position += 1
Catch ex As Exception
HandleException s(ex)
End Try
End Sub

My problem happens when I navigate between the master records. The
textboxes
show the correct values, but there is no change in the datagrid. What do
I
miss here, that this sub will handle the datagrid as well?

Thanks