寻高手解决GridView和SQL语句问题～～

Question

这是有点难度   好像得拼了
不用GridView 自己拼Table吧

Answer 1

private void GroupRow()
{
int i, j, spanCount;
string value;
for (i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
spanCount = 1;
value = row.Cells[0].Text.Trim();
for (j = i + 1; j < GridView1.Rows.Count; j++)
{
if (GridView1.Rows[j].Cells[0].Text.Trim() == value)
{
spanCount++;
GridView1.Rows[i].Cells[0].RowSpan = spanCount;
GridView1.Rows[i].Cells[1].RowSpan = spanCount;
GridView1.Rows[j].Cells[0].Visible = false;
GridView1.Rows[j].Cells[1].Visible = false;
}
else
{
break;
}
}
i = j - 1;
}
}