public void ProcessRequest(HttpContext context) { DataSet dataSet = new DataSet(); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISALog1ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("exec ProxyReport", conn); cmd.CommandTimeout = 200; SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(dataSet); GridView1.DataSource = dataSet.Tables[0]; GridView1.DataBind(); GridView2.DataSource = dataSet.Tables[1]; GridView2.DataBind(); GridView3.DataSource = dataSet.Tables[2]; GridView3.DataBind(); dataSet.Tables[0].TableName = "1"; dataSet.Tables[1].TableName = "2"; dataSet.Tables[2].TableName = "3"; int count = 3; MemoryStream ms = GetExcel.DataTableToExcelXlsx(dataSet, count); ms.WriteTo(context.Response.OutputStream); context.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; context.Response.AddHeader("Content-Disposition", "attachment;filename=EPPlusData.xlsx"); context.Response.StatusCode = 200; context.Response.End(); }
public void ProcessRequest(HttpContext context) { string connectionString = "Data Source=YOUR_SERVER;Initial Catalog=YOUR_DATABASE; Integrated Security=true;"; using (SqlConnection c = new SqlConnection(connectionString)) { c.Open(); DataSet ds = new DataSet("ds"); DataTable dt1 = ds.Tables.Add("1"); DataTable dt2 = ds.Tables.Add("2"); DataTable dt3 = ds.Tables.Add("3"); int count = 3; SqlCommand cmd = new SqlCommand(); SqlDataReader reader; cmd.Connection = c; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "StoredProcedureName1"; reader = cmd.ExecuteReader(); dt1.Load(reader); cmd.CommandText = "StoredProcedureName2"; reader = cmd.ExecuteReader(); dt2.Load(reader); cmd.CommandText = "StoredProcedureName3"; reader = cmd.ExecuteReader(); dt3.Load(reader); MemoryStream ms = GetExcel.DataTableToExcelXlsx(ds, count); ms.WriteTo(context.Response.OutputStream); context.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; context.Response.AddHeader("Content-Disposition", "attachment;filename=EasyEditCmsGridData.xlsx"); context.Response.StatusCode = 200; context.Response.End(); c.Close(); } }
public void ProcessRequest(HttpContext context) { var dt = DBServer.GetDataTable("select * from table"); var ms = GetExcel.DataTableToExcelXlsx(dt, "Sheet1"); ms.WriteTo(context.Response.OutputStream); context.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; context.Response.AddHeader("Content-Disposition", "attachment;filename=EasyEditCmsGridData.xlsx"); context.Response.StatusCode = 200; context.Response.End(); }
protected void Button1_Click(object sender, EventArgs e) { GetExcel ge = new GetExcel(); ge.ProcessRequest(HttpContext.Current); }