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);
}
