Converting to JSON For Jquery tables in MVC

Question

I am writing a application in MVC with a existing database. I succesfully connected the DB with EF and through Scaffolding. The tables are displayed in the view.

I wanted Jquery plugin, Datatable for sorting and filtering. But they require the data in JSON format. I looked around and do not find a solid way to convert the values from existing database to JSON.

I see tutorials where WebAPI attributes like DBController and DataService are added and converted to JSON. I cannot able to work it through this way...

SO I was wondering ways of how to convert the values getting in views to JSON..I am sorry if I added lot of unwanted information.

Thanks a lot

VJAI · Accepted Answer · 2012-06-20 04:05:37Z

2

If you want to do the JSON conversion in view then you can follow what @Aleksey answered. You told you are using jquery plugin(jquery table?) so you may need controller actions that will return the data to fill the grid as JSON? In this cases you can have actions in controller that returns Json action result and you don't need to do any conversion by directly using JavaScript serializer (this will be done by the framework for you).

For ex.

public JsonResult GetDataToFillGrid(parameters)
{
  var dataCollection = .. get from db

  return Json(dataCollection, JsonRequestBehavior.AllowGet);
}

JsonRequestBehavior.AllowGet you have to use for GET requests.

answered Jun 20, 2012 at 4:05

VJAI

32.9k23 gold badges108 silver badges166 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ajax3.14 Over a year ago

public ActionResult Index() { return new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = db.someData, ContentType = "text/html", }; } //Thanks ...This is how I got it working...So return type ActionResult vs JsonResult which is better? both is working though

VJAI Over a year ago

You can use both but I would suggest use JsonResult. Avoid returning the generic ActionResult as much as possible and return the concrete types like ViewResult, JsonResult and such.

Aleksey Cherenkov · Accepted Answer · 2012-06-19 17:32:22Z

2

var jsonData = @Html.Raw(new JavaScriptSerializer().Serialize(Model));

Here is MSDN documentation for JavaScriptSerializer Class.

answered Jun 19, 2012 at 17:32

Aleksey Cherenkov

1,49523 silver badges27 bronze badges

1 Comment

Ajax3.14 Over a year ago

I will go through the doc and try this..Thanks a lot

Bishnu Paudel · Accepted Answer · 2012-06-20 04:38:03Z

0

Your Jquery DataTable sits in View and we should always avoid processing of data inside view. View should only display the data that is passed from the Controller.

Having said this, you should create a method in the controller which returns the result as Json object as Mark suggested.

answered Jun 20, 2012 at 4:38

Bishnu Paudel

2,0891 gold badge22 silver badges39 bronze badges

1 Comment

Ajax3.14 Over a year ago

May be I am not clear in my question.But I actually wanted to know how to convert the data to JSON in controller...I got it working now...using JsonResult in controller.

Collectives™ on Stack Overflow

Converting to JSON For Jquery tables in MVC

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related