Discussion :

[kendras]

Bonjour,

je souhaiterai charger mon grid à partir d'un fichier que je génère à la volée

Voici mon code javascript :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
$(document).ready(function() {
 
    $("#grid").jqGrid({
        datatype: "json",
        url: "/datasource/Test.txt",
	    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"
    });
 
});

Et voici mon fichier

{
"page": "1",
"total": "1",
"records": "9",
"rows": [
{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"}]
}

Cependant, rien y fait, mes lignes de données ne s'affiche pas...
Mon fichier json serait-il incorrect ?

[danielhagnoul]

Bonsoir.

Mon fichier json serait-il incorrect ?

Oui, car jQuery 1.4.2 est très exigeant sur la validité du format JSON. Voir : http://api.jquery.com/jQuery.getJSON/