DataTable Conversion JSON
Last Update:2016-06-03
Source: Internet
Author: User
<span id="Label3"></p><p><p>1. Page AJAX transfer value to the general processing program</p></p><pre><span style="color: #000000;"><span style="color: #000000;">function Btnonclick () {alert (</span></span><span style="color: #800080;"><span style="color: #800080;">1</span></span><span style="color: #000000;"><span style="color: #000000;">); $.ajax ({url:</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">.. /ashx/handertest.ashx</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">, Type:</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">GET</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">, DataType:</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">JSON</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">, Success:function (data) {alert (</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Success</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); Alert (data.status); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">var</span></span>obj =<span style="color: #000000;"><span style="color: #000000;">data.rows; </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">var</span></span>HTML =<span style="color: #800000;"><span style="color: #800000;">""</span></span><span style="color: #000000;"><span style="color: #000000;">; HTML</span></span>+=<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;"><ul></span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> for</span>(<span style="color: #0000ff;"><span style="color: #0000ff;">var</span></span>i =<span style="color: #800080;"><span style="color: #800080;">0</span></span>; I < obj.length; i++<span style="color: #000000;"><span style="color: #000000;">) {html</span></span>+=<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;"><li></span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>+ obj[i]. Product +<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;"></li></span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">; HTML</span></span>+=<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;"><li></span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>+ obj[i]. Description +<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;"></li></span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">; } HTML</span></span>+=<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;"></ul></span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">; $(</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">#span_tr</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">). Append (html); </span></span><span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">document.getElementById ("span_tr"). append = html;</span></span><span style="color: #000000;"><span style="color: #000000;">}, fail:function () {alert (</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">failed</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); }, error:function () {alert (</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Error</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); } }); } </span></span></pre><p><p>2. General Handler Conversion JSON</p></p><pre> <span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">void</span></span><span style="color: #000000;"><span style="color: #000000;">ProcessRequest (httpcontext Context) {context. Response.ContentType</span></span>=<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Text/plain</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">; </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">#region</span></span>DataTable type Data<span style="color: #000000;"><span style="color: #000000;">DataTable DT</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span>DataTable (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Datas</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); DataColumn DC</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span><span style="color: #000000;"><span style="color: #000000;">; DC</span></span>= Dt. Columns.Add (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">ID</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>, Type.GetType (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">System.Int32</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">)); dc. AutoIncrement</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">true</span></span>;<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">automatically add</span></span>dc. AutoIncrementSeed =<span style="color: #800080;"><span style="color: #800080;">1</span></span>;<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">starting at 1</span></span>dc. AutoIncrementStep =<span style="color: #800080;"><span style="color: #800080;">1</span></span>;<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">Step size is 1</span></span>dc. AllowDBNull =<span style="color: #0000ff;"><span style="color: #0000ff;">false</span></span><span style="color: #000000;"><span style="color: #000000;">; DC</span></span>= Dt. Columns.Add (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Product</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>, Type.GetType (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">System.String</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">)); DC</span></span>= Dt. Columns.Add (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Description</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>, Type.GetType (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">System.String</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">)); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> for</span>(<span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span>i =<span style="color: #800080;"><span style="color: #800080;">0</span></span>; I <<span style="color: #800080;"><span style="color: #800080;">5</span></span>; i++<span style="color: #000000;"><span style="color: #000000;">) {DataRow Dr</span></span>=<span style="color: #000000;"><span style="color: #000000;">DT. NewRow (); dr[</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Product</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>] =<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Test Products</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>+<span style="color: #000000;"><span style="color: #000000;">i; dr[</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Description</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>] =<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">Test Product Description</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>+<span style="color: #000000;"><span style="color: #000000;">i; Dt. Rows.Add (dr); } </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">#endregion</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">#region</span></span>JSON formatting<span style="color: #000000;"><span style="color: #000000;">StringBuilder Str</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">StringBuilder (); Str.append (</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">{\ "status\":</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); Str.append (</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">\ "rows\": [</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); DataRowCollection DRC</span></span>=<span style="color: #000000;"><span style="color: #000000;">DT. Rows; </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> for</span>(<span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span>i =<span style="color: #800080;"><span style="color: #800080;">0</span></span>; I < drc. Count; i++<span style="color: #000000;"><span style="color: #000000;">) {str.append (</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">{</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> for</span>(<span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span>j =<span style="color: #800080;"><span style="color: #800080;">0</span></span>; J < Dt. columns.count; J + +<span style="color: #000000;"><span style="color: #000000;">) { </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>Strkey = Dt. Columns[j]. ColumnName;<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">Column Name</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>strvalue = drc[i][j]. ToString ();<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">values for column names</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(j < DT. columns.count-<span style="color: #800080;"><span style="color: #800080;">1</span></span><span style="color: #000000;"><span style="color: #000000;">) {str.appendformat (</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">\ "{0}\": \ "{1}\",</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>, strkey, strvalue);<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">have commas</span></span><span style="color: #000000;"><span style="color: #000000;"> } </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Else</span></span><span style="color: #000000;"><span style="color: #000000;">{str.appendformat (</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">\ "{0}\": \ "{1}\"</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span>, strkey, strvalue);<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">no comma</span></span><span style="color: #000000;"><span style="color: #000000;">}} Str.append (</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">},</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); } str.remove (str.length</span></span>-<span style="color: #800080;"><span style="color: #800080;">1</span></span>,<span style="color: #800080;"><span style="color: #800080;">1</span></span>);<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">remove the last comma</span></span>Str.append (<span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #800000;"><span style="color: #800000;">]}</span></span><span style="color: #800000;"><span style="color: #800000;">"</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">#endregion</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">string</span></span>Jsonstr =<span style="color: #000000;"><span style="color: #000000;">str.tostring (); Context. Response.Write (jsonstr); }</span></span></pre><span class="cnblogs_code_collapse"><span class="cnblogs_code_collapse">View Code</span></span><p><p></p></p><p><p>DataTable Conversion JSON</p></p></span>
