Guriddo » Topic: JqGrid – shows less than it should

JqGrid – shows less than it should

Guriddo
JqGrid – shows less than it should

This topic has 6 replies, 3 voices, and was last updated 13 years, 4 months ago by kat15pl.

Creator

Topic
January 31, 2013 at 12:00 pm #80681

kat15pl
Participant

Hi,

I'm reading from database about 10 rows, but JQGrid displays me only 7 (I have 1 page, and I have “View 1 – 7 of 7”). I can search by missing rows, or sorting but it always display 7 rows:( . In other place of site it is ok (it displays about 40 rows, which is properly)

Any suggestion?

BTW. Sorry 4 my english
Creator

Topic

Viewing 6 replies - 1 through 6 (of 6 total)

Author

Replies
January 31, 2013 at 10:20 pm #100673

tony
Keymaster

Hello,

How do you read the database?

Do you use JSON or XML,

Do you have configured the readers correct.

No answer will be,

February 1, 2013 at 11:36 am #100679

kat15pl
Participant

Hi,

Thanks for replying.

Firstly I think I must say that I'm writing in asp.net.

I read DB directly from SQL (using SqlConnection). The same method in other part of my system works perfectly. Only in this part it shows only 7, not 10 (it read from DB 10 rows, which I'm sure because I debug my site). I can search by “hidden” rows, but always display 7.

BTW. Maximum row page is set to 25.

February 1, 2013 at 11:50 am #100681

OlegK
Participant

Hi,

jqGrid is pure JavaScript solution. So what you can do is to use Fiddler, Firebug, Developer Tools of IE or Chrome or any other tool to catch the exact JSON response of the server. If you save the JSON response in the file with the name like “test.json” you can use url: “test.json” to reproduce the problem without you server environment. You should just provide the HTML page with the JavaScript code which you use. If you see that the problem is do on the server side then you need debug it yourself because it has no relation with jqGrid.

By the way Fiddler works as HTTP proxy. So using Fiddler one can catch any HTTP trafic in any environmat with any servers and then having the traces one can use Fiddler in autoresponse mode. So the fiddler will answer on the requests with the previously saved responses without having the server environment.

In the answer

February 1, 2013 at 11:59 am #100682

kat15pl
Participant

Thanks for reply,

Ok, my english is bad:)

I don't use json, I get rows by (C# code):

DataTable dt = module.Search(pageSize, startIndex, orderByColumn, searchExpression);

This function makes query string and return rows.

Like I said the same schema works in other part of site. I thought it could be by polish letters, but when I deleted them it doesn't improve.

February 1, 2013 at 12:09 pm #100683

OlegK
Participant

I am sure that your server returns either JSON or XML because it's only two formats which supports jqGrid. Which value has datatype parameter of jqGrid which you use? If you don't specify any datatype

February 1, 2013 at 12:28 pm #100685

kat15pl
Participant

Ok, I see that I get 7 rows in response.

In JQGrid1_DataRequesting(object sender, Trirand.Web.UI.WebControls.JQGridDataRequestEventArgs e) function in debug mode I get 9 rows.

In this function I have:
Author

Replies