static DataTable SplitJsonValueToDataTable(string postResult) { DataTable dt = new DataTable(); try { string[] dataArr = postResult.Split(new string[] { "," }, 3, StringSplitOptions.None); string[] firstDataArr = dataArr[0].Split(new string[] { ":" }, StringSplitOptions.None); if (!string.Equals(firstDataArr[1], "0")) { return dt; } string dataValue = dataArr[2].Split(new string[] { ":" },2,StringSplitOptions.None)[1]. Replace("[", "").Replace("]", ""); string[] dataValueArr = dataValue.Split(new string[] { "}" }, StringSplitOptions.RemoveEmptyEntries).Select(x => x.Replace("{", "")).ToArray(); if (dataValueArr != null && dataValueArr.Any()) { string[] firstDataValueArrItem = dataValueArr[0].Split(new string[] { "," }, StringSplitOptions.None); foreach (var a in firstDataValueArrItem) { string colName = a.Split(new string[] { ":" }, StringSplitOptions.None)[0].Replace(@"\""", " ").Replace(@"""", ""); dt.Columns.Add(colName); } foreach (var dva in dataValueArr) { DataRow dr = dt.NewRow(); string[] arr = dva.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); if (arr != null && arr.Any()) { for (int i = 0; i < arr.Length; i++) { dr[i] = arr[i].Split(new string[] { ":" }, StringSplitOptions.None)[1].Replace(@"\""", " ").Replace(@"""", ""); } } dt.Rows.Add(dr); } } } catch { } return dt; }
原文链接: https://www.cnblogs.com/Fred1987/p/12533451.html
欢迎关注
微信关注下方公众号,第一时间获取干货硬货;公众号内回复【pdf】免费获取数百本计算机经典书籍;
也有高质量的技术群,里面有嵌入式、搜广推等BAT大佬
原创文章受到原创版权保护。转载请注明出处:https://www.ccppcoding.com/archives/402031
非原创文章文中已经注明原地址,如有侵权,联系删除
关注公众号【高性能架构探索】,第一时间获取最新文章
转载文章受原作者版权保护。转载请注明原作者出处!