json和其他数据容器转换 

 1 dataTable转换成Json格式 ：
 2 /// <summary> 
 3 /// dataTable转换成Json格式 
 4 /// </summary> 
 5 /// <param name="dt"></param> 
 6 /// <returns></returns> 
 7 private string DataTable2Json(DataTable dt)
 8 {
 9 //dt.Columns.Remove("回写字段");
10 StringBuilder jsonBuilder = new StringBuilder();
11 //jsonBuilder.Append("[");
12 for (int i = 0; i < dt.Rows.Count; i++)
13 {
14 jsonBuilder.Append("{");
15 for (int j = 0; j < dt.Columns.Count; j++)
16 {
17 if (dt.Columns[j].Caption != "回写字段")
18 {
19 jsonBuilder.Append("\"");
20 jsonBuilder.Append(dt.Columns[j].ColumnName);
21 jsonBuilder.Append("\":\"");
22 jsonBuilder.Append(dt.Rows[i][j].ToString());
23 jsonBuilder.Append("\",");
24 }
25 }
26 jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
27 jsonBuilder.Append("},");
28 }
29 jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
30 //jsonBuilder.Append("]");
31 //jsonBuilder.Append("}");
32 return jsonBuilder.ToString();
33 }
34 
35

 

posted @ 2021-03-10 13:54  QD西红柿  阅读(63)  评论(0)    收藏  举报