How to print a GridView data

bex · February 7th, 2009, 03:37 PM

Hi there i need to print a GridView data that is fed by sql 2005 db ,
is it posible to download the data from the grid?

thanks

alliancejhall · February 7th, 2009, 09:53 PM

put an html button on that page that says print and tie it to a javascript function then have that function open a new window and write the gridview to it then print?

<input id="prtButton" type="button" value="Print" onclick="CallPrint('<%= GridView1.ClientID %>');" />

Code:

<script language="javascript" type="text/javascript">
 function CallPrint( strid )
   {
    var prtContent = document.getElementById( strid );
    var WinPrint = window.open('', '', 'left=0,top=0,width=1050,height=600,toolbar=1,scrollbars=1,status=0');
    WinPrint.document.write( prtContent.innerHTML );
    WinPrint.document.close();
    WinPrint.focus();
    WinPrint.print();
    WinPrint.close();
   }
</script>

There's probably a better way to do this but this should work. what it's doing is on the onclick event of the prtButton it sends the client id of your gridview (which I assume is called GridView1) to the print function in javascript. the javascript passes the control to a new window then prints that window.

hope this is what you wanted....

bex · February 8th, 2009, 05:21 AM

Hi thanks a lot that is exactly what i wanted i tryed it and it worked.
is this gonna print all the pages of the grid or just the one displayed ? and is there a way to pass the format from the grid to the print

thanks again

alliancejhall · February 8th, 2009, 08:26 PM

I believe if you have paging on then it will only print the visible page how ever if you want to print all the results from start to finish then you will have to disable the paging before you call the javascript function.