private async void BtnMarriedWomenFillFrid_Click(object sender, RoutedEventArgs e) { MembersService members = new MembersService(); list = await members.GetMembersByMarriedWomenWise(); MemberDatagridview.ItemsSource = list.Take(numberOfRecPerPage); int count = list.Take(numberOfRecPerPage).Count(); lblPageNumber.Content = count + " of " + list.Count; TotalNoPeople totalNoPeople = new TotalNoPeople(); // totalNoPeople.NoMales = list.OrderBy(x => x.).Where(x => x.Sex == "M").Count().ToString(); totalNoPeople.NoFemales = list.Where(x => x.Sex == "F" && x.STATUSTYPE == "M").Count().ToString(); this.DataContext = totalNoPeople; FillType = 5; }