Get Data from one Grid to another

[Karl Napp]

I have two tables:
The first is "house" with the columns "house_id" and "house_name".
The second is "room" with "house_id", "room_id", "room_name".

Now, I have two DataGrids. The first should only show the "house_name" and
OnClick it should be able to send the "house_id" to a method that will fill
the second DataGrid.

I have tried <asp:buttoncolumn datatextfield="house_name"> to show the name
but I am not able to retrieve the id to send it to my method :-(


Any help appreciated,
KN

 

[Jos]

I have two tables:
The first is "house" with the columns "house_id" and "house_name".
The second is "room" with "house_id", "room_id", "room_name".

Now, I have two DataGrids. The first should only show the
"house_name" and OnClick it should be able to send the "house_id" to
a method that will fill the second DataGrid.

I have tried <asp:buttoncolumn datatextfield="house_name"> to show
the name but I am not able to retrieve the id to send it to my method
:-(

Set DataKeyField="house_id" for the first datagrid.

Set the CommandName="Select" for your buttoncolumn.

In the OnSelectedIndexChanged event of the first datagrid
(NOT the OnClick event of the button), use this expression to
retrieve the house_id:

selectedHouseID = DataGrid1.DataKeys(e.Item.ItemIndex)

With this ID, bind your second datagrid.

You can also find a complete template in Web Matrix (use the Master/Detail
Data template).

 

[Karl Napp]

selectedHouseID = DataGrid1.DataKeys(e.Item.ItemIndex)

I do get a compiler error when trying to access
"e.Item"

This seems to be due to the follwing wire-up:

this.Houses.SelectedIndexChanged += new
System.EventHandler(this.Houses_SelectedIndexChanged);

But when I cange it to

this.Houses.SelectedIndexChanged += new
System.Web.UI.WebControls.DataGridCommandEventHandler(this.Houses_SelectedIn
dexChanged);

This doesn't help any further...

You can also find a complete template in Web Matrix (use the Master/Detail
Data template).

Is it possible to download this for VS.Net, too?


Thank you
KN