.aspx代码如下：
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="代码填充前台数据.aspx.cs" Inherits="代码填充前台数据" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
#tbl_summary{ border:1px solid black; text-align:center; width:500px;}
#tbl_summary td, #tbl_summary th{ padding:4px; border:1px solid green; }
td span{ margin:10px;}
.gridview{ text-align:center; margin-bottom:10px;}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<h2 style="text-align:center "> 成绩表</h2>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" CssClass="gridview" BackColor="White"
BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4"
GridLines="Horizontal" Width="500px" align="center" >
<Columns>
<asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
<asp:BoundField DataField="语文" HeaderText="语文" SortExpression="语文" />
<asp:BoundField DataField="数学" HeaderText="数学" SortExpression="数学" />
<asp:BoundField DataField="物理" HeaderText="物理" SortExpression="物理" />
<asp:BoundField DataField="化学" HeaderText="化学" SortExpression="化学" />
<asp:BoundField DataField="英语" HeaderText="英语" SortExpression="英语" />
</Columns>
<FooterStyle BackColor="White" ForeColor="#333333" />
<HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="White" ForeColor="#333333" />
<SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F7F7F7" />
<SortedAscendingHeaderStyle BackColor="#487575" />
<SortedDescendingCellStyle BackColor="#E5E5E5" />
<SortedDescendingHeaderStyle BackColor="#275353" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:userinfoConnectionString %>"
SelectCommand="SELECT * FROM [成绩]" ViewStateMode="Enabled"></asp:SqlDataSource>
<asp:Table ID="tbl_summary" runat="server" align="center">
<asp:TableHeaderRow>
<asp:TableHeaderCell ColumnSpan="4" >成绩汇总</asp:TableHeaderCell>
</asp:TableHeaderRow>
</asp:Table>
</div>
</form>
</body>
</html>
.aspx.cs代码如下：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class 代码填充前台数据 : System.Web.UI.Page
{
string con = "server=localhost\\SQL2005 ;uid=sa;pwd=1111qq;database=userinfo";
SqlConnection conn;
SqlCommand cmd;
SqlDataReader datar;
string str_sql;
protected void Page_Load(object sender, EventArgs e)
{
//构建表
//语文 不及格， 语文 优秀， 数学 不及格，数学 优秀
//[Good]_cj_yuwen,[Fail]_cj_yuwen,
string[] _sarr1 = { "Good","Fail"};
string[] _sarr2 = { "优秀","不及格"};
string[] _sarr_km = { "语文", "数学", "化学", "物理", "英语" };
string[] _sarr_kmname = { "语文","数学","化学","物理","英语"};
TableRow _tr; TableCell _td;
for (int i = 0; i < _sarr_km.Length; i++) {
_tr = new TableRow();//表格行
for (int j = 0; j < _sarr1.Length; j++) {
_td = new TableCell();//表格元素
_td.Text = _sarr_kmname[i] + _sarr2[j];
_tr.Cells.Add(_td);
_td = new TableCell();
_td.ID = _sarr1[j] + _sarr_km[i];
_tr.Cells.Add(_td);
}
tbl_summary.Rows.Add(_tr);
}
conn = new SqlConnection(con);
conn.Open();
str_sql = "SELECT *FROM 成绩";
cmd = new SqlCommand(str_sql, conn);
datar = cmd.ExecuteReader();
Label lab_name;
Single _f;
while (datar.Read()) {
//lab_name = new Label();
//lab_name.Text = datar["姓名"].ToString();
foreach (string _skm in _sarr_km) {
_f = Convert.ToSingle(datar[_skm].ToString());
if (_f < 60) {
lab_name = new Label();
lab_name.Text = datar["姓名"].ToString();
_td = (TableCell)FindControl("Fail" + _skm);//寻找ID为Fail+_skm
_td.Controls.Add(lab_name);//将Label存入寻找ID的TableCell中
}
if (_f > 85)
{
lab_name = new Label();
lab_name.Text = datar["姓名"].ToString();
_td = (TableCell)FindControl("Good" + _skm);
_td.Controls.Add(lab_name);
}
}
}
conn.Close();
}
}
运行效果如图：
