//Item Grid Bind #region [Item Category Grid Bind] private void BindItemGrid() { try { DataSet ds = objBL.BindItemGrid_BL(); if (ds.Tables[0].Rows.Count == 0 || ds == null) { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); GrdStock.DataSource = ds; GrdStock.DataBind(); int columncount = GrdStock.Rows[0].Cells.Count; GrdStock.Rows[0].Cells.Clear(); GrdStock.Rows[0].Cells.Add(new TableCell()); GrdStock.Rows[0].Cells[0].ColumnSpan = columncount; GrdStock.Rows[0].Cells[0].Text = "No Records Found"; } else { GrdStock.DataSource = ds; GrdStock.DataBind(); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
protected void btnShow_Click(object sender, EventArgs e) { try { //if (txtBrCd.Text == "") //{ // WebMsgBox.Show("Please select branch!", this.Page); return; //} string FLAG = ""; if (txtEntryDate.Text == "") { FLAG = "SHOWALL"; } else { FLAG = "SHOWALLASONBAL"; } DataTable dt = new DataTable(); dt = CS.rptStock(FLAG: FLAG, BRCD: txtBrCd.Text.ToString(), VENDORID: TxtVendorId.Text.ToString(), PRODID: TxtProductId.Text.ToString(), ENTRYDATE: txtEntryDate.Text.ToString()); //dt = CS.rptStock(FLAG: "SHOWALL", BRCD: txtBrCd.Text.ToString()); GrdStock.DataSource = dt; GrdStock.DataBind(); } catch (Exception EX) { ExceptionLogging.SendErrorToText(EX); } }
protected void Page_Load(object sender, EventArgs e) { orgId = Convert.ToInt32(Session["OrgId"]); if (orgId == 0) { Response.Redirect("~/CMSHome.aspx"); } GrdStock.DataSource = db.Displaygrid("SELECT tblItem.ItemCode, tblItem.ItemName,tblCategory.CategoryName, tblItem.Stock, tblUnit.UnitName as Unit FROM tblItem INNER JOIN tblCategory ON tblItem.CategoryId = tblCategory.CategoryId INNER JOIN tblUnit ON tblItem.UnitId = tblUnit.UnitId WHERE (tblItem.OrgId = '" + Convert.ToInt32(Session["OrgId"]) + "')"); GrdStock.DataBind();/*tblItem.UserId,*/ //BindItemGrid(); }
//Grid Index Changed #region GrdIndexChanged protected void GrdStock_PageIndexChanging(object sender, GridViewPageEventArgs e) { try { GrdStock.PageIndex = e.NewPageIndex; //GrdStock.DataSource = objBL.BindItemGrid_BL(); GrdStock.DataBind(); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
public void BindStock() { BookCode2 = Txtbkcode1.Text.ToString().Split(':')[0].Trim(); // GrdStock.DataSource = StockUpdate.GetStockUpdate(); // GrdStock.DataBind(); //DataTable dt = new DataTable(); //dt = Idv.Chetana.BAL.StockUpdate.GetStockUpdateRep(bookcode).Tables[0]; //DataView dv = new DataView(dt); //return dv; GrdStock.DataSource = StockUpdate.GetStockUpdateRep(BookCode2); GrdStock.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserName"] == null) { Response.Redirect("FrmLogin.aspx"); } if (!IsPostBack) { txtBrCd.Text = Session["BRCD"].ToString(); txtBrCdName.Text = Cbr.getbrcode(txtBrCd.Text); DataTable dt = new DataTable(); dt = CS.rptStock(FLAG: "SHOWALL", BRCD: txtBrCd.Text.ToString(), VENDORID: TxtVendorId.Text.ToString(), PRODID: TxtProductId.Text.ToString(), ENTRYDATE: txtEntryDate.Text.ToString()); GrdStock.DataSource = dt; GrdStock.DataBind(); // txtBrCd.Text = Session["BRCDNAME"].ToString(); } }