hierarchical gridview expand 3 level

[Ilaya]

Dear All,

i have created Telerik Hierarchy Rad Gridview.

>> first level Employee Name

>> second level Employee Role

>> third level Employee Designation

but i am using single table. EmployeeMaster(only one table)

i want out put:

Employee Name
                     (expand) Employee role
                                    (expand) Employee Designation

[Attila Antal]

Hi Ilaya,

Here is an example you can try. 

RadGrid markup:

<telerik:RadGrid ID="RadGrid1" runat="server" Width="800px"
    OnDetailTableDataBind="RadGrid1_DetailTableDataBind"
    OnNeedDataSource="RadGrid1_NeedDataSource">
    <MasterTableView Name="Name" DataKeyNames="ID" AutoGenerateColumns="false">
        <Columns>
            <telerik:GridBoundColumn DataField="Name" HeaderText="Employee Name"></telerik:GridBoundColumn>
        </Columns>
        <DetailTables>
            <telerik:GridTableView Name="Role" DataKeyNames="ID" AutoGenerateColumns="false">
                <Columns>
                    <telerik:GridBoundColumn DataField="Role" HeaderText="Employee Role"></telerik:GridBoundColumn>
                </Columns>
                <DetailTables>
                    <telerik:GridTableView Name="Designation" DataKeyNames="ID" AutoGenerateColumns="false">
                        <Columns>
                            <telerik:GridBoundColumn DataField="Designation" HeaderText="Employee Designation"></telerik:GridBoundColumn>
                        </Columns>
                    </telerik:GridTableView>
                </DetailTables>
            </telerik:GridTableView>
        </DetailTables>
    </MasterTableView>
</telerik:RadGrid>

 

C# - code behind for binding data to Grid and Detail Tables programmatically

private DataTable EmployeeMaster()
{
    DataTable dt = new DataTable();

    dt.Columns.Add(new DataColumn("ID", typeof(int)));
    dt.Columns.Add(new DataColumn("Name", typeof(string)));
    dt.Columns.Add(new DataColumn("Role", typeof(string)));
    dt.Columns.Add(new DataColumn("Designation", typeof(string)));

    dt.PrimaryKey = new DataColumn[] { dt.Columns["ID"] };

    for (int i = 0; i < 3; i++)
    {
        int index = i + 1;

        DataRow row = dt.NewRow();

        row["ID"] = index;
        row["Name"] = "Name " + index;
        row["Role"] = "Role " + index;
        row["Designation"] = "Designation " + index;
            
        dt.Rows.Add(row);
    }

    return dt;
}

protected void RadGrid1_DetailTableDataBind(object sender, Telerik.Web.UI.GridDetailTableDataBindEventArgs e)
{
    var nestedViewItem = e.DetailTableView.NamingContainer as GridNestedViewItem;
    var parentRow = nestedViewItem.ParentItem as GridDataItem;
    var employeeID = (int)parentRow.GetDataKeyValue("ID");
        
    e.DetailTableView.DataSource = EmployeeMaster().Select(string.Format("ID={0}", employeeID)).CopyToDataTable();
}

protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
    if (!e.IsFromDetailTable)
        (sender as RadGrid).DataSource = EmployeeMaster();
}

 

Result

 

See also

• Telerik RadGrid Data Binding Basics - documentation
• What you should know about Hierarchy - documentation
• Understanding hierarchical grid structure - documentation
• Binding hierarchical grids - documentation
• Grid - Programmatic Hierarchy Binding - online demo

 

Kind regards,
Attila Antal
Progress Telerik