<table border="1" cellspacing="0"> <tbody> <tr> <td>商品名稱</td> <td>價格(元)</td> <td>卡號</td> <td>密碼</td> <td>購買時間</td> </tr> <tr> <td rowspan="3">魔獸親情卡</td> <td>13</td> <td>1151111</td> <td>4444644</td> <td rowspan="3">2010.05.04</td> </tr> <tr> <td rowspan="2">12</td> <td>18111</td> <td>444434</td> </tr> <tr> <td>174111</td> <td>449634</td> </tr> <tr> <td>聯通IP電話卡</td> <td rowspan="2">30</td> <td>dfs55</td> <td>dfds66</td> <td>2010.05.10</td> </tr> <tr> <td>QQ充值卡</td> <td>asdf</td> <td>ssss</td> <td>2010.05.08</td> </tr> <tr> <td>魔力卡</td> <td>55</td> <td>dfd</td> <td>asd</td> <td rowspan="3">2010.03.12</td> </tr> <tr> <td>仙劍奇俠傳卡</td> <td rowspan="2">23</td> <td>dfs</td> <td>aaa</td> </tr> <tr> <td>跑跑卡丁車卡</td> <td>dddd</td> <td>sss</td> </tr> </tbody> </table> <p>使用GridView實現合并單元格效果!急，急</p>
1 回答
holdtom
TA貢獻1805條經驗 獲得超10個贊
自己機器上有個例子，主要應用的是“TableCell”。
GridView控件中自動求和、合并單元格和排序
1.前臺
<table align="center" border="1" cellpadding="0" cellspacing="0">
<tr>
<td style="font-size: 9pt; color: #ff0000; text-align: center; height: 16px;">
學生成績信息</td>
</tr>
<tr>
<td style="text-align: center">
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
CellPadding="4" Font-Size="9pt" ForeColor="#333333" OnSorting="GridView1_Sorting" OnRowDataBound="GridView1_RowDataBound">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="stuname" HeaderText="學生姓名" SortExpression="stuname">
<ControlStyle Font-Underline="False" />
</asp:BoundField>
<asp:BoundField DataField="stusex" HeaderText="學生性別" SortExpression="stusex">
<ControlStyle Font-Underline="False" />
</asp:BoundField>
<asp:BoundField DataField="which_lesson" HeaderText="考試科目" SortExpression="which_lesson">
<ControlStyle Font-Underline="False" />
</asp:BoundField>
<asp:BoundField DataField="taotiname" HeaderText="套題名稱" SortExpression="taotiname">
<ControlStyle Font-Underline="False" />
</asp:BoundField>
<asp:BoundField DataField="res_total" HeaderText="分數" SortExpression="res_total" />
</Columns>
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</td>
</tr>
<tr>
<td style="font-size: 9pt; text-align: center">
請輸入您要查找的學生姓名：<asp:TextBox ID="TextBox1" runat="server" Width="86px"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Font-Size="9pt" OnClick="Button1_Click" Text="查詢" /></td>
</tr>
</table>
2.后臺
SqlConnection sqlcon;
string strCon = "Data Source=(local);Database=db_04;Uid=sa;Pwd=";
private int sum = 0;//取指定列的數據和
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["SortOrder"] = "stuname";
ViewState["OrderDire"] = "ASC";
bind();
}
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
string sPage = e.SortExpression;
if (ViewState["SortOrder"].ToString() == sPage)
{
if (ViewState["OrderDire"].ToString() == "Desc")
ViewState["OrderDire"] = "ASC";
else
ViewState["OrderDire"] = "Desc";
}
else
{
ViewState["SortOrder"] = e.SortExpression;
}
bind();
}
public void bind()
{
string sqlstr = "select * from tb_StuResult";
sqlcon = new SqlConnection(strCon);
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
myda.Fill(myds, "tb_StuResult");
DataView view = myds.Tables["tb_StuResult"].DefaultView;
string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
view.Sort = sort;
GridView1.DataSource = view;
GridView1.DataBind();
GridView1.ShowFooter = false;
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowIndex >= 0)
{
sum += Convert.ToInt32(e.Row.Cells[4].Text);
}
else if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[1].Text = "總分為：";
e.Row.Cells[2].Text = sum.ToString();
e.Row.Cells[3].Text = "平均分為：";
e.Row.Cells[4].Text = ((int)(sum / GridView1.Rows.Count)).ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text != "")
{
GridView1.ShowFooter = true;
string sqlstr = "select * from tb_StuResult where stuname='" + TextBox1.Text.Trim() + "'";
sqlcon = new SqlConnection(strCon);
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
myda.Fill(myds, "tb_StuResult");
GridView1.DataSource = myds;
GridView1.DataBind();
gvRender();
}
else
{
Response.Write("<script>alert('請輸入要查詢的學生姓名')</script>");
}
}
private void gvRender()
{
if (GridView1.Rows.Count <= 1)
{
return;
}
for (int i = 0; i < GridView1.Columns.Count; i++)
{
TableCell oldtc = GridView1.Rows[0].Cells[i];
for (int j = 1; j < GridView1.Rows.Count; j++)
{
TableCell newtc = GridView1.Rows[j].Cells[i];
if (newtc.Text == oldtc.Text)
{
newtc.Visible = false;
if (oldtc.RowSpan == 0)
{
oldtc.RowSpan = 1;
oldtc.RowSpan = oldtc.RowSpan + 1;
oldtc.VerticalAlign = VerticalAlign.Middle;
}
else
{
oldtc = newtc;
}
}
}
}
}
- 1 回答
- 0 關注
- 468 瀏覽
添加回答
舉報
0/150
提交
取消