This sample illustrates a Hierarchical grid in Server mode.
OrderID | ProductID | UnitPrice | Quantity | Discount | ||
|---|---|---|---|---|---|---|
| No records to display |
Order ID | Employee ID | Customer ID | Order Date | Freight | |||
|---|---|---|---|---|---|---|---|
| 10248 | 5 | VINET | 7/4/1996 12:00:00 AM | 32.3800 | ||
| 10249 | 6 | TOMSP | 7/5/1996 12:00:00 AM | 11.6100 | ||
| 10250 | 4 | HANAR | 7/8/1996 12:00:00 AM | 65.8300 | ||
| 10251 | 3 | VICTE | 7/8/1996 12:00:00 AM | 41.3400 | ||
| 10252 | 4 | SUPRD | 7/9/1996 12:00:00 AM | 51.3000 | ||
| 10253 | 3 | HANAR | 7/10/1996 12:00:00 AM | 58.1700 | ||
| 10254 | 5 | CHOPS | 7/11/1996 12:00:00 AM | 22.9800 | ||
| 10255 | 9 | RICSU | 7/12/1996 12:00:00 AM | 148.3300 | ||
| 10256 | 3 | WELLI | 7/15/1996 12:00:00 AM | 13.9700 | ||
| 10257 | 4 | HILAA | 7/16/1996 12:00:00 AM | 81.9100 | ||
| 10258 | 1 | ERNSH | 7/17/1996 12:00:00 AM | 140.5100 | ||
| 10259 | 4 | CENTC | 7/18/1996 12:00:00 AM | 3.2500 |
Features:
<%=Html.Syncfusion().Grid("GridSrc")
.Datasource(Model)
.Caption("Order Grid")
.AutoFormat(Skins.Monochrome)
.ChildGrid(child =>
{
child.ChildGridTemplate(Html.Syncfusion().Grid("ChildGrid_${OrderID}")
.ParentRelationKey(new string[] { "CustomerID" })
.ToChildGridTemplate());
})
%>
In the Controller, post ActionResult with the ID and send the data source for the parent or child grid.
public ActionResult Index(PagingParams args, string CustomerID)
{
if (args.ID.Contains("ChildGrid"))
{
IEnumerable data = new NorthwindDataContext().Customers.Where(c => c.CustomerID == CustomerID).ToList();
return data.GridActions();
}
else
{
var ordersData = new NorthwindDataContext().Orders.Take(60).ToList();
return ordersData.GridActions();
}
}
For more information, please visit our Hierarchy Grid Documentation :
Hierachy Grid