学生信息管理系统 系统源代码.docx

1、学生信息管理系统 系统源代码系统源代码一、登录界面代码using System;using ;using ;using ;using ;using partial class login : protected void txtid_Click(object sender, EventArgs e) = ; = ; protected void Button1_Click(object sender, EventArgs e) string strconn = connStr; SqlConnection conn = new SqlConnection(strconn); (); DataS

2、et ds=new DataSet () ; SqlDataAdapter da = new SqlDataAdapter(select * from users where userid= + + and userpwd= + + , conn); (ds); if 0.=0) Label3 .Text =账号或密码错误，请重新输入！; else Session userid=txtid .Text ; Sessionuserpwd = ; Sessionusername = 0.Rows0username.ToString(); Sessionuserpower = 0.Rows0user

3、power.ToString(); if (Sessionuserpower.ToString () = 0) (admin/); else if (Sessionuserpower.ToString() = 1) (student/); else = 对不起，权限验证失败; (); (); 二、添加课程页面代码using System;using ;using ;using ;using ;using partial class addcourse : SqlCommand mycmd; SqlConnection conn; protected void Page_Load(object

4、sender, EventArgs e) onblur, checkcourseid(); string strconn = connStr; conn = new SqlConnection(strconn); protected void Button1_Click(object sender, EventArgs e) if = ) = 课程号不能为空; else string sqlstr = ; sqlstr = insert into course(courseid,coursename,coursetime,fen,type,teacher)values( + + , + + ,

5、 + + , + + , + + , + + ); (); mycmd = new SqlCommand(sqlstr, conn); (); try (); (javascript:alert(添加成功!);); catch (SqlException) (javascript:alert(添加失败!);); finally (); sqlstr = ; protected void Button2_Click(object sender, EventArgs e) = ; = ; = ; = ; = ; protected void Button3_Click(object sender,

6、 EventArgs e) (); 三、添加成绩程序代码using System;using ;using ;using ;using ;using partial class addscore : SqlCommand mycmd; SqlConnection conn; protected void Page_Load(object sender, EventArgs e) string strconn = connStr; conn = new SqlConnection(strconn); protected void Button1_Click(object sender, Even

7、tArgs e) if .ToString ()= ) = 学号不能为空; else string sqlstr = ; sqlstr = insert into score(userid,username,courseid,coursename,score,year)values( + + , + + , + + , + + , + + , + + ); (); mycmd = new SqlCommand(sqlstr, conn); (); try (); (javascript:alert(添加成功!);); catch (SqlException) (javascript:alert

8、(添加失败!);); finally (); sqlstr = ; protected void Button2_Click(object sender, EventArgs e) = ; = ; = ; = ; protected void Button3_Click(object sender, EventArgs e) (); protected void userid_SelectedIndexChanged(object sender, EventArgs e) string sqlstr = ; sqlstr = select username from students wher

9、e userid= + + ; (); mycmd = new SqlCommand(sqlstr, conn); (); SqlDataReader da; da = (); while () = dausername.ToString(); protected void txtcourseid_SelectedIndexChanged(object sender, EventArgs e) string sqlstr = ; sqlstr = select coursename from course where courseid= + + ; (); mycmd = new SqlCom

10、mand(sqlstr, conn); (); SqlDataReader da; da = (); while () = dacoursename.ToString(); 四、添加学生程序代码using System;using ;using ;using ;using ;using ;using ;using partial class addstudent : SqlCommand mycmd; protected void Page_Load(object sender, EventArgs e) onblur, checkuserid(); string strconn = conn

11、Str; SqlConnection conn = new SqlConnection(strconn); protected void Button1_Click(object sender, EventArgs e) if = ) return; string strconn = connStr; SqlConnection conn = new SqlConnection(strconn); string sqlstr = ; string sql = ; sqlstr = insert into students(userid,username,sex,minzu,birthday,c

12、lass,comefrom,beizhu,xuey,zhuany,tel,idc,zhengzmm,zhiw,huoj,weij)values( + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + ); (); mycmd = new SqlCommand(sqlstr, conn); (); string name = 获取上传文件的名称 string type = () + 1);alue = wpath; (); oString(); string sq

13、l = select courseid from course where courseid= + nam + ; SqlCommand DBHelper; DBHelper = new SqlCommand(sql, conn); (); SqlDataReader dr = (); if () (该课程号已经存在，请换一个); else (该课程号可以使用); (); 六、检查学号唯一性程序代码using System;using ;using ;using ;using ;using partial class checkuser : protected void Page_Load(object sender, EventArgs e) = 0;