Hi .net_junkie,
protected void dg_ItemCommand(object source, DataGridCommandEventArgs e)
{
string str = dg.DataKeys[e.Item.ItemIndex].ToString();
string sql = "select * from table where id = " + str;
//query database and bind the resultset to another datagrid
}
<asp:DataGrid DataKeyField="Id" runat="server" ID="dg" OnItemCommand="dg_ItemCommand" >
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server">LinkButton</asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>