protected void LoadMember() { 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()); } if (txtMemberName.Text == string.Empty) { membermaster.MemberName = string.Empty; } else { membermaster.MemberName = txtMemberName.Text.Trim(); } DataTable dt = objMember.GetAllOutstandingReport(membermaster); if (dt != null) { dgvMemberMaster.DataSource = dt; dgvMemberMaster.DataBind(); DataView dv = new DataView(dt); dv.RowFilter = "IsMember='Yes'"; lblTotalMember.Text = Convert.ToString(dv.ToTable().Rows.Count); } }