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