c#如何把Json转成DataTable每一行都一一对应下面多出来的列自动添加到后方

答案:2 悬赏:20 手机版

解决时间 2021-03-15 22:28

提问者网友：太高姿态
2021-03-15 02:30

最佳答案

五星知识达人网友：我住北渡口
2021-03-15 03:18

/// <summary>
        /// 将json转换为DataTable
        /// </summary>
        /// <param name="strJson">得到的json</param>
        /// <returns></returns>
        private DataTable JsonToDataTable(string strJson)
        {
            //转换json格式
            strJson = strJson.Replace(",\"", "*\"").Replace("\":", "\"#").ToString();
            //取出表名
            var rg = new Regex(@"(?<={)[^:]+(?=:\[)", RegexOptions.IgnoreCase);
            string strName = rg.Match(strJson).Value;
            DataTable tb = null;
            //去除表名
            strJson = strJson.Substring(strJson.IndexOf("[") + 1);
            strJson = strJson.Substring(0, strJson.IndexOf("]"));

            //获取数据
            rg = new Regex(@"(?<={)[^}]+(?=})");
            MatchCollection mc = rg.Matches(strJson);
            for (int i = 0; i < mc.Count; i++)
            {
                string strRow = mc[i].Value;
                string[] strRows = strRow.Split('*');

                //创建表
                if (tb == null)
                {
                    tb = new DataTable();
                    tb.TableName = strName;
                    foreach (string str in strRows)
                    {
                        var dc = new DataColumn();
                        string[] strCell = str.Split('#');

                        if (strCell[0].Substring(0, 1) == "\"")
                        {
                            int a = strCell[0].Length;
                            dc.ColumnName = strCell[0].Substring(1, a - 2);
                        }
                        else
                        {
                            dc.ColumnName = strCell[0];
                        }
                        tb.Columns.Add(dc);
                    }
                    tb.AcceptChanges();
                }

                //增加内容
                DataRow dr = tb.NewRow();
                for (int r = 0; r < strRows.Length; r++)
                {
                    dr[r] = strRows[r].Split('#')[1].Trim().Replace("，", ",").Replace("：", ":").Replace("\"", "");
                }
                tb.Rows.Add(dr);
                tb.AcceptChanges();
            }

            return tb;
        }
这是json转tb的，还有后面那句什么意思？没看懂

全部回答

1楼网友：蓝房子
2021-03-15 04:21

public static javascriptserializer js = new javascriptserializer(); public static void responsejsondata(list<object> list) { string jsonstring = js.serialize(list); // 输出串 httpcontext.current.response.clear(); httpcontext.current.response.buffer = true; httpcontext.current.response.expiresabsolute = datetime.now.adddays(-1); httpcontext.current.response.addheader("pragma", "no-cache"); httpcontext.current.response.addheader("cache-control", ""); httpcontext.current.response.cachecontrol = "no-cache"; httpcontext.current.response.contentencoding = encoding.utf8; httpcontext.current.response.contenttype = "application/json"; httpcontext.current.response.write(jsonstring); httpcontext.current.response.flush(); httpcontext.current.response.end(); }命名空间 using system.web.script.serialization;

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息