首页 > Windows开发 > 详细

C# DataTable转json

时间:2015-10-29 23:09:13      阅读:243      评论:0      收藏:0      [点我收藏+]
public static string jsonForEasyui(string totalCount, DataTable dt)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("{ ");
            builder.Append("\"total\":\"" + totalCount + "\",");
            builder.Append("\"rows\":[ ");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                builder.Append("{ ");
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    if (j < (dt.Columns.Count - 1))
                    {
                        builder.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + "\"" + ReplaceBadChar(dt.Rows[i][j].ToString()) + "\",");
                    }
                    else if (j == (dt.Columns.Count - 1))
                    {
                        builder.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + "\"" + ReplaceBadChar(dt.Rows[i][j].ToString()) + "\"");
                    }
                }
                if (i == (dt.Rows.Count - 1))
                {
                    builder.Append("} ");
                }
                else
                {
                    builder.Append("}, ");
                }
            }
            builder.Append("]}");
            return builder.ToString();
        }

  

C# DataTable转json

原文:http://www.cnblogs.com/jj880715/p/4921992.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!