我希望在json数据中获得datatable数据,但在转换时,我得到的数据带有反斜杠符号。如何删除反斜杠或如何生成没有反斜杠的json数据。
输出数据
"[{\"Date\":\"2020-03-27T00:00:00\",\"Units\":1035.0},{\"Date\":\"2020-03-26T00:00:00\",\"Units\":1137.0},{\"Date\":\"2020-03-25T00:00:00\",\"Units\":1283.0},{\"Date\":\"2020-03-24T00:00:00\",\"Units\":635.0}]"
代码
using Newtonsoft.Json;
public string GetFanHoursReport(string fromdate, string todate)
{
string jsondata = "";
using (ColdStorageAppEntities entities = new ColdStorageAppEntities())
{
try
{
using (SqlConnection con = new SqlConnection(strcon_coldstorage))
{
con.Open();
SqlCommand cmd_getlatest = new SqlCommand(@"SELECT * from RawData", con);
SqlDataAdapter da_getlatest = new SqlDataAdapter(cmd_getlatest);
DataTable dt_getlatest = new DataTable();
da_getlatest.Fill(dt_getlatest);
jsondata=DataTableToJSONWithJSONNet(dt_getlatest);
}
return jsondata;
}
catch (Exception)
{
return null;
}
}
}
转换代码-
public string DataTableToJSONWithJSONNet(DataTable table)
{
string JSONString = string.Empty;
JSONString = JsonConvert.SerializeObject(table);
return JSONString;
}
发布于 2020-03-27 22:20:21
根据我的经验,只有在调试器中查看字符串时,才会出现反斜杠。如果你要写
Console.WriteLine(jsondata);
您可以确认字符串是否包含额外的转义字符。
https://stackoverflow.com/questions/60887817
复制相似问题