C# DataTable 转换成JSON数据

来源：互联网发布：网络兼职百度经验编辑：程序博客网时间：2024/06/08 22:39

转自：http://www.cnblogs.com/252e/archive/2011/09/01/2161821.html

复制代码 1  /// <summary> 2         /// 将datatable转换为json   3         /// </summary> 4         /// <param name="dtb">Dt</param> 5         /// <returns>JSON字符串</returns> 6         public static string Dtb2Json(DataTable dtb) 7         { 8             JavaScriptSerializer jss = new JavaScriptSerializer(); 9             System.Collections.ArrayList dic = new System.Collections.ArrayList();10             foreach (DataRow dr in dtb.Rows)11             {12                 System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>();13                 foreach (DataColumn dc in dtb.Columns)14                 {15                     drow.Add(dc.ColumnName, dr[dc.ColumnName]);16                 }17                 dic.Add(drow);18 19             }20             //序列化  21             return jss.Serialize(dic);22         }复制代码

0 0