VB.Net - DataGrid Scroll and Show Detail

Good Day Experts!

I have a DataGrid with "higher" level data in the rows.  I want to be able to show the "detail" level data related to each row in another DataGrid while automatically iterating through the DataGrid with a button click to start the process.  

I don't think I can hit the database each time I get to a new row of the "higher" level data.  It "feels" like I need to have all the potential detail local in a DataTable.  There will be about 300 records of "higher" level data and probably like 900 records of "detail" level data at the most.

Can anyone think of a way I could achieve this? Please ask questions as my explanation may not be clear.

Thanks,
jimbo99999
Jimbo99999Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongCommented:
perhaps you can read and test the scripts in this article:

Walkthrough: Creating a Master/Detail Form Using Two Windows Forms DataGridView Controls
https://msdn.microsoft.com/en-us/library/vstudio/y8c0cxey(v=vs.100).aspx

alternatively, you can read this and see if there's any helps

Master Detail Datagridview
http://www.codeproject.com/Tips/835501/Master-Detail-Datagridview
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jimbo99999Author Commented:
Thanks I will take a look.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.