首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > C# >

怎么使用C#生成json数据

2012-05-13 
如何使用C#生成json数据[[崇明, 崇明],[黄浦, 黄浦],[卢湾, 卢湾],[徐汇, 徐汇],[长宁,

如何使用C#生成json数据
[
["崇明", "崇明"],
["黄浦", "黄浦"],
["卢湾", "卢湾"],
["徐汇", "徐汇"],
["长宁", "长宁"],
["静安", "静安"],
["普陀", "普陀"],
["闸北", "闸北"],
["虹口", "虹口"],
["杨浦", "杨浦"],
["闵行", "闵行"],
["宝山", "宝山"],
["嘉定", "嘉定"],
["浦东", "浦东"],
["金山", "金山"],
["松江", "松江"],
["青浦", "青浦"],
["南汇", "南汇"],
["奉贤", "奉贤"],
["朱家角", "朱家角"]
]

如何使用C#生成上面的json数据

[解决办法]
分两次贴 

C# code
        #region Datatable转换为Json        /// <summary>         /// Datatable转换为Json         /// </summary>         /// <param name="table">Datatable对象</param>         /// <returns>Json字符串</returns>         public static string ToJson(DataTable dt)        {            StringBuilder jsonString = new StringBuilder();            jsonString.Append("[");            DataRowCollection drc = dt.Rows;            for (int i = 0; i < drc.Count; i++)            {                jsonString.Append("{");                for (int j = 0; j < dt.Columns.Count; j++)                {                    string strKey = dt.Columns[j].ColumnName;                    string strValue = drc[i][j].ToString();                    Type type = dt.Columns[j].DataType;                    jsonString.Append("\"" + strKey + "\":");                    strValue = StringFormat(strValue, type);                    if (j < dt.Columns.Count - 1)                    {                        jsonString.Append(strValue + ",");                    }                    else                    {                        jsonString.Append(strValue);                    }                }                jsonString.Append("},");            }            jsonString.Remove(jsonString.Length - 1, 1);            jsonString.Append("]");            return jsonString.ToString();        }        /// <summary>        /// DataTable转换为Json         /// </summary>        public static string ToJson(DataTable dt, string jsonName)        {            StringBuilder Json = new StringBuilder();            if (string.IsNullOrEmpty(jsonName)) jsonName = dt.TableName;            Json.Append("{\"" + jsonName + "\":[");            if (dt.Rows.Count > 0)            {                for (int i = 0; i < dt.Rows.Count; i++)                {                    Json.Append("{");                    for (int j = 0; j < dt.Columns.Count; j++)                    {                        Type type = dt.Rows[i][j].GetType();                        Json.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + StringFormat(dt.Rows[i][j].ToString(), type));                        if (j < dt.Columns.Count - 1)                        {                            Json.Append(",");                        }                    }                    Json.Append("}");                    if (i < dt.Rows.Count - 1)                    {                        Json.Append(",");                    }                }            }            Json.Append("]}");            return Json.ToString();        }        #endregion        #region DataReader转换为Json        /// <summary>         /// DataReader转换为Json         /// </summary>         /// <param name="dataReader">DataReader对象</param>         /// <returns>Json字符串</returns>         public static string ToJson(DbDataReader dataReader)        {            StringBuilder jsonString = new StringBuilder();            jsonString.Append("[");            while (dataReader.Read())            {                jsonString.Append("{");                for (int i = 0; i < dataReader.FieldCount; i++)                {                    Type type = dataReader.GetFieldType(i);                    string strKey = dataReader.GetName(i);                    string strValue = dataReader[i].ToString();                    jsonString.Append("\"" + strKey + "\":");                    strValue = StringFormat(strValue, type);                    if (i < dataReader.FieldCount - 1)                    {                        jsonString.Append(strValue + ",");                    }                    else                    {                        jsonString.Append(strValue);                    }                }                jsonString.Append("},");            }            dataReader.Close();            jsonString.Remove(jsonString.Length - 1, 1);            jsonString.Append("]");            return jsonString.ToString();        }        #endregion    }} 


[解决办法]
RegionInfo须加上Serializable
[Serializable]
public class RegionInfo
{
......
}

热点排行