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;
            }
        }