jQuery Grid Plugin - jqGridForum

Topic RSS

Using jqGrid with ASP.NET MVC: A Tutorial

17/04/2009
11:34

Craig Stuntz

Columbus, OH, USA

Member

Members

Forum Posts: 16

Member Since:
16/04/2009

Offline

I'm about halfway through a tutorial on using jqGrid with ASP.NET MVC. I've written three posts in the series so far:

Using jqGrid with ASP.NET MVC: Introduction
Using jqGrid with ASP.NET MVC: LINQ Extensions
Using jqGrid with ASP.NET MVC: Finally, A Solution

Enjoy!

Please feel free to respond with corrections or requests for what you'd like to see in the rest of the series.

20/04/2009
07:18

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello Criag,

Thank you very much for this. It will be included soon in the Integrations page.

Thanks again.

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

27/04/2009
09:54

Craig Stuntz

Columbus, OH, USA

Member

Members

Forum Posts: 16

Member Since:
16/04/2009

Offline

I just added a new article to the series:

Using jqGrid with ASP.NET MVC: Search and Formatting

This update also fixes a bug in paging in the original sample code.

05/05/2009
08:40

Craig Stuntz

Columbus, OH, USA

Member

Members

Forum Posts: 16

Member Since:
16/04/2009

Offline

I've added two new articles to the series:

Using jqGrid with ASP.NET MVC: Deleting Records

Using jqGrid with ASP.NET MVC: Understanding LINQ Errors

09/05/2009
10:30

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Thanks Added.

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

22/05/2009
01:35

sam1980s

Member

Members

Forum Posts: 6

Member Since:
22/05/2009

Offline

Hi,

I checked and found out the solution this artical provides contains method signature as below.

public ActionResult GridData(string sidx, string sord, string search, int page, int rows)

But in the default JQGrid the method signature is only

public ActionResult GridData(string sidx, string sord, int page, int rows)

Can anybody please help me understanding where we need to make changes to pass the search criterias in the ActionResult as method parameters rather then the request objects.

Regards,

Sam

22/05/2009
08:09

Craig Stuntz

Columbus, OH, USA

Member

Members

Forum Posts: 16

Member Since:
16/04/2009

Offline

The search argument in the action method comes from the filterModel.name in the call to jqGrid.filterGrid. Did you read the "search and formatting" article and download the solution there? This is explained in that article, along with why the method I use for search might not be right for every application.

25/05/2009
10:53

sam1980s

Member

Members

Forum Posts: 6

Member Since:
22/05/2009

Offline

Hi Thanks for reply.

I am able to pass parameter to Controller method by defining it with filter model property.

like as below

filterModel: [{
label: 'Search',
name: 'search',
stype: 'text'
},
{
label: 'Search1',
name: 'search1',
stype: 'text'
}

Regards,

Sam

25/05/2009
11:06

sam1980s

Member

Members

Forum Posts: 6

Member Since:
22/05/2009

Offline

I have one more question. which i have already added as a new topic but adding it below as well.

Using Client Side Sorting But Server Side Paging using JQGrid

Hi,

1. Requirement :
In my project most of grids need to have client side sorting . so lets say i have 10 records on client side when i sort only those 10 records will be sorted.
But I need server side paging.

Solution :
I can achieve this by using loadonce : true in jqgrid. And providing some other server side pager control.

Problem :
1. Can I achive client side sorting and server side paging both using JQGrid.

2. When i set the load once to true the paging gets disabled. I wants to provide some kind of jquery paging also. So when i click on next page it will fetch the next say 10 records from the server.

Regards,

Sam

26/05/2009
01:45

sam1980s

Member

Members

Forum Posts: 6

Member Since:
22/05/2009

Offline

I found out the solution to this from the forum and its as below.

http://www.trirand.com/blog/?p.....rid/page-1

20/08/2009
02:06

santosh

Member

Members

Forum Posts: 19

Member Since:
14/08/2009

Offline

Hello there,

I had look at the articles and they really do work great...! I have implemented few of these in my current project...!

As of now i have a question to ask regarding the Advanced Search Operation: Filters...!

I have created a Handler page inorder to create a JSON object but the problem i am currently facing is in creating/constructing a response for the 'whereclause' through the POST method.

_search true

filters    {
   "groupOp":"AND",
                   "rules":
                              [
              {"field":"id","op":"eq","data":"12"},
              {"field":"name","op":"eq","data":"client"},
                                  {"field":"tax","op":"eq","data":"12"},
                                  {"field":"total","op":"gt","data":"100"}
                               ]
              }

Can you post some new article for designing the latest JQGrid3.5 : advanced search method with filters using ASP.NET MVC?

Thanks & Regards,

Santosh

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
74 Guest(s)

Currently Browsing this Page:
1 Guest(s)