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();
    }