Gridview Paging Using Linq?
Oct 5, 2010
I am retrieving data from sql database. I want to split the records and binding it in three different grids. Everything is working fine before applying paging. I am getting The data source does not support server-side data paging. error
Code:
DataTable StoreDisplayTypeList = storeDisplayBL.GetStoreDisplayDetails();
var specialBook = from myRow in StoreDisplayTypeList.AsEnumerable() where (string)myRow["StoreDisplayType"] == "Special Book" select myRow;
var newRelease = from myRow in StoreDisplayTypeList.AsEnumerable() where (string)myRow["StoreDisplayType"] == "New Release" select myRow;
var Seller = from myRow in StoreDisplayTypeList.AsEnumerable() where (string)myRow["StoreDisplayType"] == "Best Seller" select myRow;
var featuredEdition = from myRow in StoreDisplayTypeList.AsEnumerable() where (string)myRow["StoreDisplayType"] == "Featured Edition" select myRow;
this.gvBestSeller.DataSource = Seller;
this.gvBestSeller.DataBind(); // Error
this.gvNewRelease.DataSource = newRelease;
this.gvNewRelease.DataBind(); // Error
this.gvSpecialBook.DataSource = specialBook;
this.gvSpecialBook.DataBind(); // Error
this.gvFeaturedREdition.DataSource = featuredEdition;
this.gvFeaturedREdition.DataBind(); // Error
View 1 Replies
Similar Messages:
Jan 24, 2011
It has been more than 2 days since I had started searching for the answer and I still don't know how to do it.
I have empty gridview that is filled with data depending of the parameters given. The gridview is used to track changes user had made to the database.
In the first dropdown list the user selects from which table (or all tables) to display the data. From the second dropdown list the user selects from which column (or all columns) of the previously selected table to display data. In the first textbox the user enters the search term and in the third and fourth textboxes the user enters the date range in which the changes occurred.
After clicking button the data within the given parameters should be displayed. The problem is that data is displayed fine, but I can't manage to get sorting and paging to work so if possible, give concrete answer because I'm pretty sure I googled one half of the web during these 2 days. :)
Here is the code for the .aspx file:
[Code]....
Here is the codebehind:
[Code]....
To sum everything up... My question is: "How to enable sorting and paging for this code?"
View 3 Replies
Aug 27, 2010
I am looking for a way to do paging with a GridView when i set the datasource at run time using a linq query. here is my code:
ETDataContext etdc = new ETDataContext();
var accts = from a in etdc.ACCOUNTs
orderby a.account_id
select new
{
Account = a.account_id,
aType = a.SERVICEs.FirstOrDefault().SERVICE_TYPE.service_type_desc,
name = a.SERVICEs.FirstOrDefault().service_name,
[Code]....
But that works well when you use a datatable but not with linq. If I add a rebind in the event, it has to requery 7000 records which can be a little slow. Does anyone know how to fix the paging when using linq like this?
View 1 Replies
Jun 28, 2010
Both the Method 1 and Method 2 can handle the paging of GridView, could you tell me how about the performance of the Method 1?and how much will Method 1 slower than Method 2
#region ForPaging
public static List<HD_ToDoList> Get_ToDoListByUserNameForPage(string username, int StartIndex, int PageSize)
{
[code]...
View 3 Replies
Mar 20, 2010
on my WebApplication I have GridViews filled with a LinQ-Query. Like this
Dim teamA = (From t
In datacontext10.T_TEAM
Where t.group =
"A"
Order
By t.sort)
GridViewA.DataSource = teamA
GridViewA.DataBind()
Now I want do enable automated Sorting and Paging? How could that work? Could I use a ObjectDataSource? Which control could do that for me?
View 2 Replies
Jan 31, 2010
I started learning LINQ, So i thought of just creating gridview with sorting and paging using objectdatasource using LINQ. So i got this link
[URL] which Brian Orrel tell us how to do using IQueryable Interface. but i have nearly 300 lines of stored procedure which joins nearly 20 tables. so i thought of creating a stored procedure and using that instead of IQuerytable.
[code]...
View 7 Replies
Nov 18, 2010
Is there a way to use the GridView paging and having the links not use JavaScript. So that when you click on the page number 5 (for example) that link is a hyperlink.
View 3 Replies
Dec 20, 2010
I have a simple page that looks up contacts using a webservice with a single method written in Linq. On the page, I have both a gridview and a listview with a DataPager to compare the two. I can get paging working just fine with the gridview, but the Linq code has to return all of the data on each call and let the web page pick out only a page's worth... not the best solution. I have been told that a ListView will solve this problem, but all the examples I have been able to find have the Linq code on the web page instead of in a separate layer (e.g. a webservice). Ideally, I should be able to tell the web service to bring back a specific page worth of data (starting record number and number of rows), but how do I get the ListView (or the DataPager) to fire an event that asks for this data?
Here is the ASPX code:
<asp:ListView ID="listPersons" runat="server"> <LayoutTemplate>
<table> <thread> <tr> <th> Site ID </th> <th> PersonID </th>
<th> Person Name </th> </thead> <tbody>
<asp:PlaceHolder ID="itemPlaceholder" runat="server" /> </tbody> </table>
<asp:DataPager ID="Pager1" runat="server" PagedControlID="listPersons" PageSize="5" > <Fields>
<asp:NextPreviousPagerField ShowFirstPageButton="true" ShowPreviousPageButton="true" ShowNextPageButton="false" ShowLastPageButton="false" /> <asp:NumericPagerField />
<asp:NextPreviousPagerField ShowFirstPageButton="false" ShowPreviousPageButton="false" ShowNextPageButton="true" ShowLastPageButton="true" />
</Fields> </asp:DataPager> </LayoutTemplate> <ItemTemplate><tr> <td> <%# Eval("SiteID") %>
</td> <td> <%# Eval("PersonID") %> </td> <td> <%# Eval("PersonName") %> </td>
</tr> </ItemTemplate> <EmptyDataTemplate> No data found... </EmptyDataTemplate> </asp:ListView>
Here's the code behind:
private void DoList(string Match) {
ContactsService cs = new ContactsService();
listPersons.DataSource = cs.Find(Match, 100 ); listPersons.DataBind(); }
and the web serivice:
[WebMethod]
public List<Person>Find(string Match, int Count) { if (Count < 5) Count = 5;
using (DataLayer.ContactsDataContext context = new ContactsDataContext()) {
var Persons = from p in context.Persons where p.PersonName.Contains(Match)
orderby p.LastName, p.FirstName select new Person() {
SiteID = p.SiteID, PersonID = p.PersonID, PersonName = p.PersonName, };
return Persons.Take(Count).ToList(); } }
View 1 Replies
Dec 29, 2010
I've got the following LINQ query to my IQueryable service
Dim eventcount = EventService.QueryEvents().Count
Dim eventlist = EventService.QueryEvents().Skip((page - 1) * 5).Take(5).ToList
But I'm wondering if there's a way to do this without making two calls to the database?
View 2 Replies
Jan 31, 2010
I need some code to a alphabetic paging in a repeater. the code should be in linq / c #.
View 3 Replies
Jan 28, 2011
I have a parent gridview5 with child gridview 6, today i deployed it to our dev server and on that server we have alot more records, so for the nested gridviews i need to enable paging on the parent gridview5. Doing so works fine, until i make a selection within the child gridview6, once any selection is made, and i try to page the page throws an error, i have the following bound to the parent gridview5.
[Code]....
[Code]....
View 4 Replies
May 7, 2015
In my asp.net Page I am using gridview. I am binding the gridview on page load and on paging event with one method. suppose as Bindgridview1();.
There is one search button for searching the records of user with different method suppose as Bindgridview2(); .
when I am searching the records with Bindgridview2(); paging doesn't work and directly bind with Bindgridview1(); which is on page load when I clicked next page.
View 1 Replies
Jan 10, 2011
I'm trying to extend the GridView control to enable sorting and paging for any situation.
When using my control I am fetching data from a database and filling a DataSet with it, then binding the GridView upon every page load. My first question would be, is this the correct approach?
To sort the GridView I am overriding the OnSorting method which stores the sort expression and direction in the ViewState, then creates a DataView and utalises the Sort method to sort the underlying data. It then sets the Data Source to this DataView and rebinds the GridView.
Paging is handled by OnPageIndexChanging which simply sets the PageIndex property and again rebinds the GridView.
My problem is; when any control causes a postback my GridView is no longer sorted, presumably because it is persistently rebound. If I don't rebind it then the GridView is empty on postback since the data isn't automatically stored in the ViewState. I have considered saving the data source in the ViewState but I would assume that this is bad practice for large amounts of data? - also DataViews are not seralisable.
The only solution I can think of currently is to override OnDataBound and sort the data every time. This results in a double sort when paging triggers a postback which seems inefficient. Code illustration of this below,
[Code]....
I'm looking for the cleanest 'best practice' solution as this is a learning exercise more than anything else.
View 12 Replies
Dec 1, 2013
I have a GridView that is populated via a dataset that contain 1 table. I have enabled paging on my GridView.
In my Updating event, I handle the new values and call a store proc to update my database with the new values for the selected row. In order to minimize the call to the DB, instead of getting back a new dataset with the updated values, I simply update the row of the dataset that I have in session with the new values and then I bind back my gridview.
The problem that I have is since I have let's say 5 pages of 10 row... If I update a row on the first page as soon as I click update, the gridview will show the new values. However, if I select page 3 for example, click on update and update the values, once the update is done, the gridview will still be displayed with the old values.
View 4 Replies
May 16, 2010
My question is, can I control the style of the paging element separately of top and bottom, I have set the paging to appear in both top and bottom of the gridview, and I want to see that the top pagination is little high up in the page, to do that I used the cssClass and set margin-top:20px and made the position: absolute, this does change the position of the top paging area and set it rightly for me, but the bottom pagination has also come up as a result and now sits inside the grid data!!
View 3 Replies
Jul 15, 2010
On my gridview I allow paging. After the user leaves for a new screen is it possible to have them return to the gridview page they had?
View 8 Replies
Jul 13, 2010
I hoping someone could answer a question for me. I am relatively new to developing web applications with .NET and I have question I can't seem to find a straight answer to. When allowing paging of a GridView control, how does retrieve the data per-page? Is all the data stored into an object, and then displayed x amount of rows at a time? Or, when moving from page to page, is it executing each time but restraining the result to the specified amount of rows?
View 7 Replies
Mar 26, 2011
i am paging my grid view datas. now am on 3rd page of gridview. in 3rd page i have list of buttons in each rows. when i click on one button it goes to another webpage. where i edit datas and save. when i click on save it comes back to page having grid..which loads from 1st page of grid...i want to load the 3rd page of gridview itself.
View 2 Replies
Apr 8, 2010
I have followed Custom Pagination article to implement the custom pagination using GridView.
I have also done custom pagination using the DataGrid but i am still confused on following things.
DataGrid which is there in the ASP.NET 1.1 having VirtualItemCount which is set to render the pagination interface [1 2 3 4 5 ... something like this] GridView does not have the above mentioned property then how to generate the pagination UI?
View 1 Replies
Mar 4, 2010
protected void Button3_Click(object sender, EventArgs e) //export
{
GridView2.AllowPaging = false;
GridViewExportUtil.Export("Сводка.xls", this.GridView2);
GridView2.AllowPaging = true;
}
I need to avoid pageing for XLS export :-/
View 1 Replies
May 19, 2012
I am using below paging code
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) {
GridView1.PageIndex = e.NewPageIndex; }
is it enough?
View 1 Replies
Feb 9, 2011
I'd like to implement a custom paging template for my formview that displays numeric paging as well as next/previous buttons. The pre-defined templates only appear to have numeric first last as an option. Can anyone recommend a good article that covers this?
View 2 Replies
Jan 23, 2010
I'm binding a dataview to a GridView and am trying to use GridView Paging. When I click on one of the page numbers, the Grid disappears.
Code:
If Page.IsPostBack = False
GridView1.AutoGenerateColumns = False
GridView1.AllowPaging = True
GridView1.PageSize = 5
[code]...
View 8 Replies
Oct 14, 2010
I had gridview which retrieve Products from database by sqldatasource1 ,and my manager asked me to filter this gridview by DDL to filter gridview with specfic Model ,I add some function on gridview as edit,paging .I did my code well and gridview filtred by the Model_Id which come from DDL .But when I tried to edit any product or navigate through paging I faced this error (The GridView 'GridView1' fired event PageIndexChanging which wasn't handled. )when paging ,And this for editing (The GridView 'GridView1' fired event RowEditing which wasn't handled.)
protected void Page_Load(object sender, EventArgs e)
BindGridFunction();
[code]...
View 1 Replies
Dec 30, 2010
I have an ASP .NET GridView with Paging. One column in it has a CheckBox. In a certain scenario, I want to uncheck the checkboxes that are checked.
foreach (GridViewRow dr in gvMyGridView.Rows)
{
if (dr.RowType == DataControlRowType.DataRow)
{
if ((CheckBox)dr.FindControl("chkIsApplicable") != null)
{
((CheckBox)dr.FindControl("chkIsApplicable")).Checked = false;
}
}
}
But unfortunately because of Paging only the records that are currently shown in the Grid can be accessed in this way. I want it to apply to ALL the items in the GridView. This should happen client side and when the user commits will get saved to the database.
View 1 Replies
