Populate parent child relationship data in Windows Form DataGridView using C# and VB.Net

Hi Everyone

I would like to know with example about how to populate DataGridView from a parent-child relationship.

From example: i have a table customer where customer_ID column reside

Another table i have Ordertable where Customer_ID (with different name in Order table) column exist as foreign key.

I would to know how to populate Custer information from CustomerTable when i expand that row it will give me details about customer what he ordered.

Thank you sir.

kindly explain with a live example.

I will be thankful to you all.