C#Table转成json工具
public static JObject getJson(DataTable myTable) { List<string> list = new List<string>(); foreach (DataColumn col in myTable.Columns) { list.Add(col.ColumnName); } JObject jb = new JObject(); JArray ja = new JArray(); foreach (DataRow row in myTable.Rows) { JObject Jtemp = new JObject(); list.ForEach(x=> Jtemp.Add(x,(JToken)(row[x].ToString()))); ja.Add(Jtemp); } jb.Add("rows",ja); return jb; }