public JObject getall()
{
try
{
DataBase db = new DataBase();
string sql = "select * from knowlege";
DataSet ds = db.GetDataSet(sql);
//将数据填充进dataset
List<knowlege> lt = filemanegerbetter.Models.datasettolist.DataSetToList<knowlege>(ds, 0); //用到实体类将数据与实体类映射
var total = lt.Count; //总数
var rows = lt.ToList(); //分页存储到List中
JObject jb = new JObject();
jb["total"] = total;
JObject js = new JObject();
JArray jj = new JArray();
foreach (var item in rows)
{
jj.Add(JObject.FromObject(item));
}
jb["rows"] = jj;
return jb;
//return Json(new { total = total, rows = rows }); //然后才转换成Json传递
}
catch (Exception ex)
{
JObject jb = new JObject();
jb["total"] = "";
jb["rows"] ="";
return jb;
}
}
c#返回Json对象数据
最新推荐文章于 2024-05-08 07:47:23 发布