-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: _Neeraj_
Message 4 in Discussion
Check the archive. I have sent the complete method for the same.
----- Original Message -----
From: SivaDotNet <[EMAIL PROTECTED]>
Date: Tue, 31 Aug 2004 04:12:22 -0700
Subject: Re: Export Dataset to Excel
To: BDOTNET <[EMAIL PROTECTED]>
New Message on BDOTNET
Export Dataset to Excel
Reply
Reply to Sender Recommend Message 3 in Discussion
From: SivaDotNet
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
View other groups in this category.
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 BDOTNET.
--
Regards,
Neeraj Saluja
-----------------------------------------------------------
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]
