How can I update two jqGrid from the same asp.net-mvc controller action?

I have 2 jqGrid tables and I want to update them from the same asp.net-mvc controller action. Now I am doing this separately, but this is a waste, since the source data source for both tables is the same, so I run the same backend query twice. Ideally, I would like to trigger the mvc controller action once, and then return 2 different datasets back to the client.

Is this possible with jqGrid and asp.net-mvc?

+3
source share
2 answers

datatype: "json" loadonce: true ( " " ) datatype: "local". : ( ) , . root jsonReader . beforeProcessing , data . beforeProcessing Ajax . loadComplete, , . "" , datatype "json", "reloadGrid" . navGrid ( "" ) beforeRefresh, reset datatype - "json". , .

, . URL- - loadonce: true. , / jqGrid. , , .

+2

JSON , , . http://trirand.com/blog/jqgrid/jqgrid.html .

: , , , .

jQuery("#list4").jqGrid({
        datatype: "local",
        height: 250,
        colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],
        colModel:[
            {name:'id',index:'id', width:60, sorttype:"int"},
            {name:'invdate',index:'invdate', width:90, sorttype:"date"},
            {name:'name',index:'name', width:100},
            {name:'amount',index:'amount', width:80, align:"right",sorttype:"float"},
            {name:'tax',index:'tax', width:80, align:"right",sorttype:"float"},     
            {name:'total',index:'total', width:80,align:"right",sorttype:"float"},      
            {name:'note',index:'note', width:150, sortable:false}       
        ],
        multiselect: true,
        caption: "Manipulating Array Data"
    });
    var mydata = [
            {id:"1",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
            {id:"2",invdate:"2007-10-02",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
            {id:"3",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
            {id:"4",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
            {id:"5",invdate:"2007-10-05",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
            {id:"6",invdate:"2007-09-06",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"},
            {id:"7",invdate:"2007-10-04",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
            {id:"8",invdate:"2007-10-03",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
            {id:"9",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"}
            ];
    for(var i=0;i<=mydata.length;i++)
        jQuery("#list4").jqGrid('addRowData',i+1,mydata[i]);
0

All Articles