Databases
StackOverflow2013
Postsdbo
POHow can I bind my view model to a jqGrid?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow can I bind my view model to a jqGrid?
    primarykey
    data
    text
    <p>Using MVC2 and EF framework. Most references/blog posts I've found so far pertain to binding a single table and its data (sometimes hierarchical) to a jqGrid with editing capabilities. I don't need this. I don't even need to edit the data--just display. I need to display and page the data. Sorting is a plus, searching a bonus I guess.</p> <p>jqGrid's documentation shows the data source being bound as follows:</p> <pre><code>return gridModel.OrdersGrid.DataBind(northWindModel.Orders); </code></pre> <p>But, I only have my Entities context without a reference to the view model. Could I create an Entity set here? Not very familiar with this.</p> <p>All my view models contain data from several different tables. What can I do to bind the view model properties to a jqGrid? I'm playing with <a href="http://www.trirand.net/default.aspx">Trirand</a>'s 30-day trial of jqGrid for MVC. Again, I just need to <em>display and page</em> the data, but I'm not sure how to hook up the view models to the jqGrid data source.</p> <h2>Edit</h2> <pre><code>public ActionResult test() { var gridModel = new testmodel(); var viewModel = gridModel.testgrid; SetupTestGrid(viewModel); return View(gridModel); } private void SetupTestGrid(JQGrid viewModel) { viewModel.ID = "TestGrid"; viewModel.DataUrl = Url.Action("SearchTestGridDataRequested"); viewModel.ToolBarSettings.ShowEditButton = false; viewModel.ToolBarSettings.ShowAddButton = false; viewModel.ToolBarSettings.ShowDeleteButton = false; } public JsonResult SearchTestGridDataRequested(string sidx, string sord, int page, int rows) { var gridModel = new testmodel(sidx, sord, page, rows); SetupTestGrid(gridModel.testgrid); return Json(gridModel.datasource); } </code></pre> <p>In testmodel and testmodel(parameters), I create an anonymous type (named datasource) containing <a href="http://haacked.com/archive/2009/04/14/using-jquery-grid-with-asp.net-mvc.aspx">Phil Haack's</a> parameters; total, page, records and rows. This property is JSON'ified in the last statement of SearchTestGridDataRequested.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDavid Fox
    1. USDavid Fox
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow can I bind my view model to a jqGrid?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow can I bind my view model to a jqGrid?
      1. USawrigley
      1. VTFavorite
    3. VO
      singulars
      1. POHow can I bind my view model to a jqGrid?
      1. UStecnocrata
      1. VTFavorite
    1. COPost your controller code?
      singulars
      1. POHow can I bind my view model to a jqGrid?
      1. USjfar
    2. COMy answer is a little to long for reading. Look in http://stackoverflow.com/questions/4078592/sortable-jqgrid-using-linq-to-mysql-dblinq-and-dynamic-linq-orderby-doesnt-w/4079121#4079121 which probably will give the answer on your main question.
      singulars
      1. POHow can I bind my view model to a jqGrid?
      1. USOleg
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload