学生管理系统(界面+源代码)

内蒙古信息工程系学 实 训 报 告 系部：信息技术系 课程名称：网站网页制作 专业班级：14计算机网络技术一班 姓名：xxx 任课老师：xxx实验实训项目名称网站制作实验类型验证型实验室思科网络实验室实验时间实验方案设计（步骤）实验目的：1. 熟练掌握SQL语句的编写。2. 掌握使用VS2010对网页的设计。实验步骤：1. 登录页面主要代码：protected void Button1_Click(object sender, EventArgs e) string username = TextBox1.Text; string password = TextBox2.Text; string connStr = server=(local);uid=sa;pwd=;database=StudentManager; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand(select * from UserInfo where username= + username + and password= + password + , conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader();/记?录?集 if (reader.Read() Response.Redirect(main.aspx); else Label1.Text = 用?户名?或者?密码?错洙?误！?！?; conn.Close(); 2. 主页面+用户信息管理页面左侧主要运用了TreeView控件，然后用户信息运用了GridView控件，链接数据源，在页面中展示用户信息，主要代码： asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString= DeleteCommand=DELETE FROM UserInfo WHERE Userid = Userid InsertCommand=INSERT INTO UserInfo (Userid, UserName, Password, Email) VALUES (Userid, UserName, Password, Email) SelectCommand=SELECT * FROM UserInfo UpdateCommand=UPDATE UserInfo SET UserName = UserName, Password = Password, Email = Email WHERE Userid = Userid3. 学籍信息添加页面主要代码：protected void Button1_Click(object sender, EventArgs e) string connStr = server=(local);uid=sa;pwd=;database=StudentManager; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand(insert into StudentXj(Sno,Sname,Ssex,Sbrithday,DepartNo,ClassNo,Tel,Srxtime,xuezhi,xueli,address,youbian,zzmm,pingjia)values( + this.TextBox1.Text + , + this.TextBox2.Text + , + RadioButtonList1.Text + , + this.TextBox3.Text + , + this.TextBox12.Text + , + this.TextBox4.Text + , + this.TextBox5.Text + , + this.TextBox6.Text + , + this.TextBox7.Text + , + this.TextBox8.Text + , + this.TextBox9.Text + , + this.TextBox10.Text + , + DropDownList1.Text + , + this.TextBox11.Text + ), conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); 4. 学籍信息修改本页面也是用GridView控件，与数据库连接，展示出学籍信息，然后生成“修改”，单击“修改”方可进行修改，主要代码： asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString= DeleteCommand=DELETE FROM StudentXj WHERE Sno = Sno InsertCommand=INSERT INTO StudentXj (Sno, Sname, Ssex, Sbrithday, DepartNo, ClassNo, Tel, Srxtime, xuezhi, xueli, address, youbian, zzmm, pingjia) VALUES (Sno, Sname, Ssex, Sbrithday, DepartNo, ClassNo, Tel, Srxtime, xuezhi, xueli, address, youbian, zzmm, pingjia) SelectCommand=SELECT * FROM StudentXj UpdateCommand=UPDATE StudentXj SET Sname = Sname, Ssex = Ssex, Sbrithday = Sbrithday, DepartNo = DepartNo, ClassNo = ClassNo, Tel = Tel, Srxtime = Srxtime, xuezhi = xuezhi, xueli = xueli, address = address, youbian = youbian, zzmm = zzmm, pingjia = pingjia WHERE Sno = Sno5. 学籍信息查询 本页面运用GridView控件展示出学生信息，设置三种条件查询，按学号、姓名、系别方可查询出学生信息，主要代码：protected void Page_Load(object sender, EventArgs e) string connStr = server=(local);uid=sa;pwd=;database=StudentManager; SqlConnection conn = new SqlConnection(connStr); SqlDataAdapter da = new SqlDataAdapter(select * from StudentXj, conn); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); protected void Button1_Click(object sender, EventArgs e) string connStr = server=(local);uid=sa;pwd=;database=StudentManager; SqlConnection conn = new SqlConnection(connStr); SqlDataAdapter da = new SqlDataAdapter(select * from StudentXj where Sno= + this.TextBox1.Text + or Sname= + this.TextBox2.Text + or DepartNo= + this.TextBox3.Text + , conn); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); 6. 课程信息添加主要代码： protected void Button1_Click(object sender, EventArgs e) string connStr = server=(local);uid=sa;pwd=;database=StudentManager; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand(insert into Course(Courseid,CourseName,Credit,Datetime)values( + this.TextBox1.Text + , + this.TextBox2.Text + , + this.TextBox3.Text + , + this.TextBox4.Text + ), conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Label1.Text = 添?加成功|！?！?！?; 7. 课程信息修改 本页面运用了GridView控件，并启用了“修改”，单击修改方可实现修改功能，主要代码： asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString= DeleteCommand=DELETE FROM Course WHERE Courseid = Courseid InsertCommand=INSERT INTO Course (Courseid, CourseName, Credit, Datetime) VALUES (Courseid, CourseName, Credit, Datetime) SelectCommand=SELECT * FROM Course UpdateCommand=UPDATE Course SET CourseName = CourseName, Credit = Credit, Datetime = Datetime WHERE Courseid = Courseid8. 课程信息查询 添加了GridView控件，使它与数据源连接，查询课程信息分三个条件，按课程编号、课程名称、日期方可查询，主要代码：protected void Page_Load(object sender, EventArgs e) string connStr = server=(local);uid=sa;pwd=;database=StudentManager; SqlConnection conn = new SqlConnection(connStr); SqlDataAdapter da = new SqlDataAdapter(select * from Course, conn); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); protected void Button1_Click(object sender, EventArgs e) string connStr = server=(local);uid=sa;pwd=;database=StudentManager; SqlConnection conn = new SqlConnection(connStr); SqlDataAdapter da = new SqlDataAdapter(select * from Course where Courseid= + this.TextBox1.Text + or CourseName= + this.TextBox2.Text + or Datetime= + this.TextBox3.Text + , conn); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); 9. 课程信息删除 主要代码： asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString= DeleteCommand=DELETE FROM Course WHERE Courseid = Courseid InsertCommand=INSERT INTO Course (Courseid, CourseName, Credit, Datetime) VALUES (Courseid, CourseName, Credit, Datetime) SelectCommand=SELECT * FROM Course UpdateCommand=UPDATE Course SET CourseName = CourseName, Credit = Credit, Datetime = Datetime WHERE Courseid = Courseid 10. 学生成绩添加主要代码： protected void Button1_Click(object sender, EventArgs e) string connStr = server=(local);uid=sa;pwd=;database=StudentManager; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand(insert into StudentCJ(Sno,Sname,CourseName,Score)values( + this.TextBox1.Text + , + this.TextBox2.Text + , + this.TextBox3.Text + , + this.TextBox4.Text + ), conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Label1.Text = 添?加成功|！?！?！?; 11. 学生成绩修改主要代码： asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString= DeleteCommand=DELETE FROM StudentCJ WHERE Sno = Sno InsertCommand=INSERT INTO StudentCJ (Sno, Sname, CourseName, Score) VALUES (Sno, Sname, CourseName, Score) SelectCommand=SELECT * FROM StudentCJ UpdateCommand=UPDATE StudentCJ SET Sname = Sname, CourseName = CourseName, Score = Score WHERE Sno = Sno 12. 学生成绩查询添加了GridView控件，使它与数据源连接，查询课程信息分三个条件，按课程名称、学号、姓名方可查询，主要代码： protected void Page_Load(object sender, EventArgs e) string connStr = server=(loca