public ActionResult ExportExcel() { string xmlData = HttpContext.Server.MapPath("~/App_Data/GridColumn.xml");//Path of the xml script DataSet ds = new DataSet();//Using dataset to read xml file ds.ReadXml(xmlData); DataTable dtRecords = ds.Tables[0];// Data Table int recordsCount = dtRecords.Rows.Count; var grid = new GridView(); grid.DataSource = dtRecords; grid.DataBind(); Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls"); Response.ContentType = "application/ms-excel"; Response.Charset = ""; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); DownloadFileActionResult download = new DownloadFileActionResult(grid, "Cars.xls"); download.ExecuteResult(this.ControllerContext); grid.RenderControl(htw); Response.Output.Write(htw.ToString()); Response.Flush(); Response.End(); return new EmptyResult(); }
public void IgnoresChildren () { Button b = new Button (); b.Controls.Add (new LiteralControl ("hola")); Assert.AreEqual (1, b.Controls.Count, "controls"); StringWriter sw = new StringWriter (); HtmlTextWriter tw = new HtmlTextWriter (sw); b.RenderControl (tw); string str = tw.ToString (); Assert.AreEqual (-1, str.IndexOf ("hola"), "hola"); }
/// <summary> /// Renders The Given Control Into The String Output /// </summary> /// <param name="control">The WebControl To Be Converted</param> /// <returns>The Rendered Result Of The Given Control</returns> /// private static string GetControl(WebControl control) { StringWriter stringWriter = new StringWriter(); HtmlTextWriter textWriter = new HtmlTextWriter(stringWriter); control.RenderControl(textWriter); textWriter.Flush(); return textWriter.ToString(); }