protected void Page_Load(object sender, EventArgs e) { if (Request.UrlReferrer == null) { base.AutoRedirect(); } if (!Page.IsPostBack) { if (base.CheckUserRights(intFormId) == false) { Response.Redirect("PermissionDenied.aspx"); } if (base.Print == false) { imgBtnExcel.Visible = false; } this.BindMainHead(); drpMHGrp.Focus(); AcntHeadMaintenaceDAL objclsAcntHeadMaintenace = new AcntHeadMaintenaceDAL(); var lstGridData = objclsAcntHeadMaintenace.SelectForSearch(Convert.ToString(txtAcntGrp.Text.Trim()), Convert.ToInt32(drpMHGrp.SelectedValue)); if (lstGridData != null && lstGridData.Count > 0) { lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count; } } txtAcntGrp.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);"); }
private void BindGrid() { AcntHeadMaintenaceDAL objclsAcntHeadMaintenace = new AcntHeadMaintenaceDAL(); var lstGridData = objclsAcntHeadMaintenace.SelectForSearch(Convert.ToString(txtAcntGrp.Text.Trim()), Convert.ToInt32(drpMHGrp.SelectedValue)); objclsAcntHeadMaintenace = null; if (lstGridData != null && lstGridData.Count > 0) { DataTable dt = new DataTable(); dt.Columns.Add("S.No", typeof(string)); dt.Columns.Add("Acount HeadName", typeof(string)); dt.Columns.Add("Acount GroupName", typeof(string)); dt.Columns.Add("Status", typeof(string)); int c = 0; for (int i = 0; i < lstGridData.Count; i++) { DataRow dr = dt.NewRow(); dr["S.No"] = ++c; dr["Acount HeadName"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "AHeadName")); dr["Acount GroupName"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "AcntGHName")); if (Convert.ToBoolean(DataBinder.Eval(lstGridData[i], "Status")) == true) { dr["Status"] = "Active"; } else { dr["Status"] = "Inactive"; } dt.Rows.Add(dr); } if (dt != null && dt.Rows.Count > 0) { ViewState["Dt"] = dt; } grdMain.DataSource = lstGridData; grdMain.DataBind(); lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count; imgBtnExcel.Visible = true; int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString(); lblcontant.Visible = true; divpaging.Visible = true; } else { grdMain.DataSource = null; grdMain.DataBind(); lblTotalRecord.Text = "T. Record (s): 0 "; imgBtnExcel.Visible = false; lblcontant.Visible = false; divpaging.Visible = false; } }