<?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: jqGrid with ASP.NET Web API ?</title>
	<link>http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-with-asp-net-web-api</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/discussion/jqgrid-with-asp-net-web-api/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>markmao_love on jqGrid with ASP.NET Web API ?</title>
        	<link>http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-with-asp-net-web-api#p28639</link>
        	<category>Discussion</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-with-asp-net-web-api#p28639</guid>
        	        	<description><![CDATA[<p>Hello!</p>
<p>&#160; &#160; JQuery jqGrid with ASP.NET API ?<img class="spSmiley" style="margin:0" title="Cry" src="/blog/wp-content/forum-smileys/sf-cry.gif" alt="Cry" /><img class="spSmiley" style="margin:0" title="Cry" src="/blog/wp-content/forum-smileys/sf-cry.gif" alt="Cry" /><img class="spSmiley" style="margin:0" title="Cry" src="/blog/wp-content/forum-smileys/sf-cry.gif" alt="Cry" /><img class="spSmiley" style="margin:0" title="Cry" src="/blog/wp-content/forum-smileys/sf-cry.gif" alt="Cry" /><img class="spSmiley" style="margin:0" title="Cry" src="/blog/wp-content/forum-smileys/sf-cry.gif" alt="Cry" /></p>
</p>
<p>&#160; &#160;ASP.NET API&#160;GET result JSON Data</p>
<p>&#160; URLPath =&#39;<a href="http://192.168.101.52:8086/api/APPFREQSTAT_CN?PageSize=10&#038;PageIndex=2&#038;RowFilterRegisterId=2" rel="nofollow" target="_blank"><a href="http://192.168.101.52:8086/api" rel="nofollow">http://192.168.101.52:8086/api</a>.....gisterId=2</a>;..gisterId=2&#39;</p>
<p>&#160; Get result JSON Data:</p>
<pre>{"PageSize":10,"PageIndex":2,"RecordCount":54,"PageCount":6,</pre>
<pre>"RowsData":[</pre>
<pre>{"AppCode":"DYHSQ000043","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",</pre>
<pre>"ISAffirm_FLAG":"0","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000052",</pre>
<pre>"BusinessCategoryName":"(1) å¯¹è®²æœº","DevCount":0.0,"SampleStatCount":0.0,</pre>
<pre>"BespokeFlagName":0.0,"CheckStatCount":null},</pre>
<pre>{"AppCode":"DYHSQ000044","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",</pre>
<pre>"ISAffirm_FLAG":"0","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000051",</pre>
<pre>"BusinessCategoryName":"(1) å¯¹è®²æœº","DevCount":15.0,"SampleStatCount":12.0,</pre>
<pre>"BespokeFlagName":0.0,"CheckStatCount":"é€šè¿‡:15å°"},{"AppCode":"DYHSQ000045",</pre>
<pre>"Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0","ISAffirm_FLAG":"0",</pre>
<pre>"ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000050",</pre>
<pre>"BusinessCategoryName":"(1) å¯¹è®²æœº","DevCount":50.0,"SampleStatCount":15.0,</pre>
<pre>"BespokeFlagName":0.0,"CheckStatCount":"é€šè¿‡:50å°"},</pre>
<pre>{"AppCode":"DYHSQ000046","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",</pre>
<pre>"ISAffirm_FLAG":"0","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000049",</pre>
<pre>"BusinessCategoryName":"(1) å¯¹è®²æœº","DevCount":0.0,"SampleStatCount":0.0,</pre>
<pre>"BespokeFlagName":0.0,"CheckStatCount":null},{"AppCode":"DYHSQ000047","Ver":1.0,</pre>
<pre>"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0","ISAffirm_FLAG":"0","ApproveFlag":"1",</pre>
<pre>"LicenseFlag":"1","LicenceNO":"DYHXK000048","BusinessCategoryName":"(1) å¯¹è®²æœº",</pre>
<pre>"DevCount":0.0,"SampleStatCount":0.0,"BespokeFlagName":0.0,"CheckStatCount":null},</pre>
<pre>{"AppCode":"DYHSQ000048","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",</pre>
<pre>"ISAffirm_FLAG":"0","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000046",</pre>
<pre>"BusinessCategoryName":"(1) å¯¹è®²æœº","DevCount":0.0,"SampleStatCount":0.0,</pre>
<pre>"BespokeFlagName":0.0,"CheckStatCount":null},{"AppCode":"DYHSQ000049","Ver":1.0,</pre>
<pre>"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0","ISAffirm_FLAG":"0","ApproveFlag":"1",</pre>
<pre>"LicenseFlag":"1","LicenceNO":"DYHXK000045","BusinessCategoryName":"(1) å¯¹è®²æœº",</pre>
<pre>"DevCount":0.0,"SampleStatCount":0.0,"BespokeFlagName":0.0,"CheckStatCount":null},</pre>
<pre>{"AppCode":"DYHSQ000050","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",</pre>
<pre>"ISAffirm_FLAG":"1","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000044",</pre>
<pre>"BusinessCategoryName":"(1) å¯¹è®²æœº","DevCount":28.0,"SampleStatCount":14.0,</pre>
<pre>"BespokeFlagName":0.0,"CheckStatCount":"æœªæ£€æµ‹:28å°"},</pre>
<pre>{"AppCode":"DYHSQ000051","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",</pre>
<pre>"ISAffirm_FLAG":"0","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000043",</pre>
<pre>"BusinessCategoryName":"(1) å¯¹è®²æœº","DevCount":900.0,"SampleStatCount":19.0,</pre>
<pre>"BespokeFlagName":0.0,"CheckStatCount":"é€šè¿‡:900å°"},{"AppCode":"DYHSQ000052",</pre>
<pre>"Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0","ISAffirm_FLAG":"0",</pre>
<pre>"ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000042","BusinessCategoryName":"(1) å¯¹è®²æœº",</pre>
<pre>"DevCount":0.0,"SampleStatCount":0.0,"BespokeFlagName":0.0,"CheckStatCount":null}]}</pre>
<pre>//</pre>
<pre>&#160;grGrid with API</pre>
<pre>jQuery("#Datalist").jqGrid({</pre>
<pre>    url: URLPath,</pre>
<pre>    datatype: "json",</pre>
<pre>    height: 250,</pre>
<pre>    colModel: [</pre>
<pre>         { name: &#39;AppCode&#39;, index: &#39;AppCode&#39;, label: &#39;ç”³è¯·è¡¨ç¼–å·&#39;, width: 120, sorttype: "int" },</pre>
<pre>         { name: &#39;BusinessId&#39;, index: &#39;BusinessId&#39;, label: &#39;ä¸šåŠ¡ID&#39;, hidden: true },</pre>
<pre>         { name: &#39;Ver&#39;, index: &#39;Ver&#39;, label: &#39;ç‰ˆæœ¬å·&#39;, hidden: true },</pre>
<pre>         { name: &#39;RegisterId&#39;, index: &#39;RegisterId&#39;, label: &#39;æ³¨å†ŒId&#39;, hidden: true },</pre>
<pre>       &#160; { name: &#39;ISBespoke_Flag&#39;, index: &#39;ISBespoke_Flag&#39;, label: &#39;é¢„çº¦æ ‡å¿—&#39;, hidden: true },</pre>
<pre>        { name: &#39;ApproveFlag&#39;, index: &#39;ApproveFlag&#39;, label: &#39;APPROVEFLAG&#39;, hidden: true }</pre>
<pre>  ],</pre>
<pre>rownumbers: true, //æ·»åŠ å·¦ä¾§è¡Œå· </pre>
<pre>rowNum: 10,</pre>
<pre>rowList: [5, 10, 20, 30],</pre>
<pre>recordpos: &#39;left&#39;,</pre>
<pre>pager: &#39;#gridPager&#39;,</pre>
<pre>jsonReader: {</pre>
<pre></pre>
<pre>   root: "RowsData",</pre>
<pre></pre>
<pre>   records: "RecordCount",&#160; &#160; &#160; &#160;</pre>
<pre></pre>
<pre> &#160; total: "PageCount",&#160;</pre>
<pre></pre>
<pre>   page: "PageIndex",</pre>
<pre>   repeatitems: false&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;</pre>
<pre>},&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;</pre>
<pre>... ...</pre>
<pre>});</pre>
<pre></pre>
]]></description>
        	        	<pubDate>Fri, 12 Apr 2013 14:06:48 +0300</pubDate>
        </item>
</channel>
</rss>