一、DataTable转为Josn
public static string ToJson(this DataTable dt)
{
List<object> dic = new List<object>();
foreach (DataRow dr in dt.Rows)
{
Dictionary<string, object> result = new Dictionary<string, object>();
foreach (DataColumn dc in dt.Columns)
{
result.Add(dc.ColumnName, dr[dc].ToString());
}
dic.Add(result);
}
JavaScriptSerializer serialize = new JavaScriptSerializer();
return serialize.Serialize(obj);
}
返回结果的格式如下:
[{\"id\":\"20\",\"name\":\"速冻食品\",\"state\":\"1\",\"addtime\":\"2017/10/26 9:21:37\",\"orders\":\"12\"},
{\"id\":\"18\",\"name\":\"进口食品\",\"state\":\"1\",\"addtime\":\"2017/10/26 9:20:53\",\"orders\":\"11\"},
{\"id\":\"14\",\"name\":\"产业链\",\"state\":\"1\",\"addtime\":\"2017/10/26 9:19:06\",\"orders\":\"10\"}]