主页:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" %>
成绩管理-51aspx.com
后台代码
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void imgbtn_Stu_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("Student/StudentLogin.aspx");
}
}
学生登录页面
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="StudentLogin.aspx.cs"
Inherits="Student_StudentLogin" %>
无标题页3
后台代码
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class Student_StudentLogin : System.Web.UI.Page
{
SQLHelper sqlhelper = new SQLHelper();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
if (this.tbx_name.Text.IndexOf("'") > 0 || this.tbx_name.Text.IndexOf("-") > 0)
{
this.Label_Msg.Text = "用户名中有非法字";
return;
}
Login lgn = new Login();
if (lgn.StudentLogin(tbx_sn.Text, tbx_name.Text, tbx_pwd1.Text) != null)
{
Session["sn"] = tbx_sn.Text;
Session["sname"] = tbx_name.Text;
Session["pwd"] = tbx_pwd1.Text;
Response.Redirect("StudentIndex.aspx");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "MyScript", "");
}
}
}
学生信息
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Student_info.aspx.cs"
Inherits="Student_Student_info" %>
无标题页3
后台代码
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class Student_Student_info : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SQLHelper sql = new SQLHelper();
DataSet dt = new DataSet();
sql.RunSQL("select * from Student where sn='" + Session["sn"].ToString() + "'", ref
dt);
}
}
this.lbl_sn.Text = dt.Tables[0].Rows[0]["sn"].ToString();
this.lbl_name.Text = dt.Tables[0].Rows[0]["sname"].ToString();
this.lbl_major.Text = dt.Tables[0].Rows[0]["major"].ToString();
this.lbl_dept.Text = dt.Tables[0].Rows[0]["dept"].ToString();
成绩查询
<%@ Page Language="C#" AutoEventWireup="true" Theme="Staff" CodeFile="Score.aspx.cs"
Inherits="Student_Score" %>
无标题页3
后台代码
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class Student_Score : System.Web.UI.Page
{
SQLHelper sql = new SQLHelper();
DataSet dt = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
sql.RunSQL("select * from Grade where sn='" + Session["sn"].ToString()+"'", ref dt);
GridView1.DataSource = dt.Tables[0];
GridView1.DataBind();
}