protected void ExportToExcel(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=OrderInHand.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
GvorderSum.AllowPaging = false;
this.BindGvorderSum();
GvorderSum.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in GvorderSum.HeaderRow.Cells)
{
cell.BackColor = GvorderSum.HeaderStyle.BackColor;
}
foreach (GridViewRow row in GvorderSum.Rows)
{
row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GvorderSum.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GvorderSum.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GvorderSum.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
protected void BindGvorderSum()
{
conn.Open();
string strSelectCmd = "Select DISTINCT byr_nm,SUM(Totalprice) as TPRC, SUM(po_quantity) as TQTY FROM View_OrderInhand where po_xfactory Between '" + Session["dt1"].ToString() + "' AND '" + Session["dt2"].ToString() + "' AND TnAapproved IS NOT NULL GROUP BY byr_nm ";
SqlDataAdapter da = new SqlDataAdapter(strSelectCmd, conn);
DataSet ds = new DataSet();
da.Fill(ds);
//SqlCommand Syscmd = new SqlCommand("Sp_PriceANDQuantityTotal", conn);
//Syscmd.CommandType = CommandType.StoredProcedure;
//SqlDataAdapter da = new SqlDataAdapter(Syscmd);
//DataSet ds = new DataSet();
//da.Fill(ds);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count == 0)
{
dt.Rows.Add(dt.NewRow());
GvorderSum.DataSource = dt;
GvorderSum.DataBind();
int columncount = GvorderSum.Rows[0].Cells.Count;
GvorderSum.Rows[0].Cells.Clear();
GvorderSum.Rows[0].Cells.Add(new TableCell());
GvorderSum.Rows[0].Cells[0].ColumnSpan = columncount;
GvorderSum.Rows[0].Cells[0].Text = "Note:-Please Select Buyer, Form Date and To Date. Then Click Find";
}
else
{
GvorderSum.DataSource = dt;
GvorderSum.DataBind();
GvorderSum.FooterRow.Cells[1].Text = "Grand Total";
GvorderSum.Attributes["style"] = "border-collapse:separate";
}
}