asp.net---代码读取处理数据与JQuery控制

最新推荐文章于 2024-09-28 17:14:25 发布

yayun0516

最新推荐文章于 2024-09-28 17:14:25 发布

阅读量965

点赞数

分类专栏： asp.net 文章标签： jquery vs2010 asp.net

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

版权

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">
    <script src="files/jquery-1.8.3.js" type="text/javascript"></script>
    <title></title>
    <script type="text/javascript">
        $(document).ready(function () {
         $(".studentName+div").hide();//页面载入时就隐藏
            $(".studentName").click(function () {
                $(".studentName+div").hide();//隐藏
                $("+div", this).show(600);//this相邻层显示,600指的是毫秒，延迟600毫秒
            })
        });
    </script>
    <style type="text/css"><%--css控制样式--%>
    .studentName{ padding:5px; background-color:Green; cursor:pointer;}
    .studentName+div{ border-bottom:1px solid black; padding:10px;  background-color:Yellow;}<%--studentName+div指的是studentName相邻的层--%>
    .studentName+div span{ margin:10px;}
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div runat="server" id="div_itemholder">
    
    </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.Sql;
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)
    {
        conn = new SqlConnection(con);
        conn.Open();

        str_sql="SELECT *FROM 成绩";
        cmd = new SqlCommand(str_sql, conn);
        datar = cmd.ExecuteReader();

        Panel pnl_name;
        Panel pnl_fitems;
        Label lab_fitems,lab_name;

        while (datar.Read()) {
            Single[] arrf=new Single[5];
            arrf[0]=Convert .ToSingle(datar["语文"]);
            arrf[1]=Convert .ToSingle(datar["数学"]);
            arrf[2]=Convert .ToSingle(datar["物理"]);
            arrf[3]=Convert .ToSingle(datar["化学"]);
            arrf[4]=Convert .ToSingle(datar["英语"]);
            if (checkfen(arrf) == true) { continue; }//true退出while循环

            lab_name = new Label(); lab_name.Text = datar["姓名"].ToString();//Panel1用于存放namelabel
            pnl_name = new Panel(); pnl_name.CssClass = "studentName"; pnl_name.Controls.Add(lab_name);
            div_itemholder.Controls.Add(pnl_name);//将Panel1加入div

            pnl_fitems = new Panel();//panel2用于存放分数
            lab_fitems = new Label(); lab_fitems.Text = "语文：" + datar["语文"].ToString();
            pnl_fitems.Controls.Add(lab_fitems);
            lab_fitems = new Label(); lab_fitems.Text = "数学：" + datar["数学"].ToString();
            pnl_fitems.Controls.Add(lab_fitems);
            lab_fitems = new Label(); lab_fitems.Text = "物理：" + datar["物理"].ToString();
            pnl_fitems.Controls.Add(lab_fitems);
            lab_fitems = new Label(); lab_fitems.Text = "化学：" + datar["化学"].ToString();
            pnl_fitems.Controls.Add(lab_fitems);
            lab_fitems = new Label(); lab_fitems.Text = "英语：" + datar["英语"].ToString();
            pnl_fitems.Controls.Add(lab_fitems);

            div_itemholder.Controls.Add(pnl_fitems);//将Panel2存入div；
        
        }
        
        
        conn.Close();
    }
    protected Boolean checkfen(Single[] _arrf){
    Boolean _result=false;
        int count=0;
        foreach( Single _s in _arrf){
            if(_s<60){ count++;}
        }
        if(count>=2) _result=true;
        return _result;
    }
}

效果如图：