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

In this function I have:

            JQGrid1.DataSource = dt;

            JQGrid1.DataBind();

dt = DataTable with 9 rows

OK. I found my error. Function GetRowCount returns 7 not 9 🙂

Now it works:)

Thanks anyone:)

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.

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 you can find and download an example of ASP.NET code which works with jqGrid without any problems. 

Best regards
Oleg 

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.

How do you read the database?

Do you use JSON or XML,

Do you have configured the readers correct.

No answer will be,  if your description is not approved with a test case.

Regards

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