default.aspx.cs

学生成绩管理系统 利用ajax进行开发的一个简单的学生成绩管理系统。由于本人刚刚开始学习ajax

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{

    private SqlConnection conn = new SqlConnection();//数据库连接实例化   
    protected void Page_Load(object sender, EventArgs e)
    {
        Label1.Text = DateTime.Now.ToString();
        string myconn = ConfigurationManager.ConnectionStrings["student"].ConnectionString;
        conn.ConnectionString = myconn;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        String cond="";
        switch (DropDownList1.SelectedItem.ToString())
        { 
            case("优秀"):
                cond = "(总分  >= 180)";
                break;
            case("良好"):
                cond = "(总分 >= 140) and (总分 < 180)";
                break;
            case("及格"):
                cond = "(总分 >= 120) and (总分 <140)";
                break;
            case("不及格"):
                cond = "(总分 < 120)";
                break;
        }
        SqlDataAdapter adp = new SqlDataAdapter();
        adp.SelectCommand= new SqlCommand("select * from chengji where"+cond,conn);

        DataSet ds = new DataSet();
        adp.Fill(ds,"t1");
        GridView1.DataSource= ds.Tables["t1"].DefaultView;
        GridView1.DataBind();
    }
    /// <summary>
    /// 实现鼠标滑动效果
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#cccccc';");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c;");
        }

    }
}