Bind jqgrid with entity framework via a controller using Json

Question

0.00/5 (No votes)

See more:

Please give me the solution for Binding jqgrid with entity framework via controller using json and also need jqgrid template

Thank you...

Posted 22-Apr-14 18:15pm

Member 10629036

Add a Solution

Comments

Sunasara Imdadhusen 23-Apr-14 0:43am

Have tried to search on google?

Member 10629036 23-Apr-14 0:48am

I am tried already in google but i did'nt get proper solution please give me the solution for this

3 solutions

Solution 1

well in controller write your logic to get the required data and then you can use json.Net library to convert your data to json serialize object and pass it to your view.

this is just a direction that i am providing, you can do some more research on json.net framework. you can install json.net from nuget package in the visual studio.

hope this will helpful.

Posted 22-Apr-14 19:48pm

ravikhoda

v2

Comments

Member 10629036 23-Apr-14 4:55am

Thank you....

Solution 3

Hi..

You can refer my article.

http://www.codeproject.com/Articles/801895/Asp-Net-MVC-Entity-Framework-and-JQGrid-Demo-wit

this will be good for beginner with a simple demo application using MVC, Entity framework and jqgrid.

Posted 30-Jul-14 20:41pm

Dileep Ashok

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Antariksh Verma · Accepted Answer · 2014-04-22T20:23:00

Hi,

You can refer below code in order to resolve the issue that you faced.
This is the template for jq Grid which is written in view

VB

@(Html.Grid("GridName")
 .SetRequestType(MvcJqGrid.Enums.RequestType.Post)
 .SetJsonReader(new MvcJqGrid.DataReaders.JsonReader { Id = "WId" })
 .SetCaption("View Report")

      .AddColumn(new Column("Name").SetWidth(100).SetLabel(" Name").SetSearchType(MvcJqGrid.Enums.Searchtype.Text))
.AddColumn(new Column("Description").SetWidth(100).SetLabel("Description").SetSearchType(MvcJqGrid.Enums.Searchtype.Text))
.AddColumn(new Column("Status").SetWidth(100).SetLabel("Status").SetSearchType(MvcJqGrid.Enums.Searchtype.Text))
     .AddColumn(new Column("Resource").SetWidth(100).SetLabel("Resource").SetSearchType(MvcJqGrid.Enums.Searchtype.Text))

    .SetUrl(Url.Action("ViewName", "ControllerName"))
    .SetAutoWidth(true)
    .SetRowNum(10)
    .SetSortName("WId")
    .SetViewRecords(true)
    .SetPager("pager")
    .SetLoadOnce(true)//for client side sorting and paging enabled
           
  .SetSearchToolbar(true)
  .SetAutoWidth(true)
  .SetSearchClearButton(true)
  .SetSearchToolbar(true)
  .SetSearchOnEnter(false)
  .SetScroll(false)
  .SetPgButtons(true)
  .SetSearchClearButton(true)
  .SetSearchToggleButton(true)
  )

You can use it in controller like below:-

C#

public JsonResult ViewName(GridSettings gridSettings)
       {
           int totalRecords;
           SREntities db = new SREntities();
           totalRecords = db.VW_GetData.Count();
           var jsonData = new
           {
               total = totalRecords / gridSettings.PageSize + 1,
               page = gridSettings.PageIndex,
               records = totalRecords,
               rows = db.VW_GetData.ToList()

           };

           return Json(jsonData, JsonRequestBehavior.AllowGet);
       }

You have to add reference of a DLL for JQGrid "MvcJqGrid.dll " and also add jquery file in _Layout.cshtml

XML

<script src="@Url.Content("~/Scripts/i18n/grid.locale-en.js")" type="text/javascript"></script>
   <script src="@Url.Content("~/Scripts/jquery.jqGrid.min.js")" type="text/javascript"></script>

Refer this link for furthur help:
mvcjqgrid.skaele.it/

Thats all done !!