This is a migrated thread and some comments may be shown as answers.

RadGrid's paging section not refreshing

9 Answers 271 Views

Grid

This is a migrated thread and some comments may be shown as answers.

9 Answers, 1 is accepted

answered on 19 Aug 2010, 04:33 PM

Hi Pavlina

I am using Telerik.Web.UI version 2008.1.415.35 targeting .net 3.5 on Visual Studio 2008.

I have managed to create a simple page with the same problem. My page gets data from a sample Northwind database. What happens is the user selects a category from a drop-down list and clicks a button to show all products which belong to that category in a RadGrid.

The 'beverages' category has 12 products which gets displayed in 2 pages of the radgrid. The 'Meat/Poultry' category has 6 products which you would normally expect to show in one page only. (I am using the default page size of 10)

Here is the tricky part:

User first selects 'beverages', clicks button and grid correctly displays 12 records in 2 pages. After that user selects 'Meat/Poultry' which gets 6 records. Pager incorrectly says 'Displaying page 1 of 2, items 1 to 10 of 12' which I think is remnant of the previous search where user selected 'beverages'. User clicks 'next page' arrow, grid incorrectly shows the same 6 records again and pager incorrectly says 'Displaying page 2 of 2, items 11 to 12 of 12'.

This error does not happen when user chooses 'Meat/Poultry' as a first selection on loading of the page. In this case the pager does not display at all which I think is a correct behavior.

Here is the code:

======================================= Default.aspx ========================

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<!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 runat="server">

<title></title>

</head>

<body>

<form id="form1" runat="server">

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<div>

<asp:DropDownList ID="CategoryList" runat="server"

DataSourceID="CategoryDataSource" DataTextField="CategoryName"

DataValueField="CategoryID">

</asp:DropDownList>

<asp:Button ID="GetProducts" runat="server" Text="Get Products"

onclick="GetProducts_Click" >

</asp:Button>

<telerik:RadGrid ID="ProductGrid" runat="server" AllowPaging="True"

GridLines="None" DataSourceID="ProductDataSource">

<MasterTableView AutoGenerateColumns="False" DataKeyNames="ProductID">

<RowIndicatorColumn Visible="False">

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn Visible="False" Resizable="False">

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn DataField="ProductID" DataType="System.Int32"

HeaderText="ProductID" ReadOnly="True" SortExpression="ProductID"

UniqueName="ProductID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ProductName" HeaderText="ProductName"

SortExpression="ProductName" UniqueName="ProductName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="QuantityPerUnit"

HeaderText="QuantityPerUnit" SortExpression="QuantityPerUnit"

UniqueName="QuantityPerUnit">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="UnitPrice" DataType="System.Decimal"

HeaderText="UnitPrice" SortExpression="UnitPrice"

UniqueName="UnitPrice">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="UnitsInStock" DataType="System.Int16"

HeaderText="UnitsInStock" SortExpression="UnitsInStock"

UniqueName="UnitsInStock">

</telerik:GridBoundColumn>

<telerik:GridCheckBoxColumn DataField="Discontinued" DataType="System.Boolean"

HeaderText="Discontinued" SortExpression="Discontinued"

UniqueName="Discontinued">

</telerik:GridCheckBoxColumn>

</Columns>

<EditFormSettings>

<PopUpSettings ScrollBars="None"></PopUpSettings>

</EditFormSettings>

</MasterTableView>

</telerik:RadGrid>

<asp:SqlDataSource ID="CategoryDataSource" runat="server"

ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"

SelectCommand="SELECT CategoryID, CategoryName FROM Categories ORDER BY CategoryName">

</asp:SqlDataSource>

<asp:SqlDataSource ID="ProductDataSource" runat="server"

ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"

SelectCommand="SELECT ProductID, ProductName, QuantityPerUnit, UnitPrice, UnitsInStock, Discontinued

FROM Products WHERE (CategoryID = @CategoryID) ORDER BY ProductName"

onselecting="ProductDataSource_Selecting">

<SelectParameters>

<asp:ControlParameter ControlID="CategoryList" Name="CategoryID"

PropertyName="SelectedValue" />

</SelectParameters>

</asp:SqlDataSource>

</div>

</form>

</body>

</html>

======================================= Default.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 _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void GetProducts_Click(object sender, EventArgs e)

{

ProductGrid.Rebind();

}

protected void ProductDataSource_Selecting(object sender, SqlDataSourceSelectingEventArgs e)

{

// cancel binding on first load of page

if (!IsPostBack)

e.Cancel = true;

}

answered on 24 Aug 2010, 02:56 PM

website-pagin.zip

Hi Yosief,

Thanks for the sample code. However, we cannot reproduce the behavior you are describing. I took the sample code you provided and put it in a sample page following a similar scenario you have. I am attaching the page for your reference. Please let me know if you manage to reproduce what you are getting in this project, and what steps to follow, so that we can test it too.

All the best,
Pavlina
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

answered on 25 Aug 2010, 01:58 PM

Hi Yosief,

Unfortunately we cannot provide a workaround because it is related to modified server code. In order to have the issue fixed you should upgrade to a later version. However, I believe that an upgrade will be useful for you because there are a lot of improvements, bugfixes, new features and even new controls implemented in the latest release compared to the version you are currently using.
http://www.telerik.com/support/kb/aspnet-ajax/general/updating-radcontrols-for-asp-net-to-another-version-or-license.aspx

Best wishes,
Pavlina
the Telerik team

answered on 16 Jul 2014, 03:15 PM

This is still a problem in the 2014.1.402.20 WinForms version.
If I have a result of 73 pages and have selected page 50 for example,
then reset the grid with a different amount of data with 10 pages for example it shows page 50 of 10 in the Command Bar area?
(Page x of x).
Whenever the next query produces less pages than the previously selected page, the grid does not show data.
It should always force the selection to page 1 of x and refresh those objects.
Side-stepping this bug, is there a way to manually change the page x of 10.
So after the grid is refreshed it would always refresh the page x of 10 to page 1 of 10. Can I change the x to be 1 and have the grid refresh that way appropriately?

answered on 16 Jul 2014, 03:17 PM

currentpagegreaterthantotalpages-before.jpg

currentpagegreaterthantotalpages-after.jpg

Here are the before and after screenshots.

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

RadGrid's paging section not refreshing

9 Answers, 1 is accepted