Dataset 输出Json格式

最新推荐文章于 2023-10-27 23:13:36 发布

P_Alex

最新推荐文章于 2023-10-27 23:13:36 发布

阅读量1.6k

点赞数

分类专栏： .net

本文链接：https://blog.csdn.net/longchenghui20/article/details/77045426

版权

.net 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

  [HttpPost]
        public string GetTableSetCovertJson() {
            DataTable dt = new DataTable("status");
            dt.Columns.AddRange(new DataColumn[] {
                new DataColumn() { ColumnName="Name",DataType=typeof(System.String)},
                new DataColumn() { ColumnName="Age",DataType=typeof(System.Int32)},
                new DataColumn() { ColumnName="Address",DataType=typeof(System.String)},
            });
            dt.Rows.Add(new object[] { "周伯通",98,"重阳宫"});
            dt.Rows.Add(new object[] { "王重阳", 108, "黑洞" });
            dt.Rows.Add(new object[] { "黄药师", 106, "桃花岛" });
            DataTable dt2 = dt.Clone();//克隆表一的结构（所有列）
            dt2.TableName = "Second";
            //表2添加行
            dt2.Rows.Add(new object[] {"郭靖",23,"蒙古大草原" });
            dt2.Rows.Add(new object[] { "黄蓉", 22, "桃花岛" });
            //将datable放入dataset中
            //创建dataset
            DataSet ds = new DataSet();
            ds.Tables.AddRange(new DataTable[]{ dt, dt2 });
           
          return   JsonConvert.SerializeObject(ds);
        }
返回的json格式
{"status":
[{"Name":"周伯通","Age":98,"Address":"重阳宫"},
{"Name":"王重阳","Age":108,"Address":"黑洞"},
{"Name":"黄药师","Age":106,"Address":"桃花岛"}],
"Second":
[{"Name":"郭靖","Age":23,"Address":"蒙古大草原"},
{"Name":"黄蓉","Age":22,"Address":"桃花岛"}]},