Hi there everyone.  I am using VS 2003 on Framework 1.1. ASP.NET and VB.NET

 
Anyway, I would like to get some ideas from you on how I am going to implement this.

 

I want to design a master-detail datagrid.  I know how to populate the datagrid already with data from a database table (either by dataset or datareader).  What i want to do next is on the master datagrid, when the I click on the row, its details would be displayed on a datagrid detail.

 

I want to know what event should I be coding to in the master datagrid to be able to select the row clicked and highlight it as well and then retrieve the data from that row so as to display it in the datagrid detail.

 

Summing up:

MasterDataGrid - row should be highlighted where user clicks, an event is fired up to display the data.  I wish to know which event i would put my code so as to get the details of the highlighted row and get the data there (let us say, the primary key of the data).  Retrieving the detail should be no problem once I am able to get the primary key of the master datagrid.

 

Thanks everyone.
 

Follow up on this question.

This is my idea.

When I click on datagrid1, I want that the said row be highlighted. Accesing the data is no problem  The problem is where will I map the clicked / highlighted event so that each time a change in the highlighted row is detected, the detail datagrid would retrieve based on the master key on the master datagrid.

Thanks for all possible inputs.

Is this what you are looking for? (take a look at the second screenshot on the page in regards to "milestone")

http://limingxu.com/blogs/xu_web_chronicle/archive/2007/03/16/645.aspx

If it is, then the way we did is a hack and we didnt' use server sided solution, instead we used javascript.

Basically, we render the "detail" view with style="display:none" inside a div in each row as it renders the grid. When you click on the expand/collpase, we use javascript to

1. Get the "detail hidden div" from each row.
2. Clone it
3. Dynamically create a row using javascript directly after the current row
4. Insert the detail hidden div inside of the newly created row

The detail of it is a bit more complicated.

I know it's not much of help without some code, but hopes that gives you some reference as how it can be done.