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]....
Altough questions somehow similar to this have been asked for a number of times, but the question is still unsolved. Here is the question: I have a gridview which is contained in a tab container ajax control which itself is inside an updatepanel. Gridview works excellent and its corresponding methods are fired accurately, but when I enable paging, (e.g.) after I click on page 2, the gridview hides itself. here is my PageIndexChanging method:
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
UpdatePanel2.Update();
}
Why paging causes gridview to stop working correctly? What can I do?
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 used objectdatasource with Gridview.
I have total 3000 records in DB.
In gridview settings:
AllowPaging="True",
PageSize="1000"
but on click on page number in the footer the page is changing but data is not refreshing.
is there away to paging in gridview without client click?
View 7 RepliesI have a gridview connected to my objectdatasource, i wrote a class for the database queries.Now when i do an update of record i get the id form the grid, when i click on delete i don't get the id, its 0.Is there an option to set the id? i can't find it in the gridview.
View 9 RepliesCan't tell what is wrong here . It worked fine and I didn't did anything special in code-behind
I don't see any error just the same data in gridview
[Code]....
In my master page, I defined the css which loads a background image: img_mnusep.gif
<style type="text/css">
.ListHead2
{
background-color: #E0E3E8;
height: 20px;
color: #000000;
font-family: Tahoma, Arial, Verdana, Tahoma, Arial;
font-size: 8.5pt;
font-weight: normal;
[Code].....
Im using File Upload Control in every row of a GridView.... Like tis
Name
UploadFile
textBox FileUpload
TextBox FileUpload
.
.
Submit
On Submit im first uploading all files present in the grid and then saving other values in database....No Problem when uploading Small Set of filesIf i browse more than 10(approx) files(i.e 10 files in 10 rows) and Submit... Internet Explorer-Page Cannot Be displayed Error occurs but no problem when uploading < 10(approx) files....
I am tring to set the selected value of a dropdown inside a gridview like this:
[Code]....
And I get error:
[Code]....
I have a gridview that shows when something is check out. I would like to only show results from todays date and forward. I have done this in Expression Web but when I tried to use the same code in Visual Studios it doesn't work.
asp:AccessDataSource
ID="AccessDataSource1"
runat="server"
DataFile="~/browser.mdb"
DeleteCommand="DELETE FROM [ConferenceRoomCalendar] WHERE [ID] = ?"
InsertCommand="INSERT INTO [ConferenceRoomCalendar] ([ID], [ConferenceRoomName], [DateNeeded], [StartTime], [FinishTime], [RequestedBy], [Purpose]) VALUES
(?, ?, ?, ?, ?, ?, ?)" SelectCommand="SELECT * FROM [ConferenceRoomCalendar] WHERE ([DateNeeded] >= Date())"
UpdateCommand="UPDATE [ConferenceRoomCalendar] SET [ConferenceRoomName] = ?, [DateNeeded] = ?, [StartTime] = ?, [FinishTime] = ?, [RequestedBy] = ?, [Purpose]
= ? WHERE [ID] = ?">
<SelectParameters>
<asp:QueryStringParameter
Name="DateNeeded"
QueryStringField="Date()"
Type="DateTime"
/>
</SelectParameters>
<DeleteParameters>
<asp:Parameter
Name="ID"
Type="Int32"
/>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter
Name="ConferenceRoomName"
Type="String"
/>
<asp:Parameter
Name="DateNeeded"
Type="DateTime"
/>
<asp:Parameter
Name="StartTime"
Type="DateTime"
/>
<asp:Parameter
Name="FinishTime"
Type="DateTime"
/>
<asp:Parameter
Name="RequestedBy"
Type="String"
/>
<asp:Parameter
Name="Purpose"
Type="String"
/>
<asp:Parameter
Name="ID"
Type="Int32"
/>
</UpdateParameters>
<InsertParameters>
<asp:Parameter
Name="ID"
Type="Int32"
/>
<asp:Parameter
Name="ConferenceRoomName"
Type="String"
/>
<asp:Parameter
Name="DateNeeded"
Type="DateTime"
/>
<asp:Parameter
Name="StartTime"
Type="DateTime"
/>
<asp:Parameter
Name="FinishTime"
Type="DateTime"
/>
<asp:Parameter
Name="RequestedBy"
Type="String"
/>
<asp:Parameter
Name="Purpose"
Type="String"
/>
</InsertParameters>
</asp:AccessDataSource>
In expression web I changed this line from this WHERE [ID] = ?"> to this WHERE [ID] = date()"> and I get the right results.
I have a GridView; one of the columns displays concatenated records from a tables. to extract the records that are going to be concatenated and put in this column, i have used: FOR XML path('') and it works just fine for displaying those records. the problem now is the whole gridview can not be sorted anymore and gives me a 404, document not found, error whenever i try to click the columns to sort. here is my select statement for my sql datasource select command:
SqlDataSource2.SelectCommand = "Select a1.*, keyword = substring( ( SELECT DISTINCT ', ' + keywordName FROM keywords JOIN key_mm_articles ON key_mm_articles.keywordID = keywords.keywordID WHERE key_mm_articles.articleID = a1.articleID FOR XML path(''), elements ),2,500) FROM articles a1 WHERE title LIKE '" & titles & "' Order By a1.articleID"
Here's my GridView control:
[Code]....
And here's my FormView control:
[Code]....
The problem is, when I click on the GridView item, the formView control does not show the detail.
I tried to keep all the data in the gridview when paging, but when I try to save it, which appears in my database only when it is active pages .. ex: in the first and second page I have data in gridview .. when I save, the stored in the database only the first or second page of course .. so I like to keep all my data in gridview when paging..
 i have tried using :  foreach (GridViewRow row in GridCustomColumn.Rows) but it's not working..
string sql1;
foreach (GridViewRow row in GridCustomColumn.Rows)
{
[Code].....
So I followed Scot Mitchell's tutorial from asp.net/learn on adding a checkbox column to be able to select multiple entries and delete them with the click of a button. When I make my selection and click the button it works on the database end, as the desired entries are deleted. However, the entries remain on the page after it reloads. if I refresh the page it's updated properly but I'd like it to automatically update after the button is clicked.
Also, I tried his method for adding check/uncheck all buttons to the top of the gridview and they don't seem to be working either.
Here's the code behinf from the gridview page:
[Code]....
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]....
URL...but I noticed that if move the bind from page load directly to button the code doesnt works?
<%@ Page Language="vb" AutoEventWireup="true" CodeBehind="WebForm1.aspx.vb" Inherits="_100yWeb.WebForm1" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<script src="Script/jquery-1.4.1.min.js" type="text/javascript"></script>
[code]...
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 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.
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).
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 >
to explain my problem as simple as i can i have made the following page each textbox is a required field. when i enter valid data in the text box and click the button everything is fine. the problem i am having is that after this button click > i empty out the last 2 textboxes > click the button > the required field validation is not thrown.
the autopostback property being set to true is a must in this case.
[Code]....
I am trying to get paging to work on a DataList bound to a DataSet, using SQL stored procedures, with and without parameters, and without using querystrings.
I allow visitors of the page to filter the DataList by either selecting a value from various dropdowns e.g to see products of a certain supplier on the page or by clicking hyperlinks e.g to show all products.
The problem is paging isn't working at all. The next and previous buttons are not changing the page. However, I am not getting any error messages.
Here's my code. Note I have excluded all my dropdown methods that simply call getData and pass relevant parameters. However the default dataset view should still work.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
[Code]....
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