Linq's Got Issues
-
Hey everyone, I was trying to achieve custom data paging by using LINQ but LINQ has got some issues. Ok let me introduce what i've done and got back. There are 2 dropdownlists and listbox on my page. one of dropdownlists is for Page Number and the other is for Page size and the results show in ListBox. Page number is changing according to selected size at dropdownlist which is for page size. and the related code is here : private void FindPageTotalNumber() { ddPageIndex.Items.Clear(); UsersDataContext tu = new UsersDataContext(); var allusersNumbers = from users in tu.Kullanicis select new { users.KullaniciID }; int selectedPageSize = Convert.ToInt32(ddPageSize.SelectedItem.Text); int count = allusersNumbers.Count(); int totalPageSize = 0; if (count % selectedPageSize == 0) { totalPageSize = count / selectedPageSize; } else { totalPageSize = (count / selectedPageSize) + 1; } for (int i = 1; i <= totalPageSize; i++) { ddPageIndex.Items.Add(i.ToString()); } } Now here is the DataBind Code to bind related data to ListBox after changing page number or page size : private void BindDataToUsersListBox() { UsersDataContext u = new UsersDataContext(); var users = from au in u.Kullanicis select new { au.KullaniciAdi, au.KullaniciID }; int pageIndex = Convert.ToInt32(ddPageIndex.SelectedItem.Text); int pageSize= Convert.ToInt32(ddPageSize.SelectedItem.Text); lbKullanicilar.DataSource = users.Skip((Convert.ToInt32(pageIndex)-1)*pageSize).Take(pageSize); lbKullanicilar.DataBind(); } The other Stuff : protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { FindPageTotalNumber(); BindDataToUsersListBox(); } } protected void ddPageSize_SelectedIndexChanged(object sender, EventArgs e) { FindPageTotalNumber(); BindDataToUsersListBox(); } protected void ddPageIndex_SelectedIndexChanged(object sender, EventArgs e) { BindDataToUsersListBox(); } Ok now when I select page size 1, naturally page index is increasing and should show data one by