C# DataTable转Json

时间:2020-03-31 11:23:57   收藏:0   阅读:69
      /// <summary>
        /// 将datatable转换为json  
        /// </summary>
        /// <param name="dtb">Dt</param>
        /// <returns>JSON字符串</returns>
        public static string GetJsonByDataTable(DataTable dtb)
        {
            JavaScriptSerializer jss = new JavaScriptSerializer();
            System.Collections.ArrayList dic = new System.Collections.ArrayList();
            foreach (DataRow dr in dtb.Rows)
            {
                System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>();
                foreach (DataColumn dc in dtb.Columns)
                {

                    if (dr[dc.ColumnName].GetType().Name.Equals("DateTime"))
                        drow.Add(dc.ColumnName, Convert.ToString(dr[dc.ColumnName]));
                    else
                        drow.Add(dc.ColumnName, dr[dc.ColumnName]);

                }
                dic.Add(drow);

            }
            //序列化  
            return jss.Serialize(dic);
        }

原文:https://www.cnblogs.com/Alex-Mercer/p/12603020.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!