Master table and child table in 2 gridview

Question

0.00/5 (No votes)

See more:

Dear all,

have a form with 2 gridviews.

one gridview is for the parent and the other gridview is for the transaction of the selected master record.

How do you link the tables such that on selection of a record from the master gridview it will populate the child gridview with details of only the transactions of the selected master details.

Assuming the master table has the following details idno, name , age.

and the child has the following idno, name , transaction_date, amount

How do you link the 2 tables to populate their repective gridviews

I have built the various gridviews and they are all being populated with the entire records in

each table.

I need to now do the ink.

Please assist or any reference will be acceptable

Thanks

.

Posted 4-Sep-14 8:14am

Member 10744248

Add a Solution

2 solutions

Solution 1

See below page:
http://msdn.microsoft.com/en-us/library/aa479344[^]
http://msdn.microsoft.com/en-us/library/aa992038.aspx[^]

Posted 4-Sep-14 15:20pm

David Lee 145

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

George Jonsson · Accepted Answer · 2014-09-04T15:46:00

Not sure if you are using Windows Forms or ASP.net, but if you are using Forms you should use the class BindingSource.

BindingSource Class[^]

If you have a DataSet, dsExample, with two data tables, MasterTable and ChildTable, which have a parent child relation named MasterTable_ChildTable, you create two binding sources.

C#

// You don't usually do these steps manually, but in the property grid
// for each BindingSource in Visual Studio.
// Then you will get a dropdown list for each property.
// This is just to show the principle.
BindingSource bsMaster = new BindingSource();
bsMaster.DataSource = dsExample;
bsMaster.DataMember = "MasterTable";

BindingSource bsChild = new BindingSource();
bsChild.DataSource = bsMaster;
bsChild.DataMember = "MasterTable_ChildTable";

dataGridMaster.DataSource = bsMaster;
dataGridChild.DataSource = bsChild;

Now the values in your datagrid with child data should change when you change rows in the master grid.

I hope this will help you on the way.