C# extract useful information from json string with redundant message and code

The json string has additional message as below,I'll extract the data part and convert it to DataTable via JObject,JToken,Jarray in NewtonSoft.Json.

{"code":0,"msg":"","data":[{"Id":1,"Name":"Fred","Age":33,"Title":"CEO"},{"Id":2,"Name":"Fred2","Age":34,"Title":"CFO"},{"Id":3,"Name":"Fred3","Age":35,"Title":"CTO"}]}

 

复制代码
 static DataTable ConvertJsonFileToDt(string jsonValue)
        {
            DataTable dt = new DataTable();            
            if(string.IsNullOrEmpty(jsonValue))
            {
                return dt;
            }
            JObject jObj = JObject.Parse(jsonValue); 
            JToken jTokenData = jObj["data"];
            JArray srcArray = JArray.FromObject(jTokenData);
            JArray targetArray = new JArray();
            foreach(JObject row in srcArray.Children<JObject>())
            {
                var cleanRow = new JObject();
                foreach(JProperty column in row.Properties())
                {
                    if(column.Value is JValue)
                    {
                        cleanRow.Add(column.Name, column.Value);
                    }
                }
                targetArray.Add(cleanRow);
            }
            dt = JsonConvert.DeserializeObject<DataTable>(targetArray.ToString()); 
            return dt;
        }
复制代码

 Or it is just a serialized json string which is far more easier.

[{"Name":"Fred1","Age":33,"Id":1},{"Name":"Fred2","Age":34,"Id":2},{"Name":"Fred3","Age":35,"Id":3}]

复制代码
 static void DynamicJson()
        {
            var obj = new[]
            {
                new {Name="Fred1",Age=33,Id=1},
                new {Name="Fred2",Age=34,Id=2},
                new {Name="Fred3",Age=35,Id=3}
            };            
            var jsonValue = JsonConvert.SerializeObject(obj); 
            DataTable dt = JsonConvert.DeserializeObject<DataTable>(jsonValue);
        }
复制代码

 

posted @   FredGrit  阅读(135)  评论(0编辑  收藏  举报
编辑推荐:
· AI与.NET技术实操系列:基于图像分类模型对图像进行分类
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
阅读排行:
· 分享一个免费、快速、无限量使用的满血 DeepSeek R1 模型,支持深度思考和联网搜索!
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· ollama系列01:轻松3步本地部署deepseek,普通电脑可用
· 25岁的心里话
· 按钮权限的设计及实现
历史上的今天:
2019-10-27 wpf listview images
2019-10-27 C# extract multiples from web pages based on OpenQA.Selenium.Chrome and ChromeDriver
2016-10-27 浅拷贝 深拷贝
点击右上角即可分享
微信分享提示