How to output to excel.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hiye, i've got some data which i've query from the db and how do i get it into ms excel
any body done this before?
 
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.
 
Back
Top