private void BindCity() { PrtyDetlDAL obj = new PrtyDetlDAL(); var FrmCity = obj.BindFromCity(); drpBaseCity.DataSource = FrmCity; drpBaseCity.DataTextField = "City_Name"; drpBaseCity.DataValueField = "City_Idno"; drpBaseCity.DataBind(); drpBaseCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); }
private void BindSenderName() { PrtyDetlDAL obj = new PrtyDetlDAL(); DataTable SenderName = obj.BindPartynew("BindPartynew", ApplicationFunction.ConnectionString()); ddlParty.DataSource = SenderName; ddlParty.DataTextField = "Acnt_Name"; ddlParty.DataValueField = "Acnt_Idno"; ddlParty.DataBind(); ddlParty.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); }
private void BindGrid() { PrtyDetlDAL obj = new PrtyDetlDAL(); DataTable dt = obj.SelectPartyNetBalance("SelectRep", txtDateFrom.Text.Trim(), txtDateTo.Text.Trim(), Convert.ToInt64(ddlParty.SelectedValue), Convert.ToInt64(drpBaseCity.SelectedValue), Convert.ToInt64(ddllorrytype.SelectedValue), ApplicationFunction.ConnectionString()); if (dt != null && dt.Rows.Count > 0) { grdMain.DataSource = dt; grdMain.DataBind(); lblTotalRecord.Text = "Total Record:(" + Convert.ToInt64(dt.Rows.Count) + ")"; imgBtnExcel.Visible = true; ViewState["Data"] = dt; } else { grdMain.DataSource = null; grdMain.DataBind(); lblTotalRecord.Text = "Total Record:(0)"; imgBtnExcel.Visible = false; ViewState["Data"] = null; } }