protected void LinkBtnExportExcel_Click(object sender, EventArgs e) { try { System.Threading.Thread.Sleep(2000); Response.Clear(); Response.Buffer = true; Response.ClearContent(); Response.ClearHeaders(); Response.Charset = ""; string FileName = "StockList.xls"; StringWriter strwritter = new StringWriter(); HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName); GVDIff.GridLines = GridLines.Both; GVDIff.HeaderStyle.Font.Bold = true; GVDIff.RenderControl(htmltextwrtter); Response.Write(strwritter.ToString()); Response.End(); } catch (Exception ex) { throw; //ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true); //lblalert.Text = ex.Message; } }
public void FillGrid(string mpurid, string dat) { try { //q = " select * from v_diffRat where MPurDate <= '" + dat + "' and MPurID ='" + mpurid + "' and CompanyId = '" + Session["CompanyID"] + "' and BranchId= '" + Session["BranchID"] + "'"; dt_ = new DataTable(); //dt_ = DBConnection.GetQueryData(q); using (var cmd = new SqlCommand("sp_currdiff", con)) using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MPurID", PURID.Trim()); da.Fill(dt_); } if (dt_.Rows.Count > 0) { GVDIff.DataSource = dt_; GVDIff.DataBind(); lbl_dat.Text = dt_.Rows[0]["MPurDate"].ToString(); lbl_trans.Text = dt_.Rows[0]["Transport"].ToString(); lblotheramt.Text = dt_.Rows[0]["Otheramt"].ToString(); lbl_exchrat.Text = dt_.Rows[0]["Exchange_Rat"].ToString(); // Rate in PK //GTotal = 0; //for (int j = 0; j < GVDIff.Rows.Count; j++) //{ // Label total = (Label)GVDIff.Rows[j].FindControl("lb_ratinpk"); // GTotal += Convert.ToSingle(total.Text); //} // Rate in Other Currencies //GTotal = 0; //for (int j = 0; j < GVDIff.Rows.Count; j++) //{ // Label total = (Label)GVDIff.Rows[j].FindControl("lb_purpric"); // GTotal += Convert.ToSingle(total.Text); //} } } catch (Exception ex) { throw ex; } }
public void FillGrid(string mpurid, string dat) { try { q = " select * from v_diffRat where MPurDate <= '" + dat + "' and MPurID ='" + mpurid + "' and CompanyId = '" + Session["CompanyID"] + "' and BranchId= '" + Session["BranchID"] + "'"; dt_ = new DataTable(); dt_ = DBConnection.GetQueryData(q); if (dt_.Rows.Count > 0) { GVDIff.DataSource = dt_; GVDIff.DataBind(); lbl_dat.Text = dt_.Rows[0]["MPurDate"].ToString(); lbl_trans.Text = dt_.Rows[0]["Transport"].ToString(); lblotheramt.Text = dt_.Rows[0]["Otheramt"].ToString(); lbl_exchrat.Text = dt_.Rows[0]["Exchange_Rat"].ToString(); // Rate in PK //GTotal = 0; //for (int j = 0; j < GVDIff.Rows.Count; j++) //{ // Label total = (Label)GVDIff.Rows[j].FindControl("lb_ratinpk"); // GTotal += Convert.ToSingle(total.Text); //} // Rate in Other Currencies //GTotal = 0; //for (int j = 0; j < GVDIff.Rows.Count; j++) //{ // Label total = (Label)GVDIff.Rows[j].FindControl("lb_purpric"); // GTotal += Convert.ToSingle(total.Text); //} } } catch (Exception ex) { throw ex; } }
public void FillGrid(string dat) { try { q = " select * from v_diffRat where MPurDate = '" + dat + "' and CompanyId = '" + Session["CompanyID"] + "' and BranchId= '" + Session["BranchID"] + "'"; dt_ = new DataTable(); dt_ = DBConnection.GetQueryData(q); if (dt_.Rows.Count > 0) { GVDIff.DataSource = dt_; GVDIff.DataBind(); lbl_dat.Text = dt_.Rows[0]["MPurDate"].ToString(); } } catch (Exception ex) { throw ex; } }
public void FillGrid(string dat) { try { using (var cmd = new SqlCommand("sp_currdiff", con)) using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MPurID", PURID.Trim()); da.Fill(dt_); } if (dt_.Rows.Count > 0) { GVDIff.DataSource = dt_; GVDIff.DataBind(); } //q = " select * from v_diffRat where MPurDate = '" + dat + "' and CompanyId = '" + Session["CompanyID"] + "' and BranchId= '" + Session["BranchID"] + "'"; //dt_ = new DataTable(); //dt_ = DBConnection.GetQueryData(q); //if (dt_.Rows.Count > 0) //{ // GVDIff.DataSource = dt_; // GVDIff.DataBind(); // lbl_dat.Text = dt_.Rows[0]["MPurDate"].ToString(); //} } catch (Exception ex) { throw ex; } }