转:http://www.cnblogs.com/simonblog/archive/2010/05/12/1733139.html
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
namespace ConsoleApplication1
{
public static class DataSetToJson
{
public static string DSToJson(this DataSet ds, string JsonName,
string[] ParName)
{
try
{
if (ds == null)
{
return “DataSet Is Null ,So I Can’t Do It To
Json!”;
}
if (JsonName.Length < 1)
{
return “You Set The Json Name Is Wrong!”;
}
if (ds.Tables[0].Columns.Count < ParName.Length)
{
return “You Give The ParName Is Bigger Than DataSet
Columns!”;
}
string josn = “{” + JsonName + “:[“;
string temp = “”;
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
temp = temp + “{“;
for (int i = 0; i < ParName.Length; i++)
{
temp += “” + ParName[i] + “:\'” +
ds.Tables[0].Rows[j][ParName[i]] + “\'”;
if (i != ParName.Length – 1)
{
temp = temp + “,”;
}
}
if (j == ds.Tables[0].Rows.Count – 1)
{
temp = temp + “}”;
}
else
{
temp = temp + “},”;
}
}
josn = josn + temp + “]}”;
return josn;
}
catch (Exception ex)
{
return “Codeing is Error—-” + ex.ToString();
}
}
}
}
及时是同等栽对数码取出的数量进行转换成json格式,还有雷同种植就是是可以管数据库里的数目存入到一个IList<>里,然后通过json里的JsonWriter来转换成json格式,这里就非出示代码了,,