Solved

How to link DataGridViews in VB .NET

Posted on 2013-01-02
3
264 Views
Last Modified: 2013-01-03
Hello,

I have 2 tables which contains Orders and ProductOrders, the table ProductOrders has the OrderID as Foreign Key.

Ordertable:
ID            OrderNo             Client            Date
1               123                     X                    01-01-2013
2               135                     Y                    01-01-2013

ProductOrders:
ID              OrderID            ProductName        Ordered
1                1                       Bike                         2
2                1                       Wheels                    2
3                2                       Steering                  1
4                2                       Brakes                     3

I have build a Form with 2 Datagridviews which are linked to datasets which are filled thru a Dataset adapter. DataGrid1 contains the Orders, and DataGrid2 contains the ProductOrders. How can i link the Datagrids to each other so that when i select order1 in Datagrid1, Datagrid2 shows the ProductOrders of the selected order?

Can anyone point me to an example?
0
Comment
Question by:marco_greven
  • 2
3 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 38737046
0
 
LVL 22

Accepted Solution

by:
plusone3055 earned 500 total points
ID: 38737051
0
 

Author Closing Comment

by:marco_greven
ID: 38739957
Thanks for the link...
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question