B
Brad Shook
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("TblPeople").Columns("UniqueId"),
_
childColumn:=Me.DataSetWellMobile1.Tables("TblWellMobileInfo").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
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("TblPeople").Columns("UniqueId"),
_
childColumn:=Me.DataSetWellMobile1.Tables("TblWellMobileInfo").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