Alerts

Free Alerts

Your email will always be
private and will not be shared.

<< ASP.Net GridView – Export only selected columns to Excel Sheet | Using RadioButtons with ASP.Net GridView Control >>

ASP/ASP.Net

Print functionality in ASP.Net GridView control

Author:Mudassar Khan

In this article I’ll explain how to allow the users to print the contents of the ASP.Net GridView control. So let’s start.

I’ll explain two options, first printing the current page of the ASP.Net GridView control and second printing all the pages.

I have already populated a GridView control using the Microsoft Northwind database.

ASP.Net GridView control with print functionality to print it using any printer

Print Current Page of ASP.Net GridView control

Below is the Button Event handler that is called when the Print Button is clicked

protected void PrintCurrentPage(object sender, EventArgs e)

{

GridView1.PagerSettings.Visible = false;

GridView1.DataBind();

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(\"");

sb.Append(gridHTML);

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

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

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

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

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

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

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

GridView1.PagerSettings.Visible = true;

GridView1.DataBind();

}

VB.Net

Protected Sub PrintCurrentPage(ByVal sender As Object, ByVal e As EventArgs)

GridView1.PagerSettings.Visible = False

GridView1.DataBind()

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(""")

sb.Append(gridHTML)

sb.Append(""");")

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

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

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

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

sb.Append("</script>")

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

GridView1.PagerSettings.Visible = True

GridView1.DataBind()

End Sub

As you’ll notice I have created a JavaScript method to print the GridView content which is called when the page is loaded. The screenshot below displays the preview of the ASP.Net GridView that will be printed

Preview of the current page of the ASP.Net GridView control that is beinged printed

Print All Pages of ASP.Net GridView control

Below is the Button Event handler that is called when the Print All Button is clicked

protected void PrintAllPages(object sender, EventArgs e)

{

GridView1.AllowPaging = false;

GridView1.DataBind();

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(\"");

sb.Append(gridHTML);

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

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

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

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

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

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

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

GridView1.AllowPaging = true;

GridView1.DataBind();

}

VB.Net

Protected Sub PrintAllPages(ByVal sender As Object, ByVal e As EventArgs)

GridView1.AllowPaging = False

GridView1.DataBind()

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=1000,status=0');")

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

sb.Append(gridHTML)

sb.Append(""");")

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

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

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

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

sb.Append("</script>")

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

GridView1.AllowPaging = True

GridView1.DataBind()

End Sub

The only difference in the above function is that I am disabling the paging so that all pages are printed. The screenshot below displays the preview of the ASP.Net GridView that will be printed.

Preview of the ASP.Net GridView control with all pages being printed

To view the live demo, click here.

With this the article comes to an end. Hope you liked it. Download the sample code in VB.Net and C# using the link below

GridViewPrint.zip (4.74 kb)

Posted: Sep 17 2009, 20:36 by Mudassar Khan | Comments (15)

Filed under: ASP.Net | C# | JavaScript | VB.Net

If you like this article, help us grow by bookmarking this page on any social bookmarking site.

Minimize Comments

Comments

Isidro said:

Ohhh,Fantastic

# September 21 2009, 04:47

Ranadhir Dey said:

Hi Mudassar,
This one is a nice code. But when I tried to use it in a composite control, it gives error "Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server." If I overload VerifyRenderingInServerForm then also I am getting the error "RegisterForEventValidation can only be called during Render();" I can't make the EnableEventValidation= false. Please suggest me what to do.
Thanks

# September 30 2009, 19:49

Mudassar Khan said:

Hi Ranadhir,

You'll have to make EnableEventValidation= false but make it only for that page and not in the web.config Thus it will be applied only to one page and not all

# September 30 2009, 20:17

Tracy said:

I have the grid inside of a content placeholder because it has a masterpage. I set EnableEventValidation= false but I still get the error. My error is for the content placeholder "must have runat server tag" not the gridview.

# October 05 2009, 07:45

Mudassar Khan said:

Hi Tracy,

Try seting EnableEventValidation= false in Master Page and if still does not work place it in web.config

# October 05 2009, 15:54

Fenil Desai said:

Hi,
I also have grid inside a content placeholder as it has a masterpage. I tried to set EnableEventValidation= false in masterpage as well as web.config, but nothing works.

# November 27 2009, 02:36

Fenil Desai said:

I also have the grid inside of a content placeholder because it has a masterpage. I set EnableEventValidation= false in masterpage as well as web.config but I still get the error.
Also in my case the grid is inside a table & table is inside a panel.
Mudassar pls help...

# November 27 2009, 04:29

Mudassar Khan said:

Hi Fenil,

What is the error?

# November 27 2009, 17:29

Fenil Desai said:

smae error. Control 'ctl00_ContentPlaceHolder2_grdvProdList' of type 'MyGridView' must be placed inside a form tag with runat=server.

# December 01 2009, 20:49

Mudassar Khan said:

check this
www.aspsnippets.com/.../...with-runat3dserver.aspx

# December 01 2009, 21:39

Fenil Desai said:

Hi Mudassar,

I tried by explicitly overriding the VerifyRenderingInServerForm event. This time it didnt gave any error. But after clicking print current page, it displays a blank page & asks for adding printer even when i already have printer added.
pls help.

# December 01 2009, 21:58

Bhanu said:

Hi Mudassar,

This control doesn't work well with your Ajax Grid View. Please let me know the solution.

# December 09 2009, 16:09

Mudassar Khan said:

Hi Bhanu,
For this to work you will have to do full postback

Thanks

# December 11 2009, 02:56

Bhanu said:

Hi Mudassar.
Can you please explain more in details or post some tutorial on print with Grid View(Ajax way).

# December 28 2009, 16:29

Mudassar Khan said:

Hi Bhanu,
I already told you some things donot work when you use update panel and partial postback
Your problem can only be resolved when you do full postback as I do in this article

# December 29 2009, 02:27

Add comment

Name*
E-mail*
b i u quote

Comment
Preview

Notify me when new comments are added

0 + 0 = Incorrect

Translate this pageMicrosoft® Translator

Community News

Web Hosting SpotLight

Consulting

For consulting and work related queries click here.

Advertise

Advertise with us. For more details click here.

Suggestions

Please provide your valuable suggesstions here.

This Site is hosted on

Categories

Alerts

Thank you

Print functionality in ASP.Net GridView control

Comments

Add comment

Community News

Web Hosting SpotLight

Consulting

Advertise

Suggestions

This Site is hosted on