Datagrid to Excel

DataSet ds= new DataSet();
da.Fill(ds);

//Ger response object for Exporting the data
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter oSW = new System.IO.StringWriter();

//Bind the data to datagrid
DataGrid dg = new DataGrid();
dg.DataSource = ds.Tables[0];
dg.DataBind();

//Export to excel
System.Web.UI.HtmlTextWriter oHtmlTW = new System.Web.UI.HtmlTextWriter(oSW);
dg.RenderControl(oHtmlTW);
Response.Write(oSW.ToString());
Response.End();