Paging Last Page Not Ikke First Page?
Jul 13, 2010
I've found a method to do paging, wich works perfect except that when loading the page it goes to first page and not last page...I want it to be a choise in the code if it should load first or last page.
I know I have to use:
int currentPage = DataPage.PageCount - 1; //Add
DataPage.CurrentPageIndex = currentPage; //Add
But I dont know where to put in the code. If I try to put the two above lines in, it runs to the last page......But then I cann't go to the other pages when clicking pagenumbers. It stays on the last page. Someone who knows where to put the code in? (I want it that way instead of CreatePagingLinks(bool displayRows) it should be CreatePagingLinks(bool displayRows, bool lastPage) - so I make my choise when using the CreatePagingLinks. The code where I try to put currentpageindex in look like this:
[Code]....
View 3 Replies
Similar Messages:
Feb 23, 2011
<PagerStyle HorizontalAlign="Right" CssClass="paging"/>
<PagerTemplate>
<table width="100%">
<tr>
<td style="text-align:left; width:50%">
<asp:LinkButton ID="lnkPrv" Visible="false" CommandName="Page" CommandArgument="Prev" runat="server">Previous</asp:LinkButton>
</td>
<td style="text-align:right; width:50%;padding-left:50%;">
<asp:LinkButton ID="lnkNext" CommandName="Page" CommandArgument="Next" runat="server">Next</asp:LinkButton>
</td>
</tr>
</table>
</PagerTemplate>
Code behind is below
protected void gvProduct_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
Literal1.Visible = gvProduct.PageIndex == 0;
LinkButton lnkPrv = (LinkButton)gvProduct.BottomPagerRow.FindControl("lnkPrv");
LinkButton lnkNext = (LinkButton)gvProduct.BottomPagerRow.FindControl("lnkNext");
lnkPrv.Visible = e.NewPageIndex > 0;
lnkNext.Visible = e.NewPageIndex < gvProduct.PageCount - 1;
gvProduct.PageIndex = e.NewPageIndex;
FillGrid();
}
The code does not give any error. I can see it set the visible property to true/false. But actual control on page remain same (always visible on every page).
View 2 Replies
Mar 10, 2011
I have 2 gridviews in 1 page and i want to enable paging in them. now, when I want to page the first gridview to its second page, I see Its second page but the second grid view disappears.
View 1 Replies
Feb 25, 2011
I am curious as to what people would thing is the best way to implement this. On my overview page, I have a data grid which is sortable and has custom filtering written for it. When you click on an item in the grid, it loads a separate page with details. I would like to implement result paging through on the detail page keeping in the same order as the previous page data grid. Now I've thought of a few ways to do this:
Change the link to be a postback and handle the sort order programatically Sort filter and sort settings on application of the settings in the session Pass the filter and sort settings on the query string to the detail page. None of these seem very clean to me, and option 3 is the only cogent option I've thought of. Am I missing something? Is there a more elegant way to do this?
View 1 Replies
Feb 4, 2011
I have several partial views on the same view. They each have IEnumerables in a WebGrid with paging.
When I page one, they all page to the same page.
How do I fix this so each has a working pager?
View 9 Replies
Mar 10, 2010
I made a comments area with 4 labels, 4 textboxes and the Submit button. When the user clicks on "Submit" in order to INSERT DATA, it realoads the entire page and change the 'focus' to the beginning of the page. How can i change that so that onClick, it INSERTS successfully the data and come back to the row of the comments? Or maybe it just updates that comments area instead of the whole page? And also i have a Listview control to show all the comments and it has PAGING enabled. But when the user clicks on the paging buttons, it reloads the entire page and the user sees the beginning of the page, and he has to scroll down again to go back to the comments area.
View 9 Replies
Nov 29, 2010
I am performing "semi"-custom paging for my dynamic LINQ query. However, if the number of results returned exactly fill the page, then I wind up with one extra page that's empty and I can't figure out why. i.e. if I have a page size of 15 and 14, 21, 101, etc. items then everything is fine. However, if I have 15, 30, 45, 60, etc. then I get one extra blank page and I've been unable to make it stop. Anyone have some ideas except to add a new record when I see we're sitting on a multiple of the page size?
I write out the paging control like this and it loops through one time too many if the last page is full...
[code]....
View 4 Replies
Nov 15, 2010
I'm having a bit of trouble with Paging within a GridView grid I have set up. I have added the paging but whenever I click on the next page or the last page buttons, the page refreshes and displays blank (i.e. no gridview but my regular search parameters are displayed.
I was trying to search for a solution throughout the web and came across someone that looked to have the same issue. He moved all of his queries into the Page Load method, and the paging seemed to work. I cannot do this because I have 2 different buttons: Search and My Order, both of which perform different queries based on if a date has been selected or what the search is on (Order Number, License Number, Description, Status, etc).
My paging method looks as follows:
[Code]....
From what I can tell this is an issue with no longer having the data set when making the paging call. Is there anythign that I can do?
View 18 Replies
Jan 4, 2011
I have a Gridview all setup and even though I have the paging working it takes select the page twice in order to switch the page. Basically my code is as follows:
[Code]....
View 2 Replies
Mar 10, 2011
how to get "Paging Without The WebGrid.I'm using the example from the article I have done so
[Code]....
My goal was to sample books page to only one category and Paging for the data view.
View 1 Replies
Dec 13, 2010
I have a gridview control on a .aspx page (content form).
Paging is enabled on gridview control. It displays the page numbers at the bottom of the .aspx page. When I click on a page number say 3, I get error saying the "Exception Details: System.Web.HttpException: The GridView 'GridViewReconresults' fired event PageIndexChanging which wasn't handled."
Do I need to write special code to handle the paging? Because there is a grid in another page and it has bound columns and I didn't write any code for paging and it works perfectly fine.
Here is the code in the .aspx page that I have problem.
[Code]...
View 4 Replies
Feb 19, 2010
What is the process for allowing paging in a gridview on a page where the user submits information in order to fill the gridview?
The gridview is being fill without a datasource but instead with a datatable.
[Code]....
View 7 Replies
Mar 18, 2010
When we set allowpaging=true and specify the pagesize=xx, and when we change the page of the gird view then, does paging in gridview make a database call when its page gets changed ?
View 4 Replies
Mar 31, 2010
I'm having a problem regarding the report... If you can see the paging of the report viewer does not show the page number. ex. 1 of n. then, when im trying to export the report, after I choose which format and hit the "Export", nothing happens. Also, this report has many pages and I can't view the other pages because of the paging problem.
View 1 Replies
May 9, 2012
So I have a repeater which binds page numbers. That's all fine. I need to know how to make the paging so that they are in "chunks" of a max of 10 page numbers being displayed at a time.Then if they select a page number, it will show the previous x pages and the next y pages (within the 10 chunk range). similar to google paging I guess. Not using pagedDataSource/gridview/gridlist! This is just purely getting the page numbers.
View 1 Replies
Jun 10, 2012
I use pagination for my datalist according to this link [URL].....
this is style of pagination
First 1,2,3,4,5 Last
when i run web site i see my datalist with pagination in webpage my datalist is middle of page when i click on page number 2 or 3 to see other page of datalist it reload page and go to top of page i should scroll until I can see my datalist again.
i want when users click on page number after that they see other page of datalist directly not top of page ..
View 1 Replies
Oct 14, 2010
I do long and slow query to get data to my GridView and I got lot of data, but when I'm changing page it loads as slow as at the start, it loads full data again and again, how to load data once and use paging without data loading?
View 1 Replies
Dec 30, 2010
I want to display the paging format like 1 2 3 4 5 ....... 20 in gridview pagnation
here total number of pages count is 20.
if user clicks on the 20,then the page no 20 will be display..
and the user cilcks on .....,the next five pages has to display with last page number like 6 7 8 9 10 ....... 20
View 3 Replies
Jan 12, 2011
So my problem is as followes:
i have a gridview in another gridview (gv2 inside gv1).
in codebehind, at pageload i have: [Code]....
witch gives me a number of total records in the gv2 to a label. something like a coment number label.
my problem occures when i press the page button (allowpaging = true) on the first gridview. it acts kinda like this:
it makes the second gridview.visible = true; doest string the number of rows, and the label.text = "";
i've tried to make a code like this:
if (Ispostback)
{
gridview1.databind();
foreach ...etc..
}
else
{
foreach ....etc...
}
Also the gridview 1 and 2 the datasource is an SqlDataSource.
but that didnt work . also tried some things in pageindexchanged and pageindexchanging but still no efect :(. and also tried with enableviewstate = false / true on both gridviews with diferent combinations, but still no luck.
the code works only when i have allowpaging = false, or when im on the first page of the gridview (for the first time) is that the number of coments is pasted into the label.
View 3 Replies
May 7, 2015
I had implemented the Ajax timer control to update Gridview data(along with Progress bar inside Gridview) after some interval of time.Below is the full code:
HMTL:
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
<%--style & Script for progress bar in Gridview --%>
<script type="text/javascript" src="//code.jquery.com/jquery-1.10.2.js"></script>
<script type="text/javascript" src="//code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
<link href="css/jquery-ui.css" rel="stylesheet" />
[Code] ....
C#:
protected void Page_Load(object sender, EventArgs e) {
if (!this.IsPostBack) {
BindGrid();
} }
protected void BindGrid() {
string query = "SELECT * FROM Table";
[Code] ....
It is working fine except that the Gridview paging is taking some time(15-20 seconds) to go to next page.
View 1 Replies
Feb 9, 2010
I have a datalist and want the results paged I have written a pager.ascx page and have an aspx and aspx.cs page to display the results. I have a stored procedure to pull the data out of the database and a class to talk between the stored procedure and presentation controls I have the pager being displayed when the results get over the limit I have set to 10 in the web.config file but when i click on the next link to display the next page of results it doesn't do anything. my aspx page is
<uc1:Pager ID="topPager" runat="server" Visible="False" />
<asp:DataList ID="newsList" runat="server" CssClass="List" align="center">
<ItemStyle CssClass="ItemList" />
<ItemTemplate>
<h2><%# Eval("Title") %></h2>
<p>Posted <%# Eval("Date") %></p>
<p><%# Eval("News").ToString().Replace("
", "<br />") %></p>
</ItemTemplate>
</asp:DataList>
<uc1:Pager ID="bottomPager" runat="server" Visible="False" />
my aspx.cs page is
protected void Page_Load(object sender, EventArgs e)
{
// Retreive page from the query string
string page = Request.QueryString["Page"];
if (page == null) page = "1";
// How many pages of posts
int howManyPages = 1;
// pager links format
string firstPageUrl = "";
string pagerFormat = "";
//DataAccess.GetNews returns a DataTable object containing news data which is read into datalist
newsList.DataSource = DataAccess.GetNews(page, out howManyPages);
// Bind the data to the data source
newsList.DataBind();
// have the current page as interger
int currentPage = Int32.Parse(page);
// Display pager controls
topPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, false);
bottomPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, true);
}
my pager.ascx page is
<p>
Page
<asp:Label ID="currentPagelabel" runat="server" />
of
<asp:Label ID="howManyPageLabel" runat="server" />
|
<asp:HyperLink ID="previousLink" runat="server">Previous</asp:HyperLink>
<asp:Repeater ID="pagesRepeater" runat="server">
<ItemTemplate>
<asp:HyperLink ID="hyperlink" runat="server" Text='<%# Eval("Page") %>' NavigateUrl='<%# Eval("Url") %>' />
</ItemTemplate>
</asp:Repeater>
<asp:HyperLink ID="nextLink" runat="server">Next</asp:HyperLink>
</p>
my pager.aspx.cs page is
using System;
// Simple struct that represents a (page number, url) association
public struct PageUrl
{
private string page;
private string url;
// Page property definition
public string Page
{
get
{
return page;
}
}
// Url property definition
public string Url
{
get
{
return url;
}
}
// Constructor
public PageUrl(string page, string url)
{
this.page = page;
this.url = url;
}
}
// The pager control
public partial class UserControls_Pager : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
}
// Show the pager
public void Show(int currentPage, int howManyPages, string firstPageUrl, string pageUrlFormat, bool showPages)
{
// Display paging controls
if (howManyPages > 1)
{
// make the pager visable
this.Visible = true;
// Display the current page
currentPagelabel.Text = currentPage.ToString();
howManyPageLabel.Text = howManyPages.ToString();
// Create the Previous link
if (currentPage == 1)
{
previousLink.Enabled = false;
}
else
{
previousLink.NavigateUrl = (currentPage == 2) ? firstPageUrl : String.Format(pageUrlFormat, currentPage - 1);
}
// Create the Next link
if (currentPage == howManyPages)
{
nextLink.Enabled = false;
}
else
{
nextLink.NavigateUrl = String.Format(pageUrlFormat, currentPage + 1);
}
// Create the page links
if (showPages)
{
// The list of pages and their URLs as an array
PageUrl[] pages = new PageUrl[howManyPages];
// Generate (page, url) elements
pages[0] = new PageUrl("1", firstPageUrl);
for (int i = 2; i <= howManyPages; i++)
{
pages[i - 1] = new PageUrl(i.ToString(), String.Format(pageUrlFormat, i));
}
// Do not generate a link for current page
pages[currentPage - 1] = new PageUrl((currentPage).ToString(), "");
// Feed the pages to the repeater
pagesRepeater.DataSource = pages;
pagesRepeater.DataBind();
}
}
}
}
my class file is
// Retreive the list of news posts
public static DataTable GetNews(string pageNumber, out int howManyPages)
{
// Get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// Set the stored procedure name
comm.CommandText = "GetNews";
// create a new parameter for page number
DbParameter param = comm.CreateParameter();
param.ParameterName = "@PageNumber";
param.Value = pageNumber;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// create a new parameter for products per page
param = comm.CreateParameter();
param.ParameterName = "@PostsPerPage";
param.Value = PlatiumMindProductionsConfiguration.PostsPerPage;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@HowManyPosts";
param.Direction = ParameterDirection.Output;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// Execute the stored procedure and saven the results in a DataTable
DataTable table = GenericDataAccess.ExecuteSelectCommand(comm);
// Calculate how many pages of posts and set the out parameter
int howManyPosts = Int32.Parse(comm.Parameters["@HowManyPosts"].Value.ToString());
howManyPages = (int)Math.Ceiling((double)howManyPosts / (double)PlatiumMindProductionsConfiguration.PostsPerPage);
// return the page of posts
return table;
}
my stored procedure is
ALTER PROCEDURE [dbo].[GetNews]
(@PageNumber INT,
@PostsPerPage INT,
@HowManyPosts INT OUTPUT)
AS
-- Declare a new table
DECLARE @News TABLE
(RowNumber INT,
NewsID INT,
Title NVARCHAR(50),
Date DATETIME,
News NVARCHAR(MAX))
-- Populate the table with the complete list
INSERT INTO @News
SELECT ROW_NUMBER() OVER (ORDER BY NewsID desc),
NewsID, Title, Date, News
FROM News
-- return the total number of posts
SELECT @HowManyPosts = COUNT(NewsID) FROM News
-- extract the request page of posts
SELECT NewsID, Title, DATE, News
FROM @News
WHERE RowNumber > (@PageNumber - 1) * @PostsPerPage
AND RowNumber <= @PageNumber * @PostsPerPage
View 1 Replies
Feb 25, 2010
I have a datalist inside 1 datalist.In the first datalist i am binding the "advertisement posted" date field from sql server. In the second datalist i am binding the ads posted on that date using an object datasource. my pro is, i need to show a total of 100 ads in one page. This should not depend on the date. Total 100 postings in the page. For example
Todays date (02/25/2010)
50 postings
yesterdays date (02/24/2010)
if 75 postings are there,
50 postings
it should display only 50 postings under yesterday's date remaining 25 postings should display in next page(paging) with the format like this
yesterdays date (02/24/2010)
remaining 25 postings
(02/23/2010)
75 postings
how can i do the paging like this?
View 3 Replies
Feb 10, 2011
I have a two webpages,in my first webpage i have gridview with 8 pages(paging) and four coloumns.In fourth coloumn i have a link button to redirect tosecond webpage ,now i am in gridview 4 th page(paging) then i clicked the link button and move to second
second webpage.
second webpage contain one button that will redirect to first webpage.if i come from second webpage to first webpage the gridview paging get reset.but i want to be on gridview 4th page(paging).
View 10 Replies
Jan 3, 2010
is there any way how to highlight the actual number of page where I am ? .... somethink like this: < 1 2 3 4 5
6 7 8 >
View 3 Replies
Feb 26, 2010
I'm trying to set paging on my gridview but when i click on a page it doesn't work. It return a blank page. Here's my code:
[Code]....
Behind code:
[Code]....
View 9 Replies
