DataTable转(字符串形式的)json;DataTable转easyui grid可以识别的json结构

using System.Web.Script.Serialization;

namespace test
{
    /// <summary>
    /// 关于json的操作
    /// </summary>
    public class Json
    {
        /// <summary>
        /// 用于生成适用于easyui datagrid的可识别json结构
        /// </summary>
        public class EDataGridTable
        {
            private int total { get; set; }
            private DataTable rows { get; set; }

            public EDataGridTable(int total, DataTable rows)
            {
                this.total = total;
                this.rows = rows;
            }

            /// <summary>
            /// 将EDataGridTable转化为easyui grid可以识别的json结构
            /// </summary>
            /// <returns></returns>
            public string ToJson()
            {
                return "{ \"total\":\"" + total + "\",\"rows\":" + DataTableToJson(rows) + "}";
            }      
        }

        /// <summary>
        /// 将Datable转化为json
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static string DataTableToJson(DataTable dt)
        {
            List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
            foreach (DataRow dr in dt.Rows)
            {
                Dictionary<string, object> result = new Dictionary<string, object>();
                foreach (DataColumn dc in dt.Columns)
                {
                    result.Add(dc.ColumnName, dr[dc]);
                }
                list.Add(result);
            }

            JavaScriptSerializer serialize = new JavaScriptSerializer();
            //serialize.RecursionLimit = recursionLimit;
            return serialize.Serialize(list); //亮点是可以解决特殊字符问题
        }
    }
}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值