protected void GridView1_ExcelButtonClick(object sender, SearchGridEventArgs e) { /* * string filename = "Export.xlsx"; * System.IO.StringWriter tw = new System.IO.StringWriter(); * System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); * Quality data = new Quality(); * * * DataTable dt = new DataTable(); * dt = data.Sql_Datatable(consulta_sql()); * * System.IO.MemoryStream ms = DataTableToExcelXlsx(dt, "Sheet1"); * ms.WriteTo(HttpContext.Current.Response.OutputStream); * HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; * HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); * HttpContext.Current.Response.StatusCode = 200; * HttpContext.Current.Response.End(); * HttpContext.Current.Response.Write(tw.ToString()); * HttpContext.Current.Response.End();*/ }
protected void GridView1_ExcelButtonClick(object sender, SearchGridEventArgs e) { string filename = "Export.xlsx"; System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); Quality data = new Quality(); DataTable dt = new DataTable(); dt = data.Sql_Datatable(Fabricacion_stock(DropDownDesde.SelectedValue, DropDownHasta.SelectedValue)); System.IO.MemoryStream ms = DataTableToExcelXlsx(dt, "Sheet1"); ms.WriteTo(HttpContext.Current.Response.OutputStream); HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); HttpContext.Current.Response.StatusCode = 200; HttpContext.Current.Response.End(); HttpContext.Current.Response.Write(tw.ToString()); HttpContext.Current.Response.End(); }
protected void GridView1_ExcelButtonClick(object sender, SearchGridEventArgs e) { string filename = "Export.xlsx"; System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); Quality data = new Quality(); // string Con_Q = @"Data Source=192.168.1.195\sqlserver2008;Initial Catalog=QC600;Persist Security Info=True;User ID=dso;Password=dsodsodso"; string Con_Q = @"Data Source=172.16.0.12;Initial Catalog=QC_PRUEBAS;Persist Security Info=True;User ID=dso;Password=dsodsodso"; DataTable dt = new DataTable(); dt = data.Sql_Datatable(consulta_sql(DropDownDesde.SelectedValue), Con_Q); System.IO.MemoryStream ms = DataTableToExcelXlsx(dt, "Sheet1"); ms.WriteTo(HttpContext.Current.Response.OutputStream); HttpContext.Current.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename); HttpContext.Current.Response.StatusCode = 200; HttpContext.Current.Response.End(); HttpContext.Current.Response.Write(tw.ToString()); HttpContext.Current.Response.End(); }
protected void GridView1_CancelFilterButtonClick(object sender, SearchGridEventArgs e) { FilterToNthPage(e.SearchFilterValues, GridView1.CurrentSortExpression, GridView1.CurrentSortDirection, 1); }