.net DataTable序列化成Json 

 1 /// <summary>
 2 /// DataTable序列化
 3 /// </summary>
 4 /// <param name="dt"></param>
 5 /// <param name="flag">false</param>
 6 /// <returns></returns>
 7 public string Serialize(DataTable dt)
 8 {
 9 JavaScriptSerializer serializer = new JavaScriptSerializer();
10 List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
11 foreach (DataRow dr in dt.Rows)
12 {
13 Dictionary<string, object> result = new Dictionary<string, object>();
14 foreach (DataColumn dc in dt.Columns)
15 {
16 if (dc.ColumnName.ToLower() == "checked")
17 {
18 result.Add(dc.ColumnName.ToLower(), dr[dc] == DBNull.Value || false ? false : true);
19 }
20 else
21 {
22 result.Add(dc.ColumnName.ToLower(), dr[dc].ToString().ToLower());
23 }
24 }
25 list.Add(result);
26 }
27 return serializer.Serialize(list); ;
28 }

 

posted @ 2017-05-03 09:36  风中寻觅  阅读(383)  评论(0)    收藏  举报