DataGridView (四)将一个字段绑定到多列逐行显示后取值还原数据格式

一下内容为绑定到4个字段的代码,方法哈了点,直接重新构建了一个数据源然后绑定的,不知道有没有更好的方法= =#

比较乱,演示个思路而已,随笔备忘

1.  DataSet ds = new DataSet();
               ds.ReadXml("d://a.xml");
               DataTable dt = ds.Tables[0];
               DataTable dtCur = new DataTable();
               DataColumn dc1 = new DataColumn("c1");
               DataColumn dc2 = new DataColumn("c2");
               DataColumn dc3 = new DataColumn("c3");
               DataColumn dc4 = new DataColumn("c4");
               DataColumn dca = new DataColumn("ca");
               DataColumn dcb = new DataColumn("cb");
               DataColumn dcc = new DataColumn("cc");
               DataColumn dcd = new DataColumn("cd");
               dtCur.Columns.Add(dc1);
               dtCur.Columns.Add(dca);
               dtCur.Columns.Add(dc2);
               dtCur.Columns.Add(dcb);
               dtCur.Columns.Add(dc3);
               dtCur.Columns.Add(dcc);
               dtCur.Columns.Add(dc4);
               dtCur.Columns.Add(dcd);
               DataRow drCur = dtCur.NewRow();
               for (int i = 0; i < dt.Rows.Count; i++)
               {
                   int x = i % 4;
2. 
                   switch (x)
                   {
                       case 0:
                           drCur[0] = dt.Rows[i][0].ToString();
                           drCur[1] = dt.Rows[i][1].ToString();
                           break;
                       case 1:
                           drCur[2] = dt.Rows[i][0].ToString();
                           drCur[3] = dt.Rows[i][1].ToString();
                           break;
                       case 2:
                           drCur[4] = dt.Rows[i][0].ToString();
                           drCur[5] = dt.Rows[i][1].ToString();
                           break;
                       case 3:
                           drCur[6] = dt.Rows[i][0].ToString();
                           drCur[7] = dt.Rows[i][1].ToString();
                           dtCur.Rows.Add(drCur);
                           drCur = dtCur.NewRow();
                           break;
                   }
                   if (i == dt.Rows.Count - 1 && x != 3)
                   {
                       dtCur.Rows.Add(drCur);
                   }
3.             }
              
            
             
               this.dataGridView1.DataSource = dtCur;

 

取值

 

2.             DataTable dt = new DataTable();
3.             DataColumn dc1 = new DataColumn("dc1");
4.             DataColumn dc2 = new DataColumn("dc2");
5.             dt.Columns.Add(dc1);
6.             dt.Columns.Add(dc2);
7.             DataRow ddr = dt.NewRow() ;
8.             foreach (DataGridViewRow dr in dataGridView1.Rows)
9.             {
10.                 for (int i = 0; i < 8; i++)
11.                 {
12.                     int x = i % 2;
13.                     switch (x)
14.                     {
15.                         case 0:
16.                             ddr = dt.NewRow();   
17.                             ddr[0] = dr.Cells[i].Value;
18.                             break;
19.                         case 1:
20.                             ddr[1] = dr.Cells[i].Value;
21.                             dt.Rows.Add(ddr);
22.                             break;
23.                     }
24.                 }
25.             }
26.             this.dataGridView2.DataSource = dt;