Print ASP.Net GridView with page breaks and repeat header on each page

GridView Markup

I have a simple ASP.Net GridView with a button to print the GridView contents as shown below

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" Font-Names="Arial"

    Font-Size="11pt" AlternatingRowStyle-BackColor="#C2D69B" HeaderStyle-BackColor="green"

    AllowPaging="false">

    <Columns>

        <asp:BoundField ItemStyle-Width="150px" DataField="CustomerID" HeaderText="CustomerID" />

        <asp:BoundField ItemStyle-Width="150px" DataField="City" HeaderText="City" />

        <asp:BoundField ItemStyle-Width="150px" DataField="PostalCode" HeaderText="PostalCode" />

    </Columns>

</asp:GridView>

<br />

<asp:Button ID="btnPrint" runat="server" Text="Print" OnClick="Print" />

 

 

Printing the GridView with Page breaks and Header on each page

On the click of the print button I have the following event handler which prints the ASP.Net GridView control

C#

protected void Print(object sender, EventArgs e)

{

    GridView1.UseAccessibleHeader = true;

    GridView1.HeaderRow.TableSection = TableRowSection.TableHeader;

    GridView1.FooterRow.TableSection = TableRowSection.TableFooter;

    GridView1.Attributes["style"] = "border-collapse:separate";

    foreach (GridViewRow row in GridView1.Rows)

    {

        if (row.RowIndex % 10 == 0 && row.RowIndex != 0)

        {

            row.Attributes["style"] = "page-break-after:always;";

        }

    }

    StringWriter sw = new StringWriter();

    HtmlTextWriter hw = new HtmlTextWriter(sw);

    GridView1.RenderControl(hw);

    string gridHTML = sw.ToString().Replace("\"", "'").Replace(System.Environment.NewLine, "");

    StringBuilder sb = new StringBuilder();

    sb.Append("<script type = 'text/javascript'>");

    sb.Append("window.onload = new function(){");

    sb.Append("var printWin = window.open('', '', 'left=0");

    sb.Append(",top=0,width=1000,height=600,status=0');");

    sb.Append("printWin.document.write(\"");

    string style = "<style type = 'text/css'>thead {display:table-header-group;} tfoot{display:table-footer-group;}</style>";

    sb.Append(style + gridHTML);

    sb.Append("\");");

    sb.Append("printWin.document.close();");

    sb.Append("printWin.focus();");

    sb.Append("printWin.print();");

    sb.Append("printWin.close();");

    sb.Append("};");

    sb.Append("</script>");

    ClientScript.RegisterStartupScript(this.GetType(), "GridPrint", sb.ToString());

    GridView1.DataBind();

}

 

VB.Net

Protected Sub Print(sender As Object, e As EventArgs)

    GridView1.UseAccessibleHeader = True

    GridView1.HeaderRow.TableSection = TableRowSection.TableHeader

    GridView1.FooterRow.TableSection = TableRowSection.TableFooter

    GridView1.Attributes("style") = "border-collapse:separate"

    For Each row As GridViewRow In GridView1.Rows

        If row.RowIndex Mod 10 = 0 AndAlso row.RowIndex <> 0 Then

            row.Attributes("style") = "page-break-after:always;"

        End If

    Next

    Dim sw As New StringWriter()

    Dim hw As New HtmlTextWriter(sw)

    GridView1.RenderControl(hw)

    Dim gridHTML As String = sw.ToString().Replace("""", "'").Replace(System.Environment.NewLine, "")

    Dim sb As New StringBuilder()

    sb.Append("<script type = 'text/javascript'>")

    sb.Append("window.onload = new function(){")

    sb.Append("var printWin = window.open('', '', 'left=0")

    sb.Append(",top=0,width=1000,height=600,status=0');")

    sb.Append("printWin.document.write(""")

    Dim style As String = "<style type = 'text/css'>thead {display:table-header-group;} tfoot{display:table-footer-group;}</style>"

    sb.Append(style & gridHTML)

    sb.Append(""");")

    sb.Append("printWin.document.close();")

    sb.Append("printWin.focus();")

    sb.Append("printWin.print();")

    sb.Append("printWin.close();")

    sb.Append("};")

    sb.Append("</script>")

    ClientScript.RegisterStartupScript(Me.[GetType](), "GridPrint", sb.ToString())

    GridView1.DataBind()

End Sub

 

Above you will notice before printing I am looping and adding style page-break-after:always to every 10^th GridView row, this makes the page to break after 10^th row. You can change this to some other number as per your needs.

You will need to also add the following event to avoid event validation errors

C#

public override void VerifyRenderingInServerForm(Control control)

{

    /*Verifies that the control is rendered */

}

 

VB.Net

Public Overrides Sub VerifyRenderingInServerForm(control As Control)

   'Verifies that the control is rendered

End Sub

 

 

Demo

View Demo

 

Downloads

You can download the complete source code in C# and VB.Net using the download link provided below

GridViewPrint-PageBreaks.zip