Skip to main content

ASP.NET - ColumnSpan Attribute of Footer Row in GridView

This article attempts to provide tutorial on how to get the footer of a GridView to be displayed as a SINGLE cell i.e. setting the ColumnSpan property to match the number of columns. The trick is to use the OnRowCreated method.

Design code
<asp:GridView ID="gvResults" ShowHeader="true" ShowFooter="true" runat="server" OnRowCreated="gvResults_RowCreated" ....>
    <asp:TemplateField ...>

Code-behind code (VB.NET)
Protected Sub gvResults_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvResults.RowCreated
    If e.Row.RowType = DataControlRowType.Footer Then
        Dim m As Integer = e.Row.Cells.Count
        For i As Integer = m - 1 To 1 Step -1

        e.Row.Cells(0).ColumnSpan = m

            Dim dv As DataView = gvResults.DataSource
            If dv.Count = 0 Then
                e.Row.Cells(0).Text = "0 records"
                Dim startRec As Integer = (gvResults.PageIndex * gvResults.PageSize) + 1
                Dim endRec As Integer = startRec + gvResults.Rows.Count - 1
                e.Row.Cells(0).Text = startRec & "-" & endRec & " of " & dv.Count & " records"
            End If
        Catch ex As Exception
        End Try
    End If
End Sub

Code-behind code (C#)
protected void gvResults_RowCreated(Object sender, GridViewRowEventArgs e)
    if (e.Row.RowType == DataControlRowType.Footer)
        int m = e.Row.Cells.Count;

        for (int i = m - 1; i >= 1; i--)

        e.Row.Cells[0].ColumnSpan = m;

            DataView dv = gvResults.DataSource;
            if (dv.Count == 0)
                e.Row.Cells[0].Text = "0 records";
                int startRec = (gvResults.PageIndex * gvResults.PageSize) + 1;
                int endRec = startRec + gvResults.Rows.Count - 1;
                e.Row.Cells[0].Text = startRec.ToString() + "-" + endRec.ToString() + " of " + dv.Count.ToString() + " records";
        catch (Exception ex) { }

Popular Posts

Ho Ching named 5th most powerful and is mistaken as first lady by Forbes

Forbes named Singapore Prime Minister wife and CEO of Temasek Holdings, Ho Ching, as the 5th most powerful woman in the world. Ho Ching is mistaken as Singapore's first lady! OMG!

I wonder how can Forbes makes such a blunder. For a complete list, refer to here.

How to stop FortiClient from starting automatically?

Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed me. Attempt to stop 'FortiClient Service Scheduler' only return 'Parameter is incorrect' error message.

An article on Technet help solve my trouble. To stop FortiClient from starting automatically, try the following:
Shut down FortiClient from the system tray.
Run net stop fortishield on command prompt.
Run msconfig.
On msconfig, switch to the Services tab. Clear the FortiClient Service Scheduler check box and click Apply.Run services.msc on command prompt to open up show all available services.Look for FortiClient Service Scheduler. Switch Startup type to Manual.Restart your computer. FortiClient should not be running automatically the next time round. Hope it helps.

Photo of NSman carrying field pack himself is fake

Read more on Stomp [via]