DataTable转JSON

xiaoxiao2021-02-28  102

1、引入Newtonsoft.Json的dll文件;引入Newtonsoft.Json命名空间:

DataTable转JSON字符串:

string josnstr = ""; string sql = "select ID,TestType from LbtTestTypes"; DataTable dt = SqlHelp.ExecuteDataset(SqlHelp.constr, sql, CommandType.Text, null).Tables[0]; if (dt.Rows.Count > 0) { josnstr = JsonConvert.SerializeObject(dt, new DataTableConverter()); } else { josnstr = "[]"; } return josnstr;

List转JSON字符串:

public string LbtProjectInfo() { string josnstr = ""; List<RoadFlow.Data.Model.LbtTestTypes> list = btt.GetType(); if (list.Count > 0) { josnstr = JsonConvert.SerializeObject(list); } else { josnstr = "[]"; } return josnstr; } 相关博客: http://www.cnblogs.com/kissdodog/archive/2012/12/31/2841201.html

转载请注明原文地址: https://www.6miu.com/read-72652.html

最新回复(0)