tony on populate XML data in JQGrid

Thu, 10 Apr 2014 11:01:57 +0300

Hello,

The problem you have is in xmlReader configuration.

You misspeled the word rows instead of row as described into the docs.

So your working code shouild look like this:

xmlReader: { root: "NewDataSet", row: "uom", repeatitems: false }

Regards

ajayporwal on populate XML data in JQGrid

Mon, 07 Apr 2014 16:04:53 +0300

Hi All, I have to bind xml data to JQGrid, but not able to do so. Following is the code in my GridClient.Html file

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="Scripts/jquery-1.11.0.min.js" type="text/javascript"></script>
    <link href="Scripts/jquery-ui-1.10.4.custom.css" rel="stylesheet" type="text/css" />
    <script src="Scripts/jquery.jqGrid.js" type="text/javascript"></script>
    <link href="Scripts/ui.jqgrid.css" rel="stylesheet" type="text/css" />
    <script src="Scripts/grid.locale-en.js" type="text/javascript"></script>
   <script type="text/javascript">
       var xmlstr;
       function RefreshGrid() {
       //just to test if data is coming or not
       xmlstr="<NewDataSet><uom><uom_id>0</uom_id><description>Pieces</description><abbreviation>Pcs.</abbreviation><last_edit_by>sqladmin</last_edit_by><last_edit_at>2014-03-26T15:41:03</last_edit_at></uom></NewDataSet>";

           jQuery("#grdUOM").jqGrid({
               datatype: 'xmlstring',
               datastr: xmlstr,
               colNames: ['Id', 'Description', 'Abbr.', 'Last Edit By', 'Last Edit At'],
               colModel: [
               { name: 'uom_id', index: 'uom_id', width: 20, stype: 'text' },
               { name: 'description', index: 'uom_id', width: 100 },
               { name: 'abbreviation', index: 'abbreviation', width: 80 },
               { name: 'last_edit_by', index: 'last_edit_by', width: 100 },
               { name: 'last_edit_at', index: 'last_edit_at', width: 100}],
               xmlReader: { root: "NewDataSet", rows: "uom", repeatitems: false },
               rowNum: 10,
               sortName: 'uom_id',
               viewRecords: true,

               sortOrder: "desc",
               caption: "List Unit of Measurement"
           });
       }
   </script>
</head>
<body>
<input type="button" id="btn1" value="Refresh Grid" onclick="RefreshGrid();" />
<div id="logdiv"></div>
<div>
<table id="grdUOM">
</table>
    </div>
</body>
</html>

Please help, thank you very much in advance…

jQuery Grid Plugin - jqGrid - Topic: populate XML data in JQGrid

tony on populate XML data in JQGrid

ajayporwal on populate XML data in JQGrid