c#以不同方式显示表

 disp2 "**|**|**"

disp1 关键列（MC）

结果：将拆分后的DISP2作为关键列，DISP1组合起来显示

先记录草稿，需要进一步优化

            DataTable dt = new CombindSearch(prj.Bl.GetConStr(), "XMLB", "mc", "sflp", "项目名称", "是否录屏").GetNewDt();

    public class CombindSearch
    {

        public CombindSearch(string strCon, string tableName, string field1, string field2, string disp1 = "", string disp2 = "")
        {
            this.ConStr = strCon;
            this.TableName = tableName;
            this.Field1 = field1;
            this.Field2 = field2;
            this.disp1 = disp1;
            this.disp2 = disp2;
        }
        private string disp1, disp2;
        public string Field1 { get; set; }
        public string Field2 { get; set; }

        public string ConStr { get; set; }

        public string TableName { get; set; }

        public DataTable GetNewDt()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add(this.Field2, typeof(string));
            dt.Columns.Add(this.Field1, typeof(string));
            dt.PrimaryKey = new DataColumn[] { dt.Columns[this.Field2] };

            DataTable dtSource = MyCommon.GetDt(
                string.Format("SELECT {0},{1} FROM {2}", this.Field1, this.Field2, this.TableName)
                , this.ConStr);
            for (int i = 0; i < dtSource.Rows.Count; i++)
            {
                DataRow drSource = dtSource.Rows[i];
                string[] strs = drSource[this.Field2].ToString().Split('|');
                for (int j = 0; j < strs.Length; j++)
                {

                    DataRow drNew = dt.Rows.Find(strs[j]);
                    if (null != drNew)
                    {
                        drNew[this.Field1] = drNew[this.Field1].ToString() + "," + drSource[this.Field1];
                    }
                    else
                    {
                        drNew = dt.NewRow();
                        drNew[this.Field2] = strs[j];
                        drNew[this.Field1] = drSource[this.Field1];
                        dt.Rows.Add(drNew);
                    }
                }
            }

            if (!string.IsNullOrEmpty(disp1)) dt.Columns[this.Field1].Caption = disp1;
            if (!string.IsNullOrEmpty(disp2)) dt.Columns[this.Field2].Caption = disp2;


            return dt;
        }

    }