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

 

posted @ 2020-07-21 08:28  王小鹏  阅读(485)  评论(0编辑  收藏  举报