-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: SivaDotNet
Message 2 in Discussion

Hi,                    U can dump the contents of ur data set to a  word/Excel sheet 
and dispaly it in the browser. Later u can save the same to ur machine   Here is how 
it goes ...   1. Create a new web form 2. 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("MyGridSet"), DataTable) 
    Response.ContentType = "application/ms-word"
    Response.AddHeader("Content-Disposition", _
      "inline;filename=test.doc")
    DataGrid1.DataSource = dt
    DataGrid1.DataBind()
    DataGrid1.RenderControl(writer)
 That's all u need to do.   On ur Existing Page provide a  button and on click of this 
open the 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.   HTH.   Cheers!! Siva

-----------------------------------------------------------

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]

Reply via email to