/*
By:wgscd
C# Json类 ,目前CSV,Json等格式很流行了,像Yahoo,Google等搜索引擎都有这种格式。
.net 2.0既然没有来处理Json的类。实在不应该,好像说是.NET3.5已经有了。
手工活写转换JSON格式如下:*/
using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Text; /// <summary> ///JsonData 的摀要说怎 /// </summary> public static class Json { public static string CreateJsonParameters1(DataTable dt) { StringBuilder JsonString = new StringBuilder(); //Exception Handling if (dt != null && dt.Rows.Count > 0) { JsonString.Append("{/"totalCount/":" + dt.Rows.Count.ToString() + ","); JsonString.Append("/"JsonData/":["); for (int i = 0; i < dt.Rows.Count; i++) { JsonString.Append("{"); for (int j = 0; j < dt.Columns.Count; j++) { if (j < dt.Columns.Count - 1) { JsonString.Append("/"" + dt.Columns[j].ColumnName.ToString() + "/":" + "/"" + dt.Rows[i][j].ToString() + "/","); } else if (j == dt.Columns.Count - 1) { JsonString.Append("/"" + dt.Columns[j].ColumnName.ToString() + "/":" + "/"" + dt.Rows[i][j].ToString() + "/""); } } if (i == dt.Rows.Count - 1) { JsonString.Append("}"); } else { JsonString.Append("},"); } } JsonString.Append("]}"); return JsonString.ToString(); } else { return null; } } }