set datasource of details view in code behind

[Kashif Imran]

I need to show list of questions in grid and their answers in details view when a person expnads question item. Below is how I set datasource of radGrid. How can i set the datasource of nested details grid now?

protected void ShowQuestions()

 

{

 

try

 

 

 

 

{

 

    this.radGridQuestions.DataSource = this.questions;

 

}

 

 

catch

 

 

 

 

{

}

}

 

<

 

tk:RadGrid ID="radGridQuestions" runat="server" AutoGenerateColumns="False" ShowHeader="false" GridLines="None">

 

 

<MasterTableView DataKeyNames="Id">

 

 

<Columns>

 

 

<tk:GridTemplateColumn>

 

 

<ItemTemplate>

 

 

<table>

 

 

<tr>

 

 

<td style="width: 30px; vertical-align: top;">

 

 

<img src="<%# PostStatusImage(Container.DataItem)%>" alt="PostStatus" />

 

 

</td>

 

 

<td style="vertical-align: top;">

 

 

<asp:LinkButton ID="lbViewQuestion" runat="server" Text='<%# Eval("Title") %>' CommandArgument='<%# Eval("Id") %>'

 

 

CommandName="ViewQuestion"></asp:LinkButton>&nbsp; Posted On:&nbsp;<%# Eval("PostedDate") %>

 

 

</td>

 

 

</tr>

 

 

</table>

 

 

</ItemTemplate>

 

 

</tk:GridTemplateColumn>

 

 

</Columns>

 

 

<DetailTables>

 

 

<tk:GridTableView runat="server" DataKeyNames="Id">

 

 

<ParentTableRelation>

 

 

<tk:GridRelationFields DetailKeyField="ParentThreadId" MasterKeyField="Id" />

 

 

</ParentTableRelation>

 

 

<DetailTables>

 

 

</DetailTables>

 

 

</tk:GridTableView>

 

 

</DetailTables>

 

 

</MasterTableView>

 

 

</tk:RadGrid>

 

[Princy]

Hello Kashif,

You can try out the following code to bind your detail table on expanding a row in the MasterTableView:
c#:

protected void radGridQuestions_PreRender(object sender, EventArgs e)
    {
       foreach (GridDataItem item in radGridQuestions.MasterTableView.Items)
        {
            if (item.Expanded)
            {
                GridTableView nestedView = (GridTableView)item.ChildItem.NestedTableViews[0];
                nestedView.DataSource = " ";//set the datasource here

            }
        }
   }

Thanks
Princy.

[Kashif Imran]

 

 

 

Thanks that worked, but I had to make one small change. If I dont do "nestedView.DataBind();" it always binds parent list to each nested view. But after adding nestedView.DataBind(); it works.

Why do I have to call DataBind where?

if (item.Expanded)

 

{

 

long pid = Convert.ToInt64(item.GetDataKeyValue("Id"));

 

 

List<ChildThread> list = this.GetChildren(pid);

 

 

GridTableView nestedView = (GridTableView)item.ChildItem.NestedTableViews[0];

 

nestedView.DataSource = list;

//CHANGED I HAD TO MAKE
nestedView.DataBind();

}

 

 

 

 

[Sebastian]

Hello Kashif,

The more appropriate place to bind nested table to data is the DetailTableDataBind event handler of the grid as illustrated on this online demo:

http://demos.telerik.com/aspnet-ajax/grid/examples/programming/detailtabledatabind/defaultcs.aspx

Thus when you have HierarchyLoadMode = ServerOnDemand (default load mode for hierarchy) only the detailed tables for the expanded parent items will be bound to data.

Alternatively, you can use NestedView template and show/hide the panel with the nested view content dynamically as shown on this online demo:

http://demos.telerik.com/aspnet-ajax/grid/examples/hierarchy/nestedviewtemplate/defaultcs.aspx

Kind regards,

Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.