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 = "SupplierList.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); GVSupplier.GridLines = GridLines.Both; GVSupplier.HeaderStyle.Font.Bold = true; GVSupplier.RenderControl(htmltextwrtter); Response.Write(strwritter.ToString()); Response.End(); } catch (Exception ex) { // throw; ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true); lblalert.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { lblCid.Text = "1000"; objSqlcon = new SqlConnection("Data Source=LG-PC\\SQLEXPRESS;Initial Catalog=pnl;Integrated Security=True"); string query = "select * from Party where Ptype='customer'and CompanyId=" + lblCid.Text + ""; objSqlDa = new SqlDataAdapter(query, objSqlcon); objDT = new DataTable(); objSqlDa.Fill(objDT); GVSupplier.DataSource = objDT; GVSupplier.DataBind(); }
private void gridbind() { String cid = Session["Cid"].ToString(); objSqlcon = new SqlConnection("Data Source=LG-PC\\SQLEXPRESS;Initial Catalog=pnl;Integrated Security=True"); string query = "select * from Stock where CompanyId=" + cid + ""; objSqlDa = new SqlDataAdapter(query, objSqlcon); objDT = new DataTable(); objSqlDa.Fill(objDT); GVSupplier.DataSource = objDT; GVSupplier.DataBind(); }
public void FillGrid() { try { dt_ = new DataTable(); dt_ = DBConnection.GetQueryData(" select * from supplier where CompanyId = '" + Session["CompanyID"] + "' and BranchId= '" + Session["BranchID"] + "' order by supplierId desc"); GVSupplier.DataSource = dt_; GVSupplier.DataBind(); ViewState["Supplier"] = dt_; } catch (Exception ex) { //throw; ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true); lblalert.Text = ex.Message; } }
protected void TBSearch_TextChanged(object sender, EventArgs e) { System.Threading.Thread.Sleep(2000); try { FillGrid(); DataTable _dt = (DataTable)ViewState["Supplier"]; DataView dv = new DataView(_dt, "suppliername LIKE '%" + TBSearch.Text.Trim().ToUpper() + "%'", "[suppliername] ASC", DataViewRowState.CurrentRows); DataTable dt_ = new DataTable(); dt_ = dv.ToTable(); GVSupplier.DataSource = dt_; GVSupplier.DataBind(); TBSearch.Text = ""; } catch (Exception ex) { // throw; ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true); lblalert.Text = ex.Message; } }