/// <summary> /// Fetch data using LINQ techniques /// </summary> public void LinqFetchData() { var contact = (from c in smartDb.ContactUs select new { c.Id, c.Name, c.Email, c.Message, c.SentDate}).ToList(); var _pagedDataSource = new PagedDataSource { AllowCustomPaging = true, AllowPaging = true, PageSize = this.PageSize, DataSource = contact.Skip((this.CurrentPageIndex - 1) * this.PageSize) }; // Get the total pages this.PageCount = BaseSys.CalculateTotalPages(contact.Count, this.PageSize); // Get the pager info BaseSys.GetPaginationInfo(lbPaginationInfo, this.CurrentPageIndex, this.PageCount, Properties.Resources.NewsCount, contact.Count); this.StylePageNagiation(contact.Count); // Fill Repeater Data from PagedDataSource repeaterData.DataSource = _pagedDataSource; repeaterData.DataBind(); this.NavigationFor = "LoadingData"; }
/// <summary> /// Fetch data using LINQ techniques /// </summary> public void LinqFetchData() { var user = smartDb.SelectUser().ToList(); var _pagedDataSource = new PagedDataSource { AllowCustomPaging = true, AllowPaging = true, PageSize = this.PageSize, DataSource = user.Skip((this.CurrentPageIndex - 1) * this.PageSize) }; // Get the total pages this.PageCount = BaseSys.CalculateTotalPages(user.Count, this.PageSize); // Get the pager info BaseSys.GetPaginationInfo(lbPaginationInfo, this.CurrentPageIndex, this.PageCount, Properties.Resources.NewsCount, user.Count); this.StylePageNagiation(user.Count); // Fill Repeater Data from PagedDataSource repeaterData.DataSource = _pagedDataSource; repeaterData.DataBind(); this.NavigationFor = "LoadingData"; }
/// <summary> /// Search for data in xml file using both xsd dataset & LINQ techniques /// </summary> protected void LinqSearchData() { var contact = smartDb.SearchContacts(this.Keywrod).ToList(); var _pagedDataSource = new PagedDataSource { AllowCustomPaging = true, AllowPaging = true, PageSize = this.PageSize, DataSource = contact.Skip((this.CurrentPageIndex - 1) * this.PageSize) }; this.PageCount = BaseSys.CalculateTotalPages(contact.Count, this.PageSize); BaseSys.GetPaginationInfo(lbPaginationInfo, this.CurrentPageIndex, this.PageCount, Properties.Resources.Search, contact.Count); this.StylePageNagiation(contact.Count); // Fill Repeater Data from PagedDataSource repeaterData.DataSource = _pagedDataSource; repeaterData.DataBind(); // navibation pager will work for the following this.NavigationFor = "Search"; }