protected void LoadMembers()
{
BusinessLayer.Common.MemberMaster objMemberMaster = new BusinessLayer.Common.MemberMaster();
DataTable dt = objMemberMaster.RenewalMemberGetAll(0, 0, 0, 0, "", "", 0, DateTime.MinValue, DateTime.MinValue);
DataView dv = new DataView(dt);
dv.RowFilter = "IsNull(IsApproved,0)=1 And IsNull(IsActive,0)=1";
if (dt != null)
{
ddlMember.DataSource = dv.ToTable();
ddlMember.DataTextField = "MemberName";
ddlMember.DataValueField = "MemberId";
ddlMember.DataBind();
}
ddlMember.Items.Insert(0, new ListItem("--SELECT MEMBER--", "0"));
}
