How to get the JSON from the controller to display in the view of ASP.net MVC 2

Question

I am trying to query data from a database, in order to take it to create the main menu in my ASP.NET MVC 2 web site.

This is the code in my controller :

public JsonResult GetMenu(string id)
{
  JsonResult jr  = new JsonResult();
  var ien_menu = (    
      from d in this.DataContext.Departments                                                    
      join c in this.DataContext.Categories                                  
      on d.ID equals c.DepartmentID   
      join i in this.DataContext.Items on 
      c.ID equals i.CategoryID
      where d.Active == 1
         && d.ActiveInWeb >0
         && c.Active > 0
         && c.ActiveInWeb >0
         && i.Active > 0
      select d
    ).Distinct()
     .OrderBy(s=>s.Name);
  jr.Data = ien_menu.ToList();
  jr.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
  return jr;
}

But I really have no idea how to take this data and display it in my partial views. What do I need to do?

Sachin · Accepted Answer · 2012-03-09 10:04:07Z

1

How are you calling this controller action? You can use jQuery to get the Json results if you are loading via ajax. Look at the success function to get the data - http://api.jquery.com/jQuery.ajax/

answered Mar 9, 2012 at 10:04

Sachin

3432 silver badges8 bronze badges

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

5 Comments

titi Over a year ago

Thanks for your answer. I'm not yet know that, how can I call this controller, and anyway I never know and try to get data by Jquery or Json.

Sachin Over a year ago

in document.ready or whenever you want to load the menu json data, make a ajax call using jQuery. Assuming that your controller action's Url is example.com/foo/getmenu, then in javascript you could do something like $.ajax({url:http://example.com/foo/getmune,success:function(data){//this is where you can parse the json in data object}

titi Over a year ago

Ok, thanks. But could you please tell me, how could I loop a collection of jr that I have return from my controller? by using ` $.getJSON(url, { id: t }, function (data) { $.each(data, function (index, dataOption) { }); }); ` ?

Sachin Over a year ago

yes, you have to use $.each for iterating through items in the json.

titi Over a year ago

But how can I create the link like

<%: Html.ActionLink(b.Name, Model.ActionName, Model.ControllerName, new { dep = strDepLisintCon, cat = b.ID, tab = Model.Tab }, new { @class = "selectedsubcat" })%>

in that script?

Collectives™ on Stack Overflow

How to get the JSON from the controller to display in the view of ASP.net MVC 2

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related