First of all thinks to Cor Ligthert for helping me with this last week.
If you wild like to read Cor's comments please refer to the posting from
10/14/2004 and 8:48AM "Help with Advanced Datagrid"
I am trying to bind one column of a datagrid to a seperate textbox and
the rest of the fields to a datagrid. the comments are too large to
fit in a datagrid so I created a textbox below the datagrid and need
it to hold the data for the current record selected in the datagrid.
Here is a part of the code.
'DataSetWellMobile1 is the dataset with all the data
'DGWellResults is the dtagrid I am binding the data to
'txtWellComments is the textbox that I need bound
Me.DataSetWellMobile1.Relations.Add( _
New DataRelation( _
relationName:="relWellInfo", _
parentColumn:=Me.DataSetWellMobile1.Tables("TblPeo ple").Columns("UniqueId"),
_
childColumn:=Me.DataSetWellMobile1.Tables("TblWell MobileInfo").Columns("Pers
onId"),
_
createConstraints:=True))
Me.DGWellResults.DataBindings.Add(New Binding("DataSource",
Me.DataSetWellMobile1.TblPeople.DefaultView, "relWellInfo"))
Me.txtWellComments.DataBindings.Add(New Binding("Text",
DataSetWellMobile1.TblPeople.DefaultView, "relWellInfo.Comments"))
The code binds everything but the currency manager does not change the
textbox to the next record when I select on the next record in the
datagrid.
The data structure is
Parent Datagrid
Child Datagrid
textbox linked to child datagrid
What am I missing.
Thanks,
Brad