aspnet课设- 学生成绩管理系统

conn.Open();

SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) {

Session[\] = dr[\].ToString().Trim(); Session[\] = dr[\].ToString().Trim(); Response.Redirect(\); } else

l1.Text = \登陆失败!\; }

protected void btn1_Click(object sender, EventArgs e)//进入学生页 {

string name = (); string psw = ();

SqlConnection conn = new SqlConnection(\Security=SSPI;database=学生成绩管理;\);

SqlCommand cmd = new SqlCommand(\ + name + \ + psw + \, conn); DataSet ds = new DataSet(); conn.Open();

SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) {

Session[\] = dr[\].ToString().Trim(); Session[\] = dr[\].ToString().Trim(); Response.Redirect(\); } else

l1.Text = \登陆失败!\; } }

} 4.1.2 数据库连接

在Microsoft Visual Studio 2010软件中打开【视图】，选择【服务器资源管理器】，右击【数据连接】，选择【新建连接】，选择连接到Score_DataBase数据库。在网站下添加配置文件web.config，在文件中添加代码：

using ;

using System.Data; using ;

SqlConnection conn = new SqlConnection(\Security=SSPI;database=学生成绩管理;\)

4.2 网页编码实现

在Web_Exam网站下新建网页，并引用其中的母版页“Master.master”。 4.2.1 学生注册页面

图 学生注册页面

using System; using ;

using System.Linq; using System.Web; using ; using ;

using System.Data; using ; using ;

public partial class ogin : Page {

protected void Page_Load(object sender, EventArgs e) { }

protected void butsubmit_Click(object sender, EventArgs e) {

if(Page.IsValid) {

string name = (); string psw = (); string xuehao = (); string xingming = (); string xingbie = (); string banji = (); string zhuanye = (); string sfzh = (); string jia = (); string cssj = ();

string sql = \values(@username,@password,@xh,@xm,@xb,@Bj,@Zy,@Sfzh,@jtdz,@Rq)\;

SqlParameter[] parameters = { new SqlParameter(\,name), new SqlParameter(\,psw), new SqlParameter(\,xuehao), new SqlParameter(\,xingming), new SqlParameter(\,xingbie), new SqlParameter(\,banji), new SqlParameter(\,zhuanye), new SqlParameter(\,sfzh), new SqlParameter(\,jia), new SqlParameter(\,cssj) };

using (SqlConnection conn = new SqlConnection(\Security=SSPI;database=学生成绩管理;\)) {

conn.Open();

using (SqlCommand cmd = conn.CreateCommand())//tsql {

cmd.CommandText = sql; (parameters);

cmd.ExecuteNonQuery(); } }

Response.Write(@\注册成功！');\); } }

protected void btnback_Click(object sender, EventArgs e) {

Response.Redirect(\);//返回主界面 } }

4.2.2 老师注册页面

图 老师注册页面

using System; using ;

using System.Linq; using System.Web; using ; using ; using ; using ;

using System.Data;

public partial class loginfirst : Page

{

protected void Page_Load(object sender, EventArgs e) { }

protected void btnlogin_Click(object sender, EventArgs e) {

Response.Redirect(\);//进入学生注册页面 }

protected void btnlogin2_Click(object sender, EventArgs e) {

Response.Redirect(\);//进入教师注册页面 }

protected void btn2_Click(object sender, EventArgs e)//进入教师页 {

string name = (); string psw = ();

SqlConnection conn = new SqlConnection(\Security=SSPI;database=学生成绩管理;\);

SqlCommand cmd = new SqlCommand(\ + name + \ + psw + \, conn); DataSet ds = new DataSet(); conn.Open();

SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) {

Session[\] = dr[\].ToString().Trim(); Session[\] = dr[\].ToString().Trim(); Response.Redirect(\); } else

l1.Text = \登陆失败!\; }

protected void btn1_Click(object sender, EventArgs e)//进入学生页 {

string name = (); string psw = ();

SqlConnection conn = new SqlConnection(\Security=SSPI;database=学生成绩管理;\);

SqlCommand cmd = new SqlCommand(\ + name + \ + psw + \, conn); DataSet ds = new DataSet(); conn.Open();

SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read())

{

Session[\] = dr[\].ToString().Trim(); Session[\] = dr[\].ToString().Trim(); Response.Redirect(\); } else

l1.Text = \登陆失败!\;

} }

4.2.3学生学习修改页面

图 学生修改信息页面

using System; using ;

using System.Linq; using System.Web; using ; using ;

using System.Data;