ListView with group headers
Let's say we want to implement a ListView with group headers, where each group is defined by a certain data column having the same value. In other words, each time the data column has a new value (proceeding from top to bottom), we want to have a special view that highlights that fact.
Introduction
The ListView control renders its ItemTemplate once for every item in its DataSource. As discussed in Grouping Data with the ListView Control, it is possible to insert a grouping template every N records. This flexibility allows for scenarios like displaying data in a multi-column table.
While the built-in grouping feature is certainly useful, when it comes to displaying data most people think of grouping to mean that records with similar attributes are lumped together. For instance, the Ticket Booking database contains information about an assortment of products, and each product has attributes likep PNR_NUMBER, NAME, MOBILE_NO, BOOKED_BY, BOARDING_POINT, FARE and so forth. While each NAME name is unique, many PNR_NO share the same Boarding point and BoardingPointTime. When someone says, "I want to group the PNR_NUMBER data," usually they mean they want to group it by one of these common attributes. The following screenshot shows the user interface people most people associate with the term grouping.
![Capture.JPG]( "Tripsheet")
![tripsheet]( "Tripsheet")
Unfortunately the ListView's grouping feature does not allow for this style of grouping. The good news is that with a few lines of code and markup we can construct such an interface. This article shows how to build a flexible grouping interface that allows the user to choose what data field to group the data by. Read on to learn more!
string LastBoardingPoint =string.Empty ;
public string AddGroupingRowIfBoardingHasChanged()
{
string values = string.Empty;
string CurrentBoardingPoint = Eval("BUS_BOARDING_POINT").ToString();
string boardingPointTime = Eval("START_TIME").ToString();
string Landmark = Eval("LAND_MARK").ToString();
if( CurrentBoardingPoint.Length==0)
{
CurrentBoardingPoint = "Unknown";
}
else
if(!LastBoardingPoint.Equals(CurrentBoardingPoint))
{
LastBoardingPoint = CurrentBoardingPoint;
values = String.Format("<tr class='groupheader'><td colspan='13'>Boarding Point : {0} - {1} ,{2} </td></tr>", CurrentBoardingPoint, boardingPointTime, Landmark);
}
else
{
values= string.Empty;
}
return values;
}
By adding the preceding databinding syntax we are instructing the ListView to call the AddGroupingRowIfBoardingHasChanged() each time it renders the ItemTemplate, that it will do once per record being bound to the ListView. The AddGroupingRowIfBoardingHasChanged() method, that we will create momentarily, will return either an empty string (in the case that the supplier name hasn't changed since the last product) or the HTML for a table row that announces the new BoardingPoint.
Next, create the AddGroupingRowIfBoardingHasChanged() method in the page's code-behind class. This method must return a string value and canont be marked Private (that is, it must be marked as Public or Protected). Keep in mind that this method is called once for every record being bound to the ListView. Add the following code:
<asp:ListView ID="lvDetails" runat="server" OnItemDataBound="lvDetails_ItemDataBound"
OnDataBound="lvDetails_DataBound">
<LayoutTemplate>
<table width="100%" border="1px" cellpadding="0" cellspacing="0" id="tripsheet">
<thead>
<tr>
<th>
SNo
</th>
<th>
Ticket No
</th>
<th>
Seat No
</th>
<th>
Passenger Name
</th>
<th>
Contact
</th>
<th>
Droping Point
</th>
<th>
Fare(Rs.)
</th>
<th>
Com.(Rs.)
</th>
<th>
Balance(Rs.)
</th>
<th>
Booked By
</th>
<th>
Booking Type
</th>
</tr>
</thead>
<tbody>
<tr id="itemPlaceHolder" runat="server">
</tr>
</tbody>
<tfoot>
<tr>
<td colspan="5">
</td>
<td>
Totals
</td>
<td>
Rs.<asp:Label ID="lblTotalSum" Font-Bold="true" runat="server"></asp:Label>
</td>
<td>
Rs.<asp:Label ID="lblTotalComm" Font-Bold="true" runat="server"></asp:Label>
</td>
<td>
Rs.<asp:Label ID="lblTotalBalance" Font-Bold="true" runat="server"></asp:Label>
</td>
</tr>
</tfoot>
</table>
</LayoutTemplate>
<ItemTemplate>
<%# AddGroupingRowIfBoardingHasChanged() %>
<tr>
<td>
<%# Container.DataItemIndex+1 %>
</td>
<td>
<%# Eval("PNR_NUMBER")%>
</td>
<td>
<%# Eval("SEAT_NUMBER")%>
</td>
<td>
<%# Eval("CUSTOMER_NAME")%>
</td>
<td>
<%# Eval("CUSTOMER_CONTACT")%>
</td>
<td>
<%# Eval("DROPING_POINT")%>
</td>
<td>
<%# Eval("FARE")%>
</td>
<td>
<%# Eval("COMMISSION")%>
</td>
<td>
<%# Convert.ToInt32(Eval("FARE")) - Convert.ToInt32(Eval("COMMISSION"))%>
</td>
<td>
<%# Eval("BOOKED_AT")%>
</td>
<td>
<%# Eval("BOOKING_TYPE")%>
</td>
</tr>
</ItemTemplate>
<EmptyItemTemplate>
No Bookings are made for this Service
</EmptyItemTemplate>
</asp:ListView>
ListView Items DataBound
The following is for the DataBound ListView Items:
int totalfare, totalCommisionAmount, balanceAmount;
// Calculating Totals
protected void lvDetails_ItemDataBound(object sender, ListViewItemEventArgs e)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
if (e.Item.ItemType == ListViewItemType.DataItem)
{
DataRowView rowView = (DataRowView)dataItem.DataItem;
totalfare = totalfare + Convert.ToInt32(rowView["FARE"]);
totalCommisionAmount = totalCommisionAmount + Convert.ToInt32(rowView["COMMISSION"]);
balanceAmount = balanceAmount + (Convert.ToInt32(rowView["FARE"]) - Convert.ToInt32(rowView["COMMISSION"]));
}
}
// Binding Totals to Labels
protected void lvDetails_DataBound(object sender, EventArgs e)
{
Label lblTotal = (Label)lvDetails.FindControl("lblTotalSum");
lblTotal.Text = totalfare.ToString();
Label lblTotalCommisionAmount = (Label)lvDetails.FindControl("lblTotalComm");
lblTotalCommisionAmount.Text = totalCommisionAmount.ToString();
Label lblTotalBalanceAmount = (Label)lvDetails.FindControl("lblTotalBalance");
lblTotalBalanceAmount.Text = balanceAmount.ToString();
}
Grouping Method Based On PNR_NUMBER
The following is the grouping method based On PNR_NUMBER:
private DataTable GenerateData(DataTable dtDetails)
{
string currentpnr = string.Empty;
//Geting Data Table structure
// DtDetails Have the actual data
DataTable newData = dtDetails.Clone();
// Getting Distinct datatable PNR_NUMBERS
DataTable dtDistinctData = dtDetails.DefaultView.ToTable("NeWData", true, "PNR_NUMBER");
StringBuilder sbSeats = new StringBuilder();
foreach (DataRow drow in dtDistinctData.Rows)
{
int fareSum = 0, commitionSum = 0;
currentpnr = Convert.ToString(drow["PNR_NUMBER"]);
//Selecting the rows
DataRow[] rows = dtDetails.Select("PNR_NUMBER='" + currentpnr + "'");
//Seats join
var result = rows.Select(row => row[3].ToString()).ToArray();
string joinseats = string.Join(",", result);
//fares sum
string[] resultfare = rows.Select(row => row[11].ToString()).ToArray();
for (int i = 0; i < resultfare.Length; i++)
{
fareSum = fareSum + Convert.ToInt32(resultfare[i]);
}
//commition sum
string[] resultcomm = rows.Select(row => row[16].ToString()).ToArray();
for (int i = 0; i < resultcomm.Length; i++)
{
commitionSum = commitionSum + Convert.ToInt32(resultcomm[i]);
}
//gender join
var resultgender = rows.Select(row => row[4].ToString()).ToArray();
string joingenders = string.Join(",", resultgender);
// copy data to new datatable
DataRow drrow = newData.NewRow();
drrow["PNR_NUMBER"] = currentpnr;
drrow["SEAT_NUMBER"] = joinseats + "(" + joingenders + ")";
drrow["FARE"] = fareSum;
drrow["COMMISSION"] = commitionSum;
drrow["CUSTOMER_GENDER"] = joingenders;
drrow["CUSTOMER_NAME"] = rows[0]["CUSTOMER_NAME"];
drrow["CUSTOMER_CONTACT"] = rows[0]["CUSTOMER_CONTACT"];
drrow["BUS_BOARDING_POINT"] = rows[0]["BUS_BOARDING_POINT"];
drrow["BOOKED_AT"] = rows[0]["BOOKED_AT"];
drrow["DROPING_POINT"] = rows[0]["DROPING_POINT"];
drrow["START_TIME"] = rows[0]["START_TIME"];
drrow["BOOKING_TYPE"] = rows[0]["BOOKING_TYPE"];
drrow["LAND_MARK"] = rows[0]["LAND_MARK"];
//Adding Rows to table
newData.Rows.Add(drrow);
}
return newData;
}
protected void GetPassengersDetails()
{
// getting individual total booked seats from service
DataTable dtPassengers = objBusiness.GetData(EBEnum.Enum.Functionality.Bookings.ToString(), 0, ref strProcedure);
DataTable newdata = this.GenerateData(dtPassengers);
lvDetails.DataSource = newdata;
lvDetails.DataBind();
}
That's all there is to it! With this code in place we now get the desired grouping interface.