首頁 給出 DataTable 轉(zhuǎn)Json 的方法:
1 public static string TableToJson(DataTable dt) 2 { 3 List<Dictionary<string, object>> list = new List<Dictionary<string, object>>(); 4 foreach (DataRow dr in dt.Rows)//每一行信息,新建一個Dictionary<string,object>,將該行的每列信息加入到字典 5 { 6 Dictionary<string, object> result = new Dictionary<string, object>(); 7 foreach (DataColumn dc in dt.Columns) 8 { 9 result.Add(dc.ColumnName, dr[dc].ToString());10 }11 list.Add(result);12 }13 return ToJson(list);//調(diào)用Serializer方法 14 }
1 /// <summary> 2 /// 將集合轉(zhuǎn)換為json 3 /// </summary> 4 /// <param name="d"></param> 5 /// <returns></returns> 6 public static string ToJson(object d) 7 { 8 javaScriptSerializer jss = new JavascriptSerializer(); 9 return jss.Serialize(d);10 }
具體 轉(zhuǎn)換實例:
1 #region 獲取我的訂單 2 public string GetMyOrders(string _StrJson) 3 { 4 StringBuilder sbStr = new StringBuilder(); 5 sbStr.Append("[{/"msg/":/"獲取失敗,參數(shù)錯誤。/",/"data/":/"[]/",/"state/":/"2/"}]"); 6 try 7 { 8 CommonJsonModel oModel = new CommonJsonModel(Regex.Replace(_StrJson, @"/r/n", "")); 9 List<CommonJsonModel> lst = oModel.GetCollection();10 foreach (CommonJsonModel item in lst)11 {12 //[{"_Page":"1","_PageSize":"10","_Type":"1","_Status":"0","_LoginId":"15","_
新聞熱點
疑難解答