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.