歡迎大家進QQ群來討論：84479667
方法如下: public static string nulldata = "{\"result\":\"true\",\"msg\":\"沒有相關(guān)數(shù)據(jù)\"}";#region 查詢結(jié)果轉(zhuǎn)為json/// <summary>/// 查詢結(jié)果轉(zhuǎn)為json/// </summary>/// <param name="dt"></param>/// <param name="count"></param>/// <returns></returns>public static string GetDataToJSON(DataTable dt, int count = 0){JavaScriptSerializer jss = new JavaScriptSerializer();System.Collections.ArrayList dic = new System.Collections.ArrayList();if (dt != null && dt.Rows.Count > 0){if (count == 0){count = dt.Rows.Count;}foreach (DataRow dr in dt.Rows){System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>();foreach (DataColumn dc in dt.Columns){//string dcvalue = Common.PageBase.delhtml(dr[dc.ColumnName].ToString()); drow.Add(dc.ColumnName, dr[dc.ColumnName]);}dic.Add(drow);}//bool result = true;string JsonString = jss.Serialize(dic);string p = @"\\/Date\((\d+)\)\\/";MatchEvaluator matchEvaluator = new MatchEvaluator(ConvertJsonDateToDateString);//MatchEvaluator img_urlEvaluator = new MatchEvaluator(GetImgUrl);Regex reg = new Regex(p);//Regex img_url = new Regex("src=\\\\\"(.*?)\"");//Regex img_url = new Regex("src=\"(.*?)\"");JsonString = reg.Replace(JsonString, matchEvaluator);//JsonString = img_url.Replace(JsonString, img_urlEvaluator);return "{\"result\": \"true\"" + "," + "\"rows\":" + count + "," + "\"msg\":" + JsonString + "}";}else{return nulldata;}}#endregion/// <summary>/// 將Json序列化的時間由/Date(1294499956278+0800)轉(zhuǎn)為字符串/// </summary>/// <param name="m"></param>/// <returns></returns>private static string ConvertJsonDateToDateString(Match m){string result = string.Empty;DateTime dt = new DateTime(1970, 1, 1);dt = dt.AddMilliseconds(long.Parse(m.Groups[1].Value));dt = dt.ToLocalTime();result = dt.ToString("yyyy-MM-dd HH:mm:ss");return result;}public string CreateJsonParameters(DataTable dt, int count = 0){if (dt == null || dt.Rows.Count == 0){return nulldata;}if (count == 0){count = dt.Rows.Count;}bool result = true;StringBuilder JsonString = new StringBuilder();//Exception Handling if (dt != null && dt.Rows.Count > 0){JsonString.Append("{ ");JsonString.Append("\"result\":" + result + "," + "rows:" + count + "," + "msg:[ ");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() + "\"");}}/*end Of String*/if (i == dt.Rows.Count - 1){JsonString.Append("} ");}else{JsonString.Append("}, ");}}JsonString.Append("]}");return JsonString.ToString();}else{return null;}}

?

轉(zhuǎn)載于:https://www.cnblogs.com/lifueng/p/4243857.html

總結(jié)

以上是生活随笔為你收集整理的ASP.NET DataSet查询结果转换为JSON格式数据的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。