如何将嵌套的JSON数组解析为dataset？
如何将嵌套的JSON数组解析为dataset？
提问于 2018-07-30 11:26:11
"Data": [
{
"Code": "DEMO",
"Name": "DEMO",
"UserId": "B27A68AD-7C21-4DDB-8A1D-8932459CF53B",
"RoleDetails": [{
"ViewId": "B27A68AD-7C21-4DDB-8A1D-8932459CF53B",
"IsAddAllowed": true,
"IsEditAllowed": true,
"IsDeleteAllowed": true
}],
"RoleDetails1":[ {
"ViewId": "B27A68AD-7C21-4DDB-8A1D-8932459CF53B",
"IsAddAllowed": true,
"IsEditAllowed": true,
"IsDeleteAllowed": true
}]
}
]我有一个JSON数组，我想把它转换成JSON中每个属性都有DataTable的DataSet。
回答 1
Stack Overflow用户
发布于 2018-08-03 05:14:13
这里有一个使用Cinchoo ETL将JSON转换为Dataset的简单方法-一个开源库
string json = @"{
""Data"": [
{
""Code"": ""DEMO"",
""Name"": ""DEMO"",
""UserId"": ""B27A68AD-7C21-4DDB-8A1D-8932459CF53B"",
""RoleDetails"": [{
""ViewId"": ""B27A68AD-7C21-4DDB-8A1D-8932459CF53B"",
""IsAddAllowed"": true,
""IsEditAllowed"": true,
""IsDeleteAllowed"": true
}],
""RoleDetails1"":[ {
""ViewId"": ""Z27A68AD-7C21-4DDB-8A1D-8932459CF53B"",
""IsAddAllowed"": true,
""IsEditAllowed"": true,
""IsDeleteAllowed"": true
}]
}
]
}";
var dt1 = ChoJSONReader.DeserializeText(json, "$.Data[0].RoleDetails").AsDataTable();
var dt2 = ChoJSONReader.DeserializeText(json, "$.Data[0].RoleDetails1").AsDataTable();
DataSet ds = new DataSet();
ds.Tables.Add(dt1);
ds.Tables.Add(dt2);希望能有所帮助。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/51586605
复制相关文章
相似问题
腾讯云开发者
