asp.net后台代码填充前台数据实例

.aspx代码如下:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default12.aspx.cs" Inherits="Default12" %>

<!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;}
        #tbl_summary td,#tbl_summary th
            { padding:10px; border:1px solid silver;}
            td span
                { margin:10px;}
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Table ID="tbl_summary" runat="server">
            <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.OleDb;

public partial class Default12 : System.Web.UI.Page
{    string str_cnn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=";
    string str_sourcefile = "mdb\\mydb.mdb";
    OleDbConnection cnn;
    OleDbCommand cmd;
    OleDbDataReader datar;
    string str_sql;
    protected void Page_Load(object sender, EventArgs e)
    {
        //构建表
        //【语文】不及格,【语文】优秀,【数学】不及格,【数学】优秀
        //[Good]_cj_yuwen,[Fail]_cj_yuwen,[Good]_cj_shuxue,[Fail]_cj_shuxue
        string[] _sarr1 = { "Good", "Fail" };
        string[] _sarr2 = { "优秀", "不及格" };
        string[] _sarr_km = { "cj_yuwen", "cj_shuxue", "cj_huaxue", "cj_wuli", "cj_yingyu" };
        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);
        }

        

        string str_conn = str_cnn + MapPath(str_sourcefile);
        cnn = new OleDbConnection(str_conn);
        cnn.Open();

        str_sql = "SELECT * FROM tb_chenji";
        cmd = new OleDbCommand(str_sql, cnn);
        datar = cmd.ExecuteReader();

        Label lab_name;
        Single _f;

        while (datar.Read()) {
            //lab_name = new Label(); lab_name.Text = datar["cj_name"].ToString();
            foreach (string _skm in _sarr_km) {
                _f = Convert.ToSingle(datar[_skm].ToString());//<strong><em>_skm既作为变量名又作为构建ID的因子,这种方法很重要</em></strong>
                if (_f < 60) {
                    lab_name = new Label(); lab_name.Text = datar["cj_name"].ToString();
                    _td = (TableCell)FindControl("Fail" + _skm);
                    _td.Controls.Add(lab_name);

                }
                if (_f > 85)
                {
                    lab_name = new Label(); lab_name.Text = datar["cj_name"].ToString();
                    _td = (TableCell)FindControl("Good" + _skm);
                    _td.Controls.Add(lab_name);

                }
                
            }

        
        }

        cnn.Close();
    }
}

效果如下:


评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值