-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: DotnetGroupKing
Message 1 in Discussion
Hi friends I am facing one problem whie sorting datagrid I have datagird which has
sorting feature and also i am trying to export the grid into excel format. Following
is the code my export
Response.ContentType = "application/vnd.ms-excel"
'Remove the charset from the Content-Type header.
Response.Charset = ""
Response.AppendHeader("ContentType", "application/octet-stream")
Response.AppendHeader("Content-Disposition", "attachment; filename=" & "" & "")
'Turn off the view state.
Me.EnableViewState = False
'OlapDataGrid.Columns(0).Visible = False
Dim tw As New System.IO.StringWriter
Dim hw As New System.Web.UI.HtmlTextWriter(tw)
'Get the HTML for the control.
OlapDataGrid.RenderControl(hw)
'Write the HTML back to the browser.
Response.Write(tw.ToString())
'End the response.
Response.End()
this code is working fine if i am not using sorting feature of grid but whn i use
sorting then nothing is exported.
Thanks in advance
-----------------------------------------------------------
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]