把datatable和数组转换成JSON格式 C#

来源：互联网发布：网络诈骗主犯编辑：程序博客网时间：2024/06/05 20:42
 public string CreateJsonParameters(DataTable dt,string name)        {            StringBuilder JsonString = new StringBuilder();                 if (dt != null && dt.Rows.Count > 0)            {                JsonString.Append("{ ");                JsonString.Append("\""+name+"\":[ ");                for (int i = 0; i < dt.Rows.Count; i++)                {                    JsonString.Append("{ ");                    for (int j = 0; j < dt.Columns.Count; j++)                    {                        if (j < dt.Columns.Count - 1)                        {                            JsonString.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + "\"" + dt.Rows[i][j].ToString() + "\",");                        }                        else if (j == dt.Columns.Count - 1)                        {                            JsonString.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + "\"" + dt.Rows[i][j].ToString() + "\"");                        }                    }                    if (i == dt.Rows.Count - 1)                    {                        JsonString.Append("} ");                    }                    else                    {                        JsonString.Append("}, ");                    }                }                JsonString.Append("]}");                return JsonString.ToString();            }            else            {                return null;            }        }        public string CreateJsonParameters1(string[,] array,string name)        {            StringBuilder JsonString = new StringBuilder();            if (array.Length/2> 0)            {                JsonString.Append("{ ");                JsonString.Append("\""+name+"\":[ ");                for (int i = 0; i < array.Length/2; i++)                {                    JsonString.Append("{ ");                    JsonString.Append("\"Value\":" + "\"" + array[i, 0].ToString() + "\",");                    JsonString.Append("\"Text\":" + "\"" + array[i, 1].ToString() + "\"");                    if (i == (array.Length / 2)-1)                    {                        JsonString.Append("}");                    }                    else                    {                        JsonString.Append("}, ");                    }                }                JsonString.Append("]}");                return JsonString.ToString();            }            else            {                return null;            }        }