Intersoft Solutions - Community - WebGrid Enterprise

Create New

New Discussion
New Question
New Product Feedback

Post Reply

David AvalosMember

Posted: February 27, 2010 11:39 PM

Hello, i have a problem with paging webgrid.

I have a webgrid with classic paging, if i have more than 2 pages and it´s on the first page, when click on next page button, it doesn`t refresh the data of the grid only status bar.

for example

if it has 5 pages and it´s on the first page and i click on the next button, the status bar say "Page 2 of 5" but the data is the same of the first page

Somebody help me please

Quick Reply

Quote

All Replies

Andi SantosoSupport

Posted: March 1, 2010 2:26 AM in response to David Avalos

Hi David,

I am sorry, but I am having a problem to replicate the issue. I have tried to create a simple classic paging using northwind database and when I clicked on next button, the bar and the data is match, it will say Page 2 of 42, and also, the data is changing. Perhaps, you can send me a running simple sample project that will replicate the issue.

Here, I have also attached you my sample using northwind database. I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

1 attachment

ClassicPaging.zip

Quick Reply

Quote

David AvalosMember

Posted: March 1, 2010 11:33 AM in response to Andi Santoso

Ok, i will send you a sample.

Thank you

Quick Reply

Quote

David AvalosMember

Posted: March 1, 2010 3:22 PM in response to Andi Santoso

Hello,

I have a question, if you can help me i will be grafully to you.

When you have this on the webGrid:

And the SelectCommand of the DataSource is "Select * from []"

<asp:AccessDataSource ID="AccessDataSource1" runat="servOrders" DataFile="~/App_Data/Northwind.mdb" SelectCommand="SELECT * FROM [Orders]"> </asp:AccessDataSource>

The selectCommand bring up all the data, or it bring up only 20 rows?

Quick Reply

Quote

Andi SantosoSupport

Posted: March 1, 2010 9:24 PM in response to David Avalos

Hi David,

When you set paging mode to classic paging and paging size to 20, it will load the data per page. For your issue, after further investigation, here is what you might can do. On our property, you can go to Layout Setting - PagingDataRetrievalMode, set them to ReturnPartialRows.

I hope it helps and please, do not hesitate to ask if you have any other questions. Thank you and have a nice day.

Best Regards,

Andi Santoso

Quick Reply

Quote

David AvalosMember

Posted: March 2, 2010 11:59 AM in response to Andi Santoso

Hi Andi,

thank you for your help,

i solved my problem with PagingDataRetrievalMode=ReturnPartialRows.