C# 类似xxx|xxxxxxx,根据多个符号拆分字符串并放入Dictionary,把Dictionary转换成DataTable

 Dictionary<string, string> dictionary = new Dictionary<string, string>();
            string vs = "1,a|2,b|3,c|4,d|5,e|,|";
            dictionary = vs.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).GroupBy(x => x.Split(new string[] { "|" }, StringSplitOptions.None)[1], x => x.Split(new string[] { "|" }, StringSplitOptions.None)[0]).ToDictionary(x => x.Key, x => x.First());         
            foreach (KeyValuePair<string, string> kvp in dictionary)
            Console.WriteLine(kvp.Key + "   " + kvp.Value)
            //将Dictionary转换成datatable`在这里插入代码片`
            DataTable dt = new DataTable();
            DataColumn dc1 = new DataColumn("userguid");
            DataColumn dc2 = new DataColumn("username");
            dt.Columns.Add(dc1);
            dt.Columns.Add(dc2);
            foreach (KeyValuePair<string, string> item in dictionary)
            {
                dt.Rows.Add(item.Value,item.Key);
            }
            DataTable newdt = new DataTable();
            newdt = dt.Clone(); // 克隆dt 的结构
            DataRow[] rows = dt.Select("username like '%" + this.txtPeople.Value.Trim() + "%'"); // 从dt 中查询符合条件的记录；
            foreach (DataRow row in rows)
            {
                newdt.Rows.Add(row.ItemArray);// 将查询的结果添加到dt中;
            }