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
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.
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 >
I have a web user control with DataList control in it. In my .aspx page, I have a report header, an empty panel as a place holder, a report footer.In my .aspx.vb file, I'll loop through a list of departments. Within each department, I'll load a label to display the department name and the user control for the data, and add both the label and user control to the panel. So there are two variables:
the number of departments and the number of records in a user control.
Now I need to display the current page number and the total page number in the report footer. Is it doable? How? I'm thinking of this approach: declare a page variable count, count the number of department name labels and the number of records in a user control. When the total count reaches a number, such as 20, I'll break the page. This way, I can get the the page current number and the total number of pages. But how to add a page break to an asp.net page?
I want to add javascript onclick event on each page number in datagrid paging.
View 5 RepliesIn my database m having 1000 record and I want to display 10 record on each page on gridview so every time it fetch 1000 record so while page loading it is quite time consuming ..
View 1 RepliesI am trying to figure out why it won't display the other results when I click on the second and third links created by enabling the paging option the gridview control. it wasn't displaying properly.. also it may not make a lot of sense.. I'm a PHP programmer... I'm learning asp.net as part of a class and we're instructed to use the drag-and-drop method so forgive me, my asp.net skills are lacking and I am having a hard time learning it. Anyway I'm reposting the current code.. hopefully it will display properly this time. Here's the code for default2.aspx..
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" [URL]">
<html xmlns="[URL]
<head runat="server">
<title>My Mini Book Store</title>
<link href="styles.css" type="text/css" rel="Stylesheet" />
</head>
<body>
<div id="container">
<form id="form1" runat="server" defaultbutton="submit">
<h1 style="text-align: center">My Mini Book Store</h1>
<p>
Keyword Search:
<asp:TextBox ID="keyword" runat="server"></asp:TextBox>
<asp:Button ID="submit"
runat="server" Text="Search" />
<asp:Button ID="Reset" runat="server" Text="Reset" onclick="Reset_Click" />
</p>
<p>
<asp:label id="message" runat="server"/>
</p>
<p>
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/Books.mdb"
SelectCommand="SELECT [title], [ISBN], [editionNumber], [price] FROM [Titles] WHERE ([title] LIKE '%' + ? + '%')"
onselected="AccessDataSource1_Selected">
<SelectParameters>
<asp:ControlParameter ControlID="keyword" Name="title" PropertyName="Text"
Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="ISBN" DataSourceID="AccessDataSource1" ForeColor="#333333"
GridLines="None" PageSize="15">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:BoundField DataField="title" HeaderText="Title" SortExpression="title" />
<asp:BoundField DataField="ISBN" HeaderText="ISBN" ReadOnly="True"
SortExpression="ISBN" />
<asp:BoundField DataField="editionNumber" HeaderText="Edition Number"
SortExpression="editionNumber" >
<ItemStyle HorizontalAlign="Right" />
</asp:BoundField>
<asp:BoundField DataField="price" HeaderText="Price" SortExpression="price"
DataFormatString="{0:c}" >
<ItemStyle HorizontalAlign="Right" />
</asp:BoundField>
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</p>
</form>
</div>
</body>
</html>
Here's the code for Default2.aspx.cs...
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Reset_Click(object sender, EventArgs e)
{
keyword.Text = "";
message.Text = "";
}
protected void AccessDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
{
if (keyword.Text == "")
{
message.Text = "Please enter a keyword(s).";
}
else
{
message.Text = "Found " + Convert.ToString(e.AffectedRows) + " records with the keyword(s): " + keyword.Text;
}
}
}
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
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?
we have a classic ASP Webpage for displaying reporting data.
The process is following:
user inputs reporting criteria reporting criteria are passed to a method in a VB6 DLL containing the reporting business logic (generating a dynmic sql statement) VB6 DLL method returns xml data xml data are displayed with xsd transformation 150.000 datarows are displayed in some seconds (less than 10 seconds maybe) Now we want to extend this reporting function and decided to use asp.net (2.0) So I have written a little prototyp application with a SqlDataSource Object and a GridView Control.
A table with less data (about 100 or so) are displayed quickly.
But a view with about 150.000 datarows needs about 2 minutes and ended with a OutOfMemoryException!
The request of the customer is definitvely to display the data on one page like in the old classic asp application!
how to retrieve the column number in gridview
i am able to get the row number using this syntax <%# Container.DataItemIndex + 1 %>
but what about column number?
I want to display 2 levels of listview, where outer listview has a datapager with 1 inner listview per page. The code is:
[Code]....
Then I bound outer listview with data in page_load(), which will invoke ExerciseBound(). It work fine for 1st page. The code is:
[Code]....
When I click on 2nd page, it will invoke ChangeExercise(). The code is:
[Code]....
Suppose it will invoke ExerciseBound() again and display 2nd listviewitem, but it fails to invoke ExerciseBound(). I change ChangeExercise() to
[Code]....
But PagePropertiesChangingEventArgs does not contain ListViewDataItem. Any thought? Is there a way to save ListViewDataItem in ExerciseBound() so that it can be accessed in ChangeExercise()? Or is there other way to access ListViewDataItem from ListView class directly?
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]....
On behalf of this article : [URL] .....
Lets assume i have four columns
Sr Company Date Billing amount
1 Imtiaz Super Market 11/12/1991 2000
2 Naheed mart 11/12/1991 4000
3 Imtiaz Super Market 11/12/1991 3000
Now it must group by the company name and show running total and net total like :
Sr Company Date Billing amount
1 Imtiaz Super Market 11/12/1991 2000
2 Imtiaz Super Market 11/12/1991 3000 5000
3 Naheed mart 11/12/1991 4000
4 Naheed mart 11/12/1991 5000 9000 14000
NOTE : it must support paging and must be binded with data table
I followed the below code for my project,it's working fine but once row deleted the serial number is not changing i.e..,
suppose,if i have column named as s#
1
2
3
4
Once I removed second row,it has to show
1
2
3
instead of,
1
3
4
[URL] .....
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 RepliesI 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).
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]....
I have a web page and a Tabcontainer in it, and in my tabcontainerthere is a Gridview , in below there is my code that i want if i change one filed to trure, that row become pink,and it works correctly, but now i want to have the number of the page of the last pink row in my Gridview,and keep it in a global variable , and
the next time when i open my web page and come to that Tab, that page of the gridview be appear(the page of the last pink row), not the first page of it.
[Code]....
In a gridview control, what is the property I set to wrap the page numbers at the top and bottom?
View 4 RepliesI need to put the number of the page selected in gridview in evidence at the botton of the page.
How can i get the page number in the botton of Gridview.
I want to create a gridview with checkboxes. (only vb.net)
1) persist checkbox rows in paging in vb.net not c#
2) add the checked rows to datatable datasource and show on next page in paging
1. I want to know that if want to display 100 rows in Ui page so which is best method of display of data Bcz i want to fast the display of data..
2. how to fast the executaion time in stored procedure..
I would like to inquire about the delete the data in gridview with automatic number parameter ..when I edit a field with auto parameter number, how do I delete a field that does not automatically sort ..ex:
1. ROBERT
2. EMILIA
3. JOSE
When I remove the column to 2 EMILIA, then display in gridview 1. ROBERT 3. JOSE.
Coding that I got when I remove emilia then display in gridview 1.ROBERT 2.JOSE .. (sequence automatically)
private void Bindemptydt() {
//Declare a datatable for the gridview
DataTable dt = new DataTable();
//Add Columns to the datatable
dt.Columns.Add("COLUMN");
dt.Columns.Add("TEXT");
[Code] .....
im not sure why but my gridview seems to have stopped working in all areas of Editing, Deleting, Sortinging and i cant click the page number to switch between pages.Ive looked up numerous tutorials and on forums and still cant seem to find a solution that works for me. I have the edit delete sorting and paging check boxes selected.
When i click on any of the links nothing happens. not even a refresh.
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="NumofPosts"
DataSourceID="SqlDataSource1" [code]......