protected void LoadMember() { ddlMember.Items.Clear(); BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster(); Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster(); if (ddlBlock.SelectedIndex == 0) { membermaster.BlockId = 0; } else { membermaster.BlockId = Convert.ToInt32(ddlBlock.SelectedValue.Trim()); } if (ddlDistrict.SelectedIndex == 0) { membermaster.DistrictId = 0; } else { membermaster.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue.Trim()); } if (ddlState.SelectedIndex == 0) { membermaster.StateId = 0; } else { membermaster.StateId = Convert.ToInt32(ddlState.SelectedValue.Trim()); } if (ddlMembershipCategory.SelectedIndex == 0) { membermaster.CategoryId = 0; } else { membermaster.CategoryId = Convert.ToInt32(ddlMembershipCategory.SelectedValue.Trim()); } membermaster.MemberName = string.Empty; DataTable dt = objMember.MemberMaster_GetAll_ForReport(membermaster); if (dt != null) { ddlMember.DataSource = dt; ddlMember.DataTextField = "MemberName"; ddlMember.DataValueField = "MemberId"; ddlMember.DataBind(); } ddlMember.Items.Insert(0, li); }
private void LoadMemberList() { BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster(); Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster(); membermaster.BlockId = 0; membermaster.DistrictId = 0; membermaster.StateId = 0; membermaster.CategoryId = 0; membermaster.MemberName = string.Empty; DataTable dt = objMember.MemberMaster_GetAll_ForReport(membermaster); DataView dv = new DataView(dt); //dv.RowFilter = "IsNull(IsApproved,0) = 1 And IsNull(IsActive,0) = 1"; ddlMember.DataSource = dv; ddlMember.DataBind(); ddlMember.Items.Insert(0, new ListItem("--Select Member--", "0")); }
protected void LoadMember() { BusinessLayer.Common.MemberMaster objMember = new BusinessLayer.Common.MemberMaster(); Entity.Common.MemberMaster membermaster = new Entity.Common.MemberMaster(); membermaster.BlockId = 0; membermaster.DistrictId = 0; membermaster.StateId = 0; membermaster.CategoryId = 0; membermaster.MemberName = string.Empty; DataTable dt = objMember.MemberMaster_GetAll_ForReport(membermaster); if (dt != null) { ddlMember.DataSource = dt; ddlMember.DataBind(); } //ddlMember.Items.Insert(0, li); }