Do you think it is tough to deal with or display a huge volume of interrelated data in a single data grid? If so, then you haven’t tried out our DataGrid. This blog post will show you how easily you can visualize data in a master-detail hierarchy in a single grid view in Blazor.
So, what is this term, master-detail view? Let’s look at a real-time example. If a company is recording its employee details from its sales department, it would only make sense to categorize and show them in a meaningful way. The company could categorize their data meaningfully based on personal details, lists of sales orders, contact address, their meeting schedules with customers, and so on.
Here, the list of salesperson names displayed with limited details in the top grid UI is referred to as the “master” data view. The relevant information of the selected master data item will be shown inside the “detail” area.
First, let me list out the Syncfusion Blazor components that I’m going to use to design this master-detail view.
I’ll be using a Blazor DataGrid component to design the top-level master grid UI view with limited fields like each salesperson’s name, designation, city and phone number.
To design the detail view, I’ll be using the following list of Blazor components:
DataGrid: To display the sales order-related data of the selected salesperson from a master view.
Maps: To visualize the location and contact address of a salesperson.
Scheduler: To display the meeting schedules of a salesperson with their customers.
Customized template: To show the personal information of a salesperson.
Tabs: To place all these components as individual tab items inside the Tabs component.
Now, let’s dive in deep and see how to design the master-detail view using these Syncfusion Blazor components.
I’m going to build four model classes to employ in this master-detail view creation:
The Salesperson model class acts as a master data source, whereas the other model classes, Orders, Location, and MeetingSchedule, act as children of the Salesperson model. I’m categorizing the data in this way to present them in a one-to-many kind of relationship.
Let me create a Blazor server app and add the required model classes first. I’ll create a new model class file inside the Data folder with the name Salesperson. In this class file, I’ll add the class definitions for the previously listed four classes with the required properties and methods to generate appropriate data, which you can reference from this GitHub repository.
After creating the required model classes, access them inside the index.razor component under the pages folder, where I’m planning to design the master-detail grid view. Add the following @code directive in the index.razor file.
@code {
private List<Salesperson> Employees;
private List<Location> MapPoints;
private List<MeetingSchedule> ScheduleData;
protected override void OnInitialized()
{
Employees = Salesperson.GetSalesperson();
MapPoints = Location.GetLocation();
ScheduleData = MeetingSchedule.GetMeetingData();
}
}
To design the master view, we should add the Syncfusion Blazor DataGrid component to the created Blazor app. You’ll also need to preconfigure this project to start using Syncfusion Blazor components by referring to this Getting Started page or a quick-start video about Blazor DataGrid.
Add the following code example in index.razor file to create a master grid and bind the salesperson data source to it by assigning the @Employees object variable to the DataSource property of SfGrid.
<SfGrid Width="1200px" DataSource="@Employees">
<GridColumns>
<GridColumn Field=@nameof(Salesperson.FirstName) HeaderText="Name" Width="110"></GridColumn>
<GridColumn Field=@nameof(Salesperson.Title) HeaderText="Title" Width="110"></GridColumn>
<GridColumn Field=@nameof(Salesperson.City) HeaderText="City" Width="110"></GridColumn>
<GridColumn Field=@nameof(Salesperson.Phone) HeaderText="Phone" Width="110"></GridColumn>
</GridColumns>
</SfGrid>
This will display the flat master-detail view, as depicted in this following image.
Now, for each of these master rows, we need to display the detailed information when the user selects a particular master row. To do so, use the detail template feature of DataGrid. The additional information will be displayed while expanding or collapsing the selected master row.
Inside the SfGrid tag, add the DetailTemplate and then place the required components inside it directly. In the following code example, you can see the Tab component is initially being placed and then the other components are added one by one inside it.
<SfGrid Width="1200px" DataSource="@Employees">
<GridTemplates>
<DetailTemplate>
<SfTab Height="350" HeaderPlacement="HeaderPosition.Top">
<TabItems> </TabItems>
</SfTab>
</DetailTemplate>
</GridTemplates>
<GridColumns>
<GridColumn Field=@nameof(Salesperson.FirstName) HeaderText="Name" Width="110"></GridColumn>
<GridColumn Field=@nameof(Salesperson.Title) HeaderText="Title" Width="110"></GridColumn>
<GridColumn Field=@nameof(Salesperson.City) HeaderText="City" Width="110"></GridColumn>
<GridColumn Field=@nameof(Salesperson.Phone) HeaderText="Phone" Width="110"></GridColumn>
</GridColumns>
</SfGrid>
NOTE: Make sure to import the appropriate namespaces inside the _imports.razor file to start using components like Maps, Scheduler, Tab, and DataManager in this example.
Before proceeding to add the child components, access the details of the currently selected master grid record using the context variable inside the detail template. Then make use of this context object to access the other column values of the currently selected row throughout the design of this detailed view. Also, filter the location data based on the currently selected employee ID, which will then be bound to the Maps component.
<SfGrid Width="1200px" DataSource="@Employees">
<GridTemplates>
<DetailTemplate>
@{
Salesperson Employee = context as Salesperson;
List<Location> MapDatum = MapPoints.Where(p => p.name == Employee.City).ToList();
}
<SfTab Height="350" HeaderPlacement="HeaderPosition.Top">
<TabItems> </TabItems>
</SfTab>
</DetailTemplate>
</GridTemplates>
Now, create four tab items and place each child component in one. In the first tab, simply display the customized personal information about the selected salesperson. For that, access the details using the context variable Employee and then make the necessary customizations. Also apply a few style definitions to achieve this customized look inside the <style> section.
<SfGrid Width="1200px" DataSource="@Employees">
<GridTemplates>
<DetailTemplate>
<SfTab Height="350" HeaderPlacement="HeaderPosition.Top">
<TabItems>
<TabItem>
<ChildContent>
<TabHeader Text="Personal Info"></TabHeader>
</ChildContent>
<ContentTemplate>
<div>
<div style="float:left;padding:45px;padding-top:70px"><img class="photo" src="@UriHelper.ToAbsoluteUri($"https://blazor.syncfusion.com/demos/images/Grid/{Employee.EmployeeID}.png")" alt="@Employee.EmployeeID" /></div>
<div style="padding-top:42px">
<span style="font-size: x-large;font-weight: bold;">@Employee.FirstName @Employee.LastName</span><br />
<h6 style="font-weight:400 ;">@Employee.Title</h6><br />
<span class="title">Country:</span> <span class="content">@Employee.Country</span><br />
<span class="title">Postal Code:</span> <span class="content">@Employee.Postal</span><br />
<span class="title">Mail:</span> <span class="content">@Employee.Email</span>
</div>
</div>
</ContentTemplate>
</TabItem>
</TabItems>
</SfTab>
</DetailTemplate>
</GridTemplates>
Note: Make sure to inject the Microsoft.AspNetCore.Components.NavigationManager in index.razor file to work with URIs and navigation in C# code.
Check the following screenshot to see how it displays the customized information of the selected row.
In the second tab item, add a child grid to display the sales order details of the selected person. In this child DataGrid, retrieve the orders data from a remote data source. For this, make use of the DataManager component. Also define a Query property to filter the order details based on the currently selected master data’s employee ID value, so that only those filtered records from the Orders table will be bound to the child DataGrid.
<TabItem>
<ChildContent>
<TabHeader Text="Sales Details"></TabHeader>
</ChildContent>
<ContentTemplate>
<div style="padding:25px">
<SfGrid Width="740px" TValue="Orders" Query="@(new Query().Where("EmployeeID", "equal", Employee.EmployeeID))" AllowPaging="true">
<GridPageSettings PageSize="4"></GridPageSettings>
<SfDataManager Url="https://js.syncfusion.com/demos/ejservices/Wcf/Northwind.svc/Orders" CrossDomain="true"></SfDataManager>
<GridColumns>
<GridColumn Field=@nameof(Orders.OrderID) HeaderText="ID" Width="50"> </GridColumn>
<GridColumn Field=@nameof(Orders.ShipName) HeaderText="Name" Width="110"></GridColumn>
<GridColumn Field=@nameof(Orders.ShipCity) HeaderText="City" Width="90"></GridColumn>
<GridColumn Field=@nameof(Orders.OrderDate) HeaderText="Date" Format="d" Type="ColumnType.Date" TextAlign="TextAlign.Right" Width="70"></GridColumn>
<GridColumn Field=@nameof(Orders.Freight) HeaderText="Order Value" Format="c2" TextAlign="TextAlign.Right" Width="70"></GridColumn>
</GridColumns>
</SfGrid>
</div>
</ContentTemplate>
</TabItem>
This will display the order details in a child data grid as shown in the following image.
In the third tab item, add the Maps component to visualize the location of the currently selected master data item. Also, display the customized address information beside the Maps component. Here, assign the filtered location data to the data source of Maps component by accessing the variable @MapDatum which was initialized during the context variable creation.
<DetailTemplate>
@{
Salesperson Employee = context as Salesperson;
List<Location> MapDatum = MapPoints.Where(p => p.name == Employee.City).ToList();
}
<TabItem>
<ChildContent>
<TabHeader Text="Contact Address"></TabHeader>
</ChildContent>
<ContentTemplate>
<div style="padding:25px">
<div style="height:260px;width:450px;float:left">
<SfMaps>
<MapsCenterPosition Latitude="@MapDatum[0].latitude" Longitude="@MapDatum[0].longitude"></MapsCenterPosition>
<MapsZoomSettings Enable="false" ZoomFactor=10></MapsZoomSettings>
<MapsLayers>
<MapsLayer LayerType="ShapeLayerType.OSM" AnimationDuration=0>
<MapsMarkerSettings>
<MapsMarker Visible="true" DataSource="@MapDatum" Height='30' Width='30' Shape='Syncfusion.Blazor.Maps.MarkerType.Image' ImageUrl='https://blazor.syncfusion.com/demos/styles/images/maps/ballon.png'>
</MapsMarker>
</MapsMarkerSettings>
</MapsLayer>
</MapsLayers>
</SfMaps>
</div>
<div style="width:265px;float:left;padding:40px">
<h4>Contact Address:</h4>
<span>@Employee.Address</span>,<br />
<span>@Employee.City</span>,<br />
<span>@Employee.Country</span><br />
<span>Phone: </span><span>@Employee.Phone</span>
</div>
</div>
</ContentTemplate>
</TabItem>
The following screenshot shows the Maps component depicting the current location of the selected master data item.
Finally, in the fourth tab item, add the Scheduler component to display the meeting schedules of the currently selected master data item. To display the meeting schedules, bind the Scheduler data source with the @ScheduleData variable by accessing data from the MeetingSchedule model class. Also, set a Query property to filter the appointment data based on the currently selected master record’s employee ID value. The following code example illustrates this.
<TabItem>
<ChildContent>
<TabHeader Text="Meeting Schedules"></TabHeader>
</ChildContent>
<ContentTemplate>
<div style="width:450px;padding:25px">
<SfSchedule TValue="MeetingSchedule" Height="260px" SelectedDate="new DateTime(2020, 3, 2)" CurrentView="View.Agenda">
<ScheduleEventSettings DataSource="@ScheduleData" Query="@(new Query().Where("EID", "equal", Employee.EmployeeID))"></ScheduleEventSettings>
</SfSchedule>
</div>
</ContentTemplate>
</TabItem>
The following screenshot displays the meeting schedules of the currently selected salesperson in an Agenda view.
I hope now you can add and display further relevant information in separate tabs inside the detail view for the currently selected master record. You can easily add any of the Blazor UI components inside the detail template of the master DataGrid. For example, you can also visualize a sales report in a chart by displaying it in another tab item, which you can learn how to do in this demo.
You can download the complete source code of this example from the GitHub repository. I hope this blog post helped you understand the master-detail views and now you can start to create your own master-detail view using Syncfusion Blazor components with minimal lines of code.
Try our Blazor DataGrid component by downloading a free 30-day trial or from our NuGet package. Feel free to have a look at our online examples and documentation to explore other available features. If you have any questions, please let us know in the comments section below. You can also contact us through our support forum or Direct-Trac. We are always happy to assist you!