JsonHelper(datatale或dataset转json)
来源:互联网 发布:石材效果图设计软件 编辑:程序博客网 时间:2024/06/10 09:57
public class JsonHelper
{
#region dataTable转换成Json格式
/// <summary>
/// dataTable转换成Json格式
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static string DataTableToJson(DataTable dt)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{\"");
jsonBuilder.Append(dt.TableName.ToString());
jsonBuilder.Append("\":[");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dt.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return jsonBuilder.ToString();
}
/*返回的格式
{ "programmers": [
{ "firstName": "Brett", "lastName":"McLaughlin", "email": "aaaa" },
{ "firstName": "Jason", "lastName":"Hunter", "email": "bbbb" },
{ "firstName": "Elliotte", "lastName":"Harold", "email": "cccc" }
]}
*/
#endregion dataTable转换成Json格式
#region dataset转json
/// <summary>
/// dataset
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public static string DataSetToJson(DataSet ds)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{");
foreach (DataTable dt in ds.Tables)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.TableName.ToString());
jsonBuilder.Append("\":[");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dt.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("],");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("}");
return jsonBuilder.ToString();
}
/*返回的格式
{ "programmers": [
{ "firstName": "Brett", "lastName":"McLaughlin", "email": "aaaa" },
{ "firstName": "Jason", "lastName":"Hunter", "email": "bbbb" },
{ "firstName": "Elliotte", "lastName":"Harold", "email": "cccc" }
],
"authors": [
{ "firstName": "Isaac", "lastName": "Asimov", "genre": "science fiction" },
{ "firstName": "Tad", "lastName": "Williams", "genre": "fantasy" },
{ "firstName": "Frank", "lastName": "Peretti", "genre": "christian fiction" }
],
"musicians": [
{ "firstName": "Eric", "lastName": "Clapton", "instrument": "guitar" },
{ "firstName": "Sergei", "lastName": "Rachmaninoff", "instrument": "piano" }
] }
*/
#endregion
}
- JsonHelper(datatale或dataset转json)
- JsonHelper Json转xml,Json转DataSet,DataSet转Json
- JsonHelper Json转xml,Json转DataSet,DataSet转Json
- JSONHelper JSON帮助类
- DataTable或DataSet与JSON互转
- DataTable或DataSet与JSON互转
- DataTable或DataSet与JSON互转
- dataset或dataTable转成json串
- DataSet 转Json
- Json解析工具类JsonHelper
- JsonHelper(C#)
- JsonHelper
- JsonHelper
- JsonHelper
- JSONHelper
- JsonHelper
- JsonHelper
- jsonHelper
- 点击ListView item时,长时间显示自定义背景
- LINUX VI编辑器使用说明
- 如何使用bat文件调用sql2005脚本文件
- 解决问题:java.lang.ClassCastException: android.app.Application
- 如何实现订阅Google+上用户的帖子
- JsonHelper(datatale或dataset转json)
- Spring 配置bean定义的继承
- Sleeping in the Kernel
- tcpdump
- ASCII 码
- 程序1
- 2011-08-03 Music Genre classification Scripts
- 解决一个在国内不能安装chrome扩展的问题
- web.xml