I am using ListView/DataPager.
For performance reasons I page my results at database, using ROW_NUMBER(SQl2005).
At my C# code just comes one page at time. How can I say to DataPager that I have more rows that really are at my List?
i have a listview to show some data and with it i have a datapager the datapager is used for allowing change pages between products but i have and hyperlink above product image that allow to see the specific product details but the datapager wehn a used clicks to see product details should not be visible because there is no more pages , its a specific product but the datapager should be visible in the other scenario how can i do that?
View 2 RepliesI'm using a ListView with a Paged DataSource. When the ObjectDataSource tries to fetch data from the "GetData"-method, the parameter PageSize is set to -1, even though I have set the PageSize to 8 in the DataPager.
Have I forgotten something?
<asp:ListView DataSourceID="odsProductIndex" ID="lstProductIndex" runat="server" OnItemDataBound="lstProductIndex_ItemDataBound">
<LayoutTemplate>
<asp:PlaceHolder ID="itemPlaceHolder" runat="server"></asp:PlaceHolder>[code]....
In ASP.NET 4.0 webforms, I'm trying to export a paged ListView control to an Excel file by un-paging the ListView's (trucks) datasource:
dsTrucks.EnablePaging = false;
For a non-paged ListView control, I can get it to work.
Here's the attempt to "un-page" and then export the ListView control:
[Code]....
There's no error but the output in the Excel file is still just one page of the ListView control instead of all rows.
I have a model called 'BusinessPage' which can be associated with 1 or more 'BusinessPageCategories'. So I've got a 3rd table called 'BusinessPagesInCategories' that links these two.I am trying to get a paged recordset of BusinessPages, along with the total number of records (I may have 100 rows in total but only return 20 at a time, but I pass back an int containing that total number in addition to the 20 rows).The problem I have is that, since I implemented the Many-To-Many relationship, it was bringing back the same BusinessPage row x times (where x is the number of categories that BusinessPage is associated with). I only want a single instance of each business page to be returned. So I added the following to my NHibernate Criteria to give Distinct BusinessPage results..SetResultTransformer(CriteriaSpecification.DistinctRootEntity);
Whilst this works for me, in that I'm now correctly getting a single row per BusinessPage (and my Categories property within each BusinessPage contains the correct x categories that it's assigned to), my row count is not reflecting that 'distinct' count - instead, if I have just 1 BusinessPage record which is associated with 3 categories, the row count is 3!?!
public virtual int BusinessPageId { get; private set; }
public virtual IList<BusinessPageCategory> Categories { get; set; }
public virtual string BusinessName { get; set; }
[code]...
Using a SubSonic (2.2) SqlQuery object, I am querying a view that contains distinct rows from another table. The results of the query, however, contain multiple rows for certain rows in the view. It appears to be because of a join on a temporary table in the query generated to achieve paging. How can I avoid this duplication of rows?
Bonus points: I have to use the view because SubSonic can't do .Paged() and .Distinct() at the same time. Why not?
I got a list of customers I thought I would list in a gridview or a repeater with customer html, it gone have paging. I'm gone have a checkbox for each customer in the list. Do you guys have any suggestions on how I should do to keep the checkbox value when I go to page 2-3-4 ect in the paging. I'm thinking a session to store the id of the checked customers. After I'm done setting the values they go to the database.
Do you got any other ideas then the session I'm thinking of?
I am trying to determine the number of pages in a custom paged control I have Built
there are 46 records and I am trying to get to the exact number of pages when there are 5, 10, 25 items per page etc...
at 5 items per page I should have 10 pages
and at 10 items per pages I should have 5 pages
but my code returns values that cannot use.
this is my code:
[Code]....
those are values I get.
When maxrowperpage is 5
pagecountConverted is = 9
pagecount is = 9
When maxrowperpage is 10
pagecountConverted is = 5
pagecount is = 5
how can I get a correct quotient?
I have a gridview that is a directory of people with about 50 pages
How would I make another gridview that had first row with 26 columns, 1 for each letter of the
alphabet and second row with the first page that has last names that start with that letter.
I need to make a large Ebay-style list of listings (think of the page that comes up when you search for something in Ebay, with a photo, title, one-line description, price, that's paged, and sortable). My limited experience with DataGrids in the past always resulted in what felt like a sluggish page to me, but I'm not sure if it would have been faster if I had pieced it together with a data reader instead.So I'm wondering before I even get started, what is the fastest / most efficient way to retrieve and manage this data.Is it more efficient at runtime to use a DataGrid, or to write the paging and sorting in more manually and use a DataReader, or another way?Ebay manages to get thousands of listings to display very quickly, but they've obviously got a lot of manpower to squeeze every last bit of performance they can out of the site, and good high-powered servers.
View 5 RepliesI have a DataGrid that has event handlers bound to SortCommand and PageIndexChanged. How can I determine if those event handlers are about to be called, say on page_load? These events will fire just fine after page_load, but I'd like to know at page_load if they are to be fired.
View 1 RepliesI am using a Listview and Datapager control. But when I refresh the page it always set the datapager to page 1. I want that it should be in the same page after refreshing. For example I want the same functionality as stackoverflow is having like: http://stackoverflow.com/questions/tagged/datapager. How to do this can any one help.
View 1 RepliesI've already searched to no avail for an answer to this question:is it possible to dynamically alter the page size in a paged gridview based on data in a particular column?In other words,let's say I get data from a table that lists students enrolled in a particular course.If there are 10 students in Course "A," then I want page 1 in my gridview to show 10 records.
If there are 15 students in Course "B," then I want page 2 in my gridview to show those 15 records,and so on.I imagine that this could probably be done with a master-detail kind of set up,but let's say for the sake of argument that I don't want to go that route.
I have a ListView that I am paging with a DataPager. I would like to set the initial page of the pager on Page_Load. I have tried the DataPager.SetPageProperties method but it's not doing what I need. Here's how I'm calling this method: dataPager.SetPageProperties(3, dataPager.TotalRowCount, false);
The line above trims the datasource to start at the third item and paging still starts at 1. This is not what I want. I want to keep the entire list of items and just jump to a specific page in the list. Is there another Property and/or method of a DataPager and/or ListView that I should use?
Can we use a DataPager for a DataList?I've done it but the following exception has occurred !!!Source Error: n unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[InvalidOperationException: Control 'DataList1' does not implement IPageableItemContainer.]
System.Web.UI.WebControls.DataPager.FindPageableItemContainer() +500609
System.Web.UI.WebControls.DataPager.OnInit(EventArgs e) +33
[code]...
I am using a datapager on a page where different images are shown. Now i am using the following code:-
PHP Code:
<asp:DataPager ID="DataPager1" runat="server"
PagedControlID="lvPhotoViewer" PageSize="1"
onprerender="DataPager1_PreRender">
<Fields>
<asp:NextPreviousPagerField ButtonType="Link"
PreviousPageText="<< Previous" NextPageText="Next >>"/>
</Fields>
</asp:DataPager>
Now this code does run through all the images, but i need to alter the querystring and make it change to match the ID of the photo displayed. I tried adding QueryStringField="String" but this was hopeless.
I have a querystring like so:-
Quote:
[URL]
When i click on next image i need it to change to something like:-
Quote:
[URL]
See the PhotoID has changed. But it currently does not do this. When i arrive on the page the PhotoID stays the same. I have been trying for a while and im starting to give up!
So was wondering if there was an alternative.
I am really fed up with a datapager I am using as I cant change the value of the querystring. I currently have this code:-
[Code]....
When I first arrive on the page I see this querystring, depending on the picture selected a different ID will be shown:- [URL]
See the bold. When I click on the next image I need the querystring to change to the ID of the image. So something like. But it does not work, I don't know to do it. I tried with adding QueryStringField="String" but this didn't work either.
I have a datapager with next and previous buttons as so:
<asp:DataPager ID="dpFeaturedPager" PagedControlID="lvFeaturedTips" QueryStringField="ftpg" PageSize="1" runat="server">
<Fields>
<asp:nextpreviouspagerfield ButtonCssClass="featured-previous" PreviousPageText="Previous" ShowNextPageButton="false" />
<asp:nextpreviouspagerfield ButtonCssClass="featured-next" NextPageText="Next" ShowPreviousPageButton="false" />
</Fields>
</asp:DataPager>
When there is only one page available, the Next and Previous links are rendered as so: <a disabled="disabled">Previous</a> I have not seen this disabled tag before, and presume it's coming from the datapager control which I won't be able to control. As usual, this is fine on FireFox but on IE7 the Previous and Next text does not render correctly - it is outlined (what I would expect disabled to look like to be honest - but looks a bit ugly in the page!)
I've just taken my first stab at making a ListView, ObjectDataSource, and DataPager run in an AJAX panel.
I had trouble getting it to work until I removed the QueryStringField="page" attribute from the DataPager. This attribute causes the current page to be passed as a query argument in the URL. For obvious reasons, I guess that won't work when posting back using AJAX.
Now my question is if this hurts my SEO. When I used QueryStringField, the page links appeared as regular links with various query arguments. But now the links are just javascript. Haven't I hurt a search engine's ability to scan related pages?
I am trying to use the photo_id of a picture whilst a user uses a datapager to select different images. I am also getting the photo_id of the pictures through a label within the listview. However now i need that value so i pull out comments from another table according to this photo_id. I currently have th following code:-
PHP Code:
<asp:ListView ID="lvPhotoViewer" runat="server" GroupItemCount="1"
onselectedindexchanged="lvPhotoViewer_SelectedIndexChanged">
<LayoutTemplate>
<table ID="groupPlaceholderContainer" runat="server" border="1">
<tr ID="groupPlaceholder" runat="server">
</tr>
</table>
</LayoutTemplate>
<ItemTemplate>
<td id="Td4" align="center" style="background-color: #eeeeee;">
<asp:Image runat="server" ID="imPhoto" Height="450px" Width="450px" ImageUrl='<%# string.Format("~/photos/{0}", Eval("photo")) %>' />
<br />
<asp:Label ID="DefaultPhotIDLabel" runat="server" Text='<%# Eval("photo_name") %>' />
[B][U] <asp:Label ID="Label5" runat="server" Text='<%# Eval("photo_id") %>'/>[/U][/B]
</td>
</ItemTemplate>
<GroupTemplate>..............
I've created links in the listview which is attached to the datapager. When a user clicks a link they see content to the left but the datapager changes from any page to page 1.
View 1 Repliesdear all im working in website in arabic lang "RTL" and im using datapager and i want numbers appears frm RTL "right to left"
View 3 RepliesI have a strange problem that I don't understand about DataPager. After changing the page set (pages 6 - 10 for example), and clicking on a page (6, 7, 8, 9 or 10), it will displa to the first set of pages counting from 1 again.
Let me explain. I have a ASP.Net page with Listview and DataPager.
<asp:ListView ... DataSourceId="EntityDataSource" DataKeyNames="id">
<LayoutTemplate>
<asp:DataPager runat="server" ID="DataPager1" PageSize="15">
<Fields>
[Code].....
All this works, but the problem is that the set of pages will not remember during postbacks. Let me explain this.
By first request of page, the pages show:
<< 1 2 3 4 5 ... >>
By clicking the ..., the next set of pages will be displayed (and also the data of page 6 will be displayed)
<< ... 6 7 8 9 10 ... >>
But when I click on page 7 to 10, the pages text will display the first set of pages 1-5.
I'm trying to use a DataPager to do Server Side paging. Here is my code
<asp:DataPager ID="pgrFooBars" PagedControlID="lvFooBars"
QueryStringField="page" runat="server" >
<Fields>[code]....
The problem is that the DataPager appears to be using the Count property of the ListView to determine the total number of records, which in this case is 20. Somehow, it needs to know that there are 1,500, not 20 total records. The DataPager has a property TotalRowCount, but this is read-only.I have never seen a DataPager example with Server Side paging, but assumed that it could do Server Side Paging, otherwise what good is the QueryStringField attribute?
I am aware that you can do a custom paging solution using methodology like the 4GuysFromRolla did here http://www.4guysfromrolla.com/articles/031506-1.aspx, but I'd first like to know if a solution with the DataPager is possible before creating a custom solution.
UPDATE,The more I look at this, the more that I'm coming to the conclusion that this is not possible and that, unfortunately, the datapager is a control meant for small web sites only. What I want to do should really be quite simple if the control were built correctly. I want to be able to say
dpFooBars.TotalRowCountComputed = false;
dpFooBars.TotalRowCount = AnyNumberThatISoChoose;
I've been looking for some hack to accomplish the same thing, but it appears that the datapager's TotalRowCount is computed from the actual number of items in the datasource that it's bound to. It seems very odd to me that Microsoft would create a ListViewPagedDataSource() class and a DataPager at the same time and not have them work correctly together, but this appears to have been what has happened.
UPDATE 2 (AHA MOMENT?It seems that it has been possible to do server side paging since .Net 2.0 by using an ObjectDataSource and customizing the SelectCountMethod(). I believe it should be possible to customize ObjectDataSource to suit my needs. Hmmm. I'm going away for the weekend, so it'll be a couple of days for me to see if this works. Stay tuned, true believers.
I'm using a datapager control on my listview to perform paging in it.
When paging through the table, I need to perform some validations. When these validations are not successfull, the paging should be cancelled.
I currently perform the validation in the PagePropertiesChanging event of the ListView, however, the arguments do not provide a Cancel property.
protected void MyListView_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e)
{
if (!Validate())
{ // cancel the paging action}
}