New Message on dotNET User Group Hyd

Printing data of a datagrid

Reply
  Reply to Sender   Recommend Message 2 in Discussion
From: SivaDotNet

Hi Venkat,
                  U can dump the contents of ur data grid to an Excel sheet and dispaly it in the browser. So this will server u for both, Previewing as well as Printing.
 
Here is how it goes ...
 
1. Create a new web form
2. Drag a drag a DataGrid control onto your Web form from the toolbar. Then right-click on the grid and choose Auto Format from the context menu.
3.In the code behind just add this code in Page Render or Page Load event
 
    Dim dt As DataTable = _
    CType(Application.Item("MyGridData"), DataTable)
    Response.ContentType = "application/ms-excel"
    Response.AddHeader("Content-Disposition", _
      "inline;filename=test.xls")
    DataGrid1.DataSource = dt
    DataGrid1.DataBind()
    DataGrid1.RenderControl(writer)

That's all u need to do.
 
On the Page where ur Grid is present provide a print button and on click of this open this new aspx page which u have created.
 
One more thing u need to take care is to make the dataset/datatable avaliable in the new aspx page.U can use the same dataset/datatable which u have used for binding to ur Data grid.
 
Hope this helps.
 
Cheers!!
Siva
 
 
 
 
 
 

View other groups in this category.

Click here!
Also on MSN:
Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily Horoscopes

To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings.

Need help? If you've forgotten your password, please go to Passport Member Services.
For other questions or feedback, go to our Contact Us page.

If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list.
Remove my e-mail address from dotNET User Group Hyd.

Reply via email to