-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: SivaDotNet
Message 3 in Discussion
Hi,
U can dump the contents of ur data grid / DataSet 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 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 event
Dim dt As DataTable = _
CType(Session("MyDataTable"), 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.
HTH,
Siva kumar
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
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.
mailto:[EMAIL PROTECTED]
