DataGrid实现单元格合并

//填充DataGird

private void tableFill()
  {
   string strSql="select c.id,a.Content item ,b.Content from Assess_Item b left join (select * from Assess_Item where Grade=0) a on Left(RTrim(LTrim(b.ItemCode)),2)=a.ItemCode left join Assess_Relation c on c.ItemId=b.id where b.Grade=1 and c.PostTypeId=" + this.identityNo (this.peopleList .SelectedValue .Trim ()) + " order by a.Content";
   this.DataGridEx1 .DataSource =this.ExecuteReader (strSql,"ASOM");
   this.DataGridEx1 .DataBind ();
  }

//合并单元格

private void DataGridEx1_PreRender(object sender, System.EventArgs e)
  {
   int rowCount=this.DataGridEx1 .Items .Count ;
   int itemCount=0;
   int itemStart=0;
   for (int i=0;i<rowCount ;i++)
   {
    if(i==0)
     itemStart=0;
    else
    {
     string str1=this.DataGridEx1 .Items [i].Cells [1].Text .Trim ();
     string str2=this.DataGridEx1 .Items [itemStart].Cells [1].Text .Trim ();
     if(this.DataGridEx1 .Items [i].Cells [1].Text .Trim ()==this.DataGridEx1 .Items [itemStart].Cells [1].Text .Trim ())
     {
      itemCount+=1;
      this.DataGridEx1 .Items[i].Cells [1].Visible =false;
     }
     else
     {
        this.DataGridEx1 .Items [itemStart].Cells [1].RowSpan =itemCount+1;
        itemCount=0;
        itemStart=i;
     }
    }
   }

//如果取出的数据为空，不合并单元格
   if(rowCount>0)
       this.DataGridEx1 .Items [itemStart].Cells [1].RowSpan =itemCount+1;

  }