datatable或list集合转json

使用NuGet下载Newtonsoft.Json包

//dt---传入的datatable数据集
 public string ToJson(DataTable dt)
    {
      var result = JsonConvert.SerializeObject(dt, new DataTableConverter())
	return result;
    }
           

//lsit---传入的list对象集合
 public string ToJson(List<PlastiaBox> list)
    {
     	JsonSerializer serializer = new JsonSerializer();
        StringWriter sw = new StringWriter();
        serializer.Serialize(new JsonTextWriter(sw), list);
		return sw.GetStringBuilder().ToString();
    }