asp.net: hiye, i've got some data which i've query from the db and how do i get it into ms excel

This article explains in detail:
http://www.aspnetpro.com/NewsletterArticle/2003/09/asp200309so_l/asp200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net



[quoted text, click to view]

follow these steps.. get data into dataset/datareader
bind it to datagrid and render the control.

DataSet dsData = (DataSet) Session[PRISMWebConstants.REPORT_DATASET_KEY];
DataView dvData = new DataView(dsData.Tables[0]);
dvData.Sort = "Column ASC";

DataGrid dgTemp = new DataGrid();
dgTemp.DataSource = dvData;
dgTemp.DataBind();

StringWriter swData = new StringWriter();
HtmlTextWriter htmlTWData = new HtmlTextWriter(swData);

dgTemp.RenderControl(htmlTWData);
Response.Write(swData.ToString());
Response.End();

Av.
[quoted text, click to view]