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