<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: Binding JSON to jqGrid</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/binding-json-to-jqgrid</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/help/binding-json-to-jqgrid/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>tony on Binding JSON to jqGrid</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/binding-json-to-jqgrid#p30362</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/binding-json-to-jqgrid#p30362</guid>
        	        	<description><![CDATA[<p>Hello,</p>
</p>
<p>You will need to configure the jsonReader.</p>
<p>Please <a href="http://stackoverflow.com/questions/11277018/jqgrid-with-web-service-is-not-working-in-jsonreader-format" target="_blank">look here</a></p>
</p>
<p>Regards</p>
]]></description>
        	        	<pubDate>Sun, 16 Mar 2014 12:04:08 +0200</pubDate>
        </item>
        <item>
        	<title>shah.abhilash on Binding JSON to jqGrid</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/binding-json-to-jqgrid#p30361</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/binding-json-to-jqgrid#p30361</guid>
        	        	<description><![CDATA[<p>Can anyone please help/guide where i am going wrong in binding JSON to JQGrid?</p>
<p>Regards,<br />Abhilash&#160;</p>
]]></description>
        	        	<pubDate>Sun, 16 Mar 2014 11:34:42 +0200</pubDate>
        </item>
        <item>
        	<title>shah.abhilash on Binding JSON to jqGrid</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/binding-json-to-jqgrid#p30360</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/binding-json-to-jqgrid#p30360</guid>
        	        	<description><![CDATA[<p>Hi All,</p>
<p>I am pretty new to jqGrid. Could someone guide me where i am going wrong in binding JSON to jqGrid?</p>
<p>Please note &#8211; i dont any control over web service so cannot modify json sent from web service.</p>
<p>Your help will be greatly appreciated.</p>
<p><strong>JSON format:</strong></p>
<p>[{"DepositType":0,"DepositId":0,"ReceiptNumber":"","CompanyId":2," Company":"Cosmos cooperative ","EmployeeId":1," EmployeeName ":"Abhilash Shah","MaturityDate":"2012-08-11T00:00:00","MaturityAmount":23311.0,"DateInvested":"2011-03-05T00:00:00","AmountInvested":20000.0,"ROI":10.25,"Term":16,","IsWithdrawn":false,"Purpose":"","Comments":""},{"DepositType":1,"DepositId":0,"ReceiptNumber":"9993","CompanyId":1,"Company":" Janta Sahakari Ltd","EmployeeId":3,"EmployeeName":"Sheela Shah","MaturityDate":"2013-06-11T00:00:00","MaturityAmount":253644.0,"DateInvested":"2012-06-11T00:00:00","AmountInvested":0.0,"ROI":0.0,"Term":12," ","IsWithdrawn":false,"Purpose":"","Comments":""},{"DepositType":0,"DepositId":0,"ReceiptNumber":"","CompanyId":1,"Company":"Solapur Janta Sahakari &#160;Ltd","EmployeeId":3,"EmployeeName":"Sheela Shah","MaturityDate":"2013-08-30T00:00:00","MaturityAmount":125161.0,"DateInvested":"2011-05-30T00:00:00","AmountInvested":100000.0,"ROI":10.1,"Term":27, "IsWithdrawn":false,"Purpose":"","Comments":""},{"DepositType":0,"DepositId":0,"ReceiptNumber":"226575","CompanyId":6,"Company":" of Maharashtra","EmployeeId":3,"EmployeeName":"Sheela Shah","MaturityDate":"2013-10-05T00:00:00","MaturityAmount":100000.0,"DateInvested":"2012-10-05T00:00:00","AmountInvested":100000.0,"ROI":10.05,"Term":12, "IsWithdrawn":false,"Purpose":"","Comments":""}]</p>
</p>
<p><strong>Below is the code snippet, simplified grid to contain only one column:</strong></p>
</p>
<p>&#60;script type="text/javascript"&#62;</p>
<p>&#160;&#160;&#160;&#160;&#160; &#160;&#160;jQuery(document).ready(function () {</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; jQuery("#depositGrid").jqGrid({</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; url: &#39;<a rel="nofollow" href="http://localhost:50570/api/common/GetElapsedDeposits&#38;#39" target="_blank"></a><a href="http://localhost:50570/api/com&#038;hellip" rel="nofollow" target="_blank">http://localhost:50570/api/com&#038;hellip</a>;..s&#38;#39;,</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; datatype: &#39;json&#39;,</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; type: "POST",</p>
</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &#160;&#160;colNames: [&#39;Employee Name&#39;],</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; colModel: [</p>
<p>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; { name: &#39;EmployeeName&#39;, index: &#39; EmployeeName &#39;, align: "center", sortable: true }</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; ],</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; pager: jQuery(&#39;#pager&#39;),</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; rowNum: 10,</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; rowList: [10, 20, 30],</p>
<p>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; viewrecords: true,</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; imgpath: &#39;themes/basic/images&#39;,</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; caption: &#39;Company deposits&#39;</p>
</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; });</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; jQuery("#depositGrid").navGrid(&#39;#Pager&#39;, {</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; edit: true, add: true, del: true, search: true</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; }).navButtonAdd(&#39;#Pager&#39;, {</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; caption: "Add", buttonimg: "fullpath/row_add.gif", onClickButton: function () { alert("Adding Row") }, position: "last"</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; }).navButtonAdd(&#39;#Pager&#39;, {</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; caption: "Del", buttonimg: "fullpath/row_del.gif", onClickButton: function (id) { alert("Deleting Row: " + id) }, position: "last"</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; });</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160; });</p>
<p>&#160;&#160;&#160; &#60;/script&#62;</p>
<p>&#160;&#160;&#160; &#60;div id="jqgrid"&#62;</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160; &#60;table id="depositGrid"&#62;&#60;/table&#62;</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160;&#160; &#60;div id="Pager"&#62;&#60;/div&#62;</p>
<p>&#160;&#160;&#160; &#60;/div&#62;</p>
</p>
<p>Regards,</p>
<p>Abhilash</p>
]]></description>
        	        	<pubDate>Sat, 15 Mar 2014 14:22:42 +0200</pubDate>
        </item>
</channel>
</rss>