• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

Programatically Updating Bound child datagridview

I have two DataGridViews on a form in a parent-child relationsihp. The parent dgv is bound to a BindingSource whose DataSource is a table. The child dgv is bound to a BindingSource whose DataSource is the parent BindingSource and whose DataMember is the relation between the parent and child tables in the DataSet.

Parent Grid (dgvOEntryAdvise)
bindingsource11.DataSource = dsDet.Tables("OIAdviseDetails")
dgvOEntryAdvise.DataSource = bindingsource11

Child Grid ( dgvOSAdvise)
  bindingsource13.DataSource = bindingsource11 'dsDet.Tables("OSAdviseDetails") '
   bindingsource13.DataMember = "FK_OS_OI_Advise"
   dgvOSAdvise.DataSource = bindingsource13


dtOEntry = dsDet.Tables("OIAdviseDetails")  --
table bound to parent dgv (dgvOEntryAdvise)

Dim newrow As DataRow = dtOEntry.NewRow()
newrow.BeginEdit()
 newrow("Caseid") = lngcaseid
 newrow("OCCode") = dgvOIList.CurrentRow.Cells("Occode").Value
 newrow("OCName") = dgvOIList.CurrentRow.Cells("OCName").Value
 newrow("OICode") = dgvOIList.CurrentRow.Cells("OICode").Value
newrow("OIName") = dgvOIList.CurrentRow.Cells("OIName").Value
newrow.EndEdit()
dtOEntry.Rows.Add(newrow)

(Upto this it is working fine)

for some order item in parent grid i want to add programatically few child rows in the child datagrid ...

Pls advise on how to do this
0
venkataramanaiahsr
Asked:
venkataramanaiahsr
  • 2
  • 2
1 Solution
 
adriankohwsCommented:
When you use parent and child relationship and binding, how are you be able to add rows yourself?

I don't know why you wish to add rows but you can only add them to the binding source and rebind the child datagridview.
0
 
venkataramanaiahsrAuthor Commented:
I could solve it by other means. i got the both parent and child data into single grid by join
statement and it solved my problem
0
 
adriankohwsCommented:
I have no objection against what you said but it isn't a solution. If at the first place you can combine two relationship into one row display, then this question does not stand. There's a reason to have master detail. Imagine one master record can have 30 rows of details, show them in one grid??
0
 
venkataramanaiahsrAuthor Commented:
I could solve it by other means. i got the both parent and child data into single grid by join
statement and it solved my problem
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now