Simple Gridview DrillDown Help

[cojiro]

I'm relativly new to ASP.net so I'm really just looking for some advice/direction. I have currently built a page that returns a summary report in a gridview control based on user input date ranges. I basically just set the datasource to an SQL statement and bound the columns to the fields. It looks something like like this:

Company | State | Amount | Count
XXXX XX XXXX XXX
YYYY YY YYYY YYY

I would like to improve this by allowing the users to drill down to the detail by clicking on a row/button so that the report could look like this:

Company | State | Amount | Count | Detail
XXXX XX XXXX XXX ======
Name | Amount
XXXX XXXXX
XXXX XXXXX
YYYY YY YYYY YYY

Can someone tell me the easiest way to do this? I've been looking around the web and most of the things I've looked at seem extremely complicated. Note: All of the detail includes millions of rows so I would only want to retrieve the minimum amount of records.

Thanks for your help.

 

[kss444]

What you want is a Master/Detail. There are plenty of examples on the web.
Do a google search on "master Detail with datagrid" Also there are many differnt was of creating this as far as looks and feel.

 

[cojiro]

Thanks for pushing me in the right direction. I'll give this a shot.