asp.net--代码填充前台数据

最新推荐文章于 2020-12-13 16:31:19 发布

yayun0516

最新推荐文章于 2020-12-13 16:31:19 发布

阅读量1.3k

点赞数

分类专栏： asp.net 文章标签：数据 asp.net gridview sql2005 c#

本文链接：https://blog.csdn.net/yayun0516/article/details/41012065

版权

asp.net 专栏收录该内容

117 篇文章 7 订阅

订阅专栏

.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();
    }
    
}

运行效果如图：