How to export a dataset to excel?

  • Thread starter Luis Esteban Valencia
  • Start date
L

Luis Esteban Valencia

I have a page that generates a table depending on the querystring from a
master page. But as its a transaction history I want to show it in excel.
How can I generate an excel file from a DATASET?
 
G

Guest

try this way .... i am using Datagrid

Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Dim oStringWriter As New System.IO.StringWriter
Dim oHtmlTextWriter As New System.Web.UI.HtmlTextWriter(oStringWriter)

oHtmlTextWriter.Write("<html><head>")
oHtmlTextWriter.Write("</head><body>")

oHtmlTextWriter.WriteBeginTag("form runat=server ")
oHtmlTextWriter.WriteAttribute("target", "_blank")
oHtmlTextWriter.Write(">")
dgReport.RenderControl(oHtmlTextWriter)
oHtmlTextWriter.Write("</form></body></html>")
Response.Write(oStringWriter.ToString())
Response.End()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to Display Excel As HTML In js 2
I want to make such a page in which i can put my excel file. 1
How to paste n+1 every single time without copying new line from excel 3
How to paste n+1 every single time without copying new line from excel 0
How to loop in folder through all excel files and all sheets using pandas? 0
API to excel dont show data 0
Image shifts to the right when export the page to pdf 4
How do i convert a Chinese DAT file from a game I play 2

Members online

No members online now.
Total: 39 (members: 0, guests: 39)
Robots: 648

Forum statistics

Threads
473,769
Messages
2,569,582
Members
45,057
Latest member
KetoBeezACVGummies

Latest Threads

Top