public DataSet FillData(string strSearch)
        {
            DataSet dsData = new DataSet();

            try
            {
                int PageCount = 0;
                tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp();
                Objtbl_MemberMasterProp.MemberCode  = 0;
                Objtbl_MemberMasterProp.PageNo      = Convert.ToInt32(txtCurPage.Text);
                Objtbl_MemberMasterProp.RecordCount = Convert.ToInt32(20);
                tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL();
                if (sSearchVal != "" && sSearchType != "")
                {
                    Objtbl_MemberMasterProp.SearchBy  = sSearchType;
                    Objtbl_MemberMasterProp.SearchVal = sSearchVal;
                    dsData = Objtbl_MemberMasterBAL.Search_Data(Objtbl_MemberMasterProp, ref PageCount);
                }
                else
                {
                    dsData = Objtbl_MemberMasterBAL.Select_Data(Objtbl_MemberMasterProp, ref PageCount);
                    lblTotalPageCount.Text = Convert.ToString(PageCount);
                }


                FillGrid(dsData);
            }
            catch (Exception ex)
            {
                MessageBox.Show(Convert.ToString(ex.Message));
                this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmMemberMaster.FillData() " + ex.ToString());
            }
            return(dsData);
        }
        public DataSet SeaarchData(string sSearchBy, string sSearchVal)
        {
            DataSet ds = new DataSet();

            try
            {
                tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp();
                Objtbl_MemberMasterProp.SearchBy  = sSearchBy;
                Objtbl_MemberMasterProp.SearchVal = sSearchVal;

                Objtbl_MemberMasterProp.PageNo      = 1;
                Objtbl_MemberMasterProp.RecordCount = 10000;

                tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL();
                int PageCount = 0;
                ds = Objtbl_MemberMasterBAL.Search_Data(Objtbl_MemberMasterProp, ref PageCount);
            }
            catch (Exception ex)
            {
                MessageBox.Show(Convert.ToString(ex.Message));
                this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmMemberMaster.SeaarchData() " + ex.ToString());
            }
            return(ds);
        }