asked on

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

adriankohws

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.

ASKER CERTIFIED SOLUTION

venkataramanaiahsr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

adriankohws

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??

venkataramanaiahsr

ASKER

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