table数据转换json格式方法

来源：互联网发布：js中设计模式编辑：程序博客网时间：2024/05/07 04:44

呵呵 table直接转换json格式字符串啊！！

        public string CreateJsonParameters(DataTable dt)        {            StringBuilder JsonString = new StringBuilder();            if (null != dt && 0 < dt.Rows.Count)            {                string[] ColumnName = new String[dt.Columns.Count];                for (int j = 0; j < dt.Columns.Count; j++)                {                    ColumnName[j] = "\"" + dt.Columns[j].ColumnName.ToString().Replace("\"", "\\\"") + "\":\"";                }                JsonString.Append("[");                for (int i = 0; i < dt.Rows.Count; i++)                {                    JsonString.Append("{");                    for (int j = 0; j < dt.Columns.Count; j++)                    {                        JsonString.Append(ColumnName[j]);                        JsonString.Append(dt.Rows[i][j].ToString().Replace("\"", "\\\""));                        JsonString.Append("\",");                    }                    JsonString.Remove(JsonString.Length - 1, 1);                    JsonString.Append("},");                }                JsonString.Remove(JsonString.Length - 1, 1);                JsonString.Append("]");                return JsonString.ToString();            }            else            {                return null;            }        }