protected void LoadMemberList() { BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster(); Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster(); membermaster.BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim()); membermaster.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim()); membermaster.StateId = Convert.ToInt32(ddlState.SelectedValue.Trim()); membermaster.CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim()); membermaster.MemberName = txtMemberName.Text.Trim(); membermaster.MobileNo = txtMobile.Text.Trim(); membermaster.BusinessTypeId = Convert.ToInt32(ddlBusinessType.SelectedValue.Trim()); //DataTable dt = objMember.GetAll(membermaster); DataTable dt = objMember.GetAllMemberWithAmount(membermaster); if (dt != null) { DataView dv = new DataView(dt); dv.RowFilter = "IsApproved Is Not Null"; dgvMemberMaster.DataSource = dv; dgvMemberMaster.DataBind(); lblTotalMemberCount.Text = Server.HtmlDecode("<b>Total Member Count: " + dv.ToTable().Rows.Count.ToString() + "</b>"); } }