合并单元格

 1     #region 合并单元格 合并某一列2行
 2     /// <summary>
 3     /// 合并GridView中2列相同信息的行（单元格）
 4     /// </summary>
 5     /// <param name="GridView1"></param>
 6     /// <param name="cols"></param>
 7      public static void GroupCol(GridView GridView1, int cols)
 8     {
 9         if (GridView1.Rows.Count < 1 || cols > GridView1.Rows[0].Cells.Count - 1)
10         {
11             return;
12         }
13         //判断奇数偶数
14          int count;
15         if (GridView1.Rows.Count % 2 == 0)
16         {
17             count = GridView1.Rows.Count;
18         }
19         else
20         {
21             count = GridView1.Rows.Count-1;
22         }
23         //2行并作1行
24          for (int i = 0; i < count; i = i + 2)
25         {
26             TableCell oldTc = GridView1.Rows[i].Cells[cols];
27             TableCell tc = GridView1.Rows[i+1].Cells[cols];
28             tc.Visible = false;
29             oldTc.RowSpan = 2;
30             oldTc.VerticalAlign = VerticalAlign.Middle;
31         }
32     }
33     #endregion

 1     //删除时一并删除2行
 2      protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
 3     {
 4         int i = e.RowIndex;
 5         string s1, s2, strSql;
 6         if (i + 1 < GridView1.Rows.Count)
 7         {
 8             s1 = this.GridView1.Rows[i].Cells[1].Text.ToString();
 9             s2 = this.GridView1.Rows[i + 1].Cells[1].Text.ToString();
10             strSql = "delete from Page where No='" + s1 + "' Or No='" + s2 + "'";
11         }
12         else
13         {
14             s1 = this.GridView1.Rows[i].Cells[1].Text.ToString();
15             strSql = "delete from Page where No='" + s1 + "'";
16         }
17         SqlConnection sqlcon=new SqlConnection("Data Source=(local);Initial Catalog=peter;Integrated Security=true");
18         sqlcon.Open();
19         SqlCommand sqlcom=new SqlCommand(strSql,sqlcon);
20         sqlcom.ExecuteNonQuery();
21         sqlcon.Close();
22         BindGridView();
23     }

 1     //绑定数据
 2     private void BindGridView()
 3     {
 4         SqlConnection sqlcon = new SqlConnection("Data Source=(local);Initial Catalog=peter;Integrated Security=true");
 5         string strsql = "select * from page";
 6         SqlDataAdapter dp = new SqlDataAdapter(strsql, sqlcon);
 7         sqlcon.Open();
 8         DataSet ds = new DataSet();
 9         dp.Fill(ds, "Delete");
10         this.GridView1.DataSource = ds;
11         this.GridView1.DataBind();
12         sqlcon.Close();
13         GroupCol(this.GridView1, 0);
14     }