学生管理系统界面源代码

1、学 实 训 报 告 系部：信息技术系 课程名称：网站网页制作 专业班级：14计算机网络技术一班 姓名：xxx任课老师：xxx实验实训项目名称网站制作实验类型验证型实验室思科网络实验室实验时间实验方案设计（步骤）实验目的：1. 熟练掌握SQL语句的编写。2. 掌握使用VS2010对网页的设计。实验步骤：1. 登录页面主要代码：protectedvoid Button1_Click(object sender, EventArgs e) string username = TextBox1.Text;string password = TextBox2.Text;string connStr =

2、"server=(local);uid=sa;pwd=123456;database=StudentManager"SqlConnection conn = newSqlConnection(connStr);SqlCommand cmd = newSqlCommand("select * from UserInfo where username='" + username + "' and password='" + password + "'", conn); conn.Open

3、();SqlDataReader reader = cmd.ExecuteReader();/记?录?集if (reader.Read() Response.Redirect("main.aspx"); else Label1.Text = "用?户§名?或ò者?密ü码?错洙?误ó！?！?" conn.Close(); 2. 主页面+用户信息管理页面左侧主要运用了TreeView控件，然后用户信息运用了GridView控件，链接数据源，在页面中展示用户信息，主要代码：<asp:GridViewID="

4、;GridView1"runat="server"AllowPaging="True"AllowSorting="True"AutoGenerateColumns="False"DataKeyNames="Userid"DataSourceID="SqlDataSource1"style="font-family: 楷?体?; font-size: medium"Width="550px"BackColor="#DE

5、BA84"BorderColor="#DEBA84"BorderStyle="None"BorderWidth="1px"CellPadding="3"CellSpacing="2"><Columns><asp:BoundFieldDataField="Userid"HeaderText="序ò号?"ReadOnly="True"SortExpression="Userid"

6、;/><asp:BoundFieldDataField="UserName"HeaderText="用?户§名?"SortExpression="UserName"/><asp:BoundFieldDataField="Password"HeaderText="密ü码?"SortExpression="Password"/><asp:BoundFieldDataField="Email"HeaderT

7、ext="电?子哩?邮?件t"SortExpression="Email"/><asp:CommandFieldShowDeleteButton="True"ShowEditButton="True"/></Columns><FooterStyleBackColor="#F7DFB5"ForeColor="#8C4510"/><HeaderStyleBackColor="#A55129"Font-Bold=&

8、quot;True"ForeColor="White"/><PagerStyleForeColor="#8C4510"HorizontalAlign="Center"/><RowStyleBackColor="#FFF7E7"ForeColor="#8C4510"/><SelectedRowStyleBackColor="#738A9C"Font-Bold="True"ForeColor="White

9、"/><SortedAscendingCellStyleBackColor="#FFF1D4"/><SortedAscendingHeaderStyleBackColor="#B95C30"/><SortedDescendingCellStyleBackColor="#F1E5CE"/><SortedDescendingHeaderStyleBackColor="#93451F"/></asp:GridView><br/><

10、;asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:StudentManagerConnectionString %>"DeleteCommand="DELETE FROM UserInfo WHERE Userid = Userid"InsertCommand="INSERT INTO UserInfo (Userid, UserName, Password, E

11、mail) VALUES (Userid, UserName, Password, Email)"SelectCommand="SELECT * FROM UserInfo"UpdateCommand="UPDATE UserInfo SET UserName = UserName, Password = Password, Email = Email WHERE Userid = Userid">3. 学籍信息添加页面主要代码：protectedvoid Button1_Click(object sender, EventArgs e)

12、 string connStr = "server=(local);uid=sa;pwd=123456;database=StudentManager"SqlConnection conn = newSqlConnection(connStr);SqlCommand cmd = newSqlCommand("insert into StudentXj(Sno,Sname,Ssex,Sbrithday,DepartNo,ClassNo,Tel,Srxtime,xuezhi,xueli,address,youbian,zzmm,pingjia)values('

13、" + this.TextBox1.Text + "','" + this.TextBox2.Text + "','" + RadioButtonList1.Text + "','" + this.TextBox3.Text + "','" + this.TextBox12.Text + "','" + this.TextBox4.Text + "','" + this.

14、TextBox5.Text + "','" + this.TextBox6.Text + "','" + this.TextBox7.Text + "','" + this.TextBox8.Text + "','" + this.TextBox9.Text + "','" + this.TextBox10.Text + "','" + DropDownList1.Text + &

15、quot;','" + this.TextBox11.Text + "')", conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); 4. 学籍信息修改本页面也是用GridView控件，与数据库连接，展示出学籍信息，然后生成“修改”，单击“修改”方可进行修改，主要代码：<asp:GridViewID="GridView1"runat="server"AllowPaging="True"AllowSorting=&qu

16、ot;True"AutoGenerateColumns="False"BackColor="#DEBA84"BorderColor="#DEBA84"BorderStyle="None"BorderWidth="1px"CellPadding="3"CellSpacing="2"DataKeyNames="Sno"DataSourceID="SqlDataSource1"style="text-a

17、lign: center; font-family: 楷?体?; font-size: large; margin-top: 0px;"Width="1471px"><Columns><asp:BoundFieldDataField="Sno"HeaderText="Sno"ReadOnly="True"SortExpression="Sno"/><asp:BoundFieldDataField="Sname"HeaderText

18、="Sname"SortExpression="Sname"/><asp:BoundFieldDataField="Ssex"HeaderText="Ssex"SortExpression="Ssex"/><asp:BoundFieldDataField="Sbrithday"HeaderText="Sbrithday"SortExpression="Sbrithday"/><asp:BoundFie

19、ldDataField="DepartNo"HeaderText="DepartNo"SortExpression="DepartNo"/><asp:BoundFieldDataField="ClassNo"HeaderText="ClassNo"SortExpression="ClassNo"/><asp:BoundFieldDataField="Tel"HeaderText="Tel"SortExpressi

20、on="Tel"/><asp:BoundFieldDataField="Srxtime"HeaderText="Srxtime"SortExpression="Srxtime"/><asp:BoundFieldDataField="xuezhi"HeaderText="xuezhi"SortExpression="xuezhi"/><asp:BoundFieldDataField="xueli"Hea

21、derText="xueli"SortExpression="xueli"/><asp:BoundFieldDataField="address"HeaderText="address"SortExpression="address"/><asp:BoundFieldDataField="youbian"HeaderText="youbian"SortExpression="youbian"/><as

22、p:BoundFieldDataField="zzmm"HeaderText="zzmm"SortExpression="zzmm"/><asp:BoundFieldDataField="pingjia"HeaderText="pingjia"SortExpression="pingjia"/><asp:CommandFieldEditText="修T改?"ShowEditButton="True"/>&l

23、t;/Columns><FooterStyleBackColor="#F7DFB5"ForeColor="#8C4510"/><HeaderStyleBackColor="#A55129"Font-Bold="True"ForeColor="White"/><PagerStyleForeColor="#8C4510"HorizontalAlign="Center"/><RowStyleBackColor=&q

24、uot;#FFF7E7"ForeColor="#8C4510"/><SelectedRowStyleBackColor="#738A9C"Font-Bold="True"ForeColor="White"/><SortedAscendingCellStyleBackColor="#FFF1D4"/><SortedAscendingHeaderStyleBackColor="#B95C30"/><SortedDescen

25、dingCellStyleBackColor="#F1E5CE"/><SortedDescendingHeaderStyleBackColor="#93451F"/></asp:GridView><asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:StudentManagerConnectionString2 %>"De

26、leteCommand="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, a

27、ddress, 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, y

28、oubian = youbian, zzmm = zzmm, pingjia = pingjia WHERE Sno = Sno">5. 学籍信息查询 本页面运用GridView控件展示出学生信息，设置三种条件查询，按学号、姓名、系别方可查询出学生信息，主要代码：protectedvoid Page_Load(object sender, EventArgs e) string connStr = "server=(local);uid=sa;pwd=123456;database=StudentManager"SqlConnection conn = ne

29、wSqlConnection(connStr);SqlDataAdapter da = newSqlDataAdapter("select * from StudentXj", conn);DataSet ds = newDataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); protectedvoid Button1_Click(object sender, EventArgs e) string connStr = "server=(local);uid=sa;pwd=1

30、23456;database=StudentManager"SqlConnection conn = newSqlConnection(connStr);SqlDataAdapter da = newSqlDataAdapter("select * from StudentXj where Sno='" + this.TextBox1.Text + "' or Sname='" + this.TextBox2.Text + "' or DepartNo='" + this.TextBo

31、x3.Text + "'", conn);DataSet ds = newDataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); 6. 课程信息添加主要代码：protectedvoid Button1_Click(object sender, EventArgs e) string connStr = "server=(local);uid=sa;pwd=123456;database=StudentManager"SqlConnection conn =

32、newSqlConnection(connStr);SqlCommand cmd = newSqlCommand("insert into Course(Courseid,CourseName,Credit,Datetime)values('" + this.TextBox1.Text + "','" + this.TextBox2.Text + "','" + this.TextBox3.Text + "','" + this.TextBox4.Text +

33、 "')", conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Label1.Text = "添?加ó成é功|！?！?！?" 7. 课程信息修改 本页面运用了GridView控件，并启用了“修改”，单击修改方可实现修改功能，主要代码：<asp:GridViewID="GridView1"runat="server"AutoGenerateColumns="False"BackColor="

34、#DEBA84"BorderColor="#DEBA84"BorderStyle="None"BorderWidth="1px"CellPadding="3"CellSpacing="2"DataKeyNames="Courseid"DataSourceID="SqlDataSource1"style="text-align: center; font-family: 楷?体?; font-size: large;"Width

35、="630px"><Columns><asp:BoundFieldDataField="Courseid"HeaderText="课?程ì编括?号?"ReadOnly="True"SortExpression="Courseid"/><asp:BoundFieldDataField="CourseName"HeaderText="课?程ì名?称?"SortExpression="Course

36、Name"/><asp:BoundFieldDataField="Credit"HeaderText="学§分?"SortExpression="Credit"/><asp:BoundFieldDataField="Datetime"HeaderText="日?期ú"SortExpression="Datetime"/><asp:CommandFieldEditText="修T改?"Head

37、erText="修T改?"ShowEditButton="True"/></Columns><FooterStyleBackColor="#F7DFB5"ForeColor="#8C4510"/><HeaderStyleBackColor="#A55129"Font-Bold="True"ForeColor="White"/><PagerStyleForeColor="#8C4510"Ho

38、rizontalAlign="Center"/><RowStyleBackColor="#FFF7E7"ForeColor="#8C4510"/><SelectedRowStyleBackColor="#738A9C"Font-Bold="True"ForeColor="White"/><SortedAscendingCellStyleBackColor="#FFF1D4"/><SortedAscending

39、HeaderStyleBackColor="#B95C30"/><SortedDescendingCellStyleBackColor="#F1E5CE"/><SortedDescendingHeaderStyleBackColor="#93451F"/></asp:GridView></center><asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString=

40、"<%$ ConnectionStrings:StudentManagerConnectionString4 %>"DeleteCommand="DELETE FROM Course WHERE Courseid = Courseid"InsertCommand="INSERT INTO Course (Courseid, CourseName, Credit, Datetime) VALUES (Courseid, CourseName, Credit, Datetime)"SelectCommand="SEL

41、ECT * FROM Course"UpdateCommand="UPDATE Course SET CourseName = CourseName, Credit = Credit, Datetime = Datetime WHERE Courseid = Courseid">8. 课程信息查询 添加了GridView控件，使它与数据源连接，查询课程信息分三个条件，按课程编号、课程名称、日期方可查询，主要代码：protectedvoid Page_Load(object sender, EventArgs e) string connStr = "

42、;server=(local);uid=sa;pwd=123456;database=StudentManager"SqlConnection conn = newSqlConnection(connStr);SqlDataAdapter da = newSqlDataAdapter("select * from Course", conn);DataSet ds = newDataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); protectedvoid Button1_C

43、lick(object sender, EventArgs e) string connStr = "server=(local);uid=sa;pwd=123456;database=StudentManager"SqlConnection conn = newSqlConnection(connStr);SqlDataAdapter da = newSqlDataAdapter("select * from Course where Courseid='" + this.TextBox1.Text + "' or Cours

44、eName='" + this.TextBox2.Text + "' or Datetime='" + this.TextBox3.Text + "'", conn);DataSet ds = newDataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); 9. 课程信息删除主要代码：<asp:GridViewID="GridView1"runat="server"AllowPag

45、ing="True"AutoGenerateColumns="False"BackColor="#DEBA84"BorderColor="#DEBA84"BorderStyle="None"BorderWidth="1px"CellPadding="3"CellSpacing="2"DataKeyNames="Courseid"DataSourceID="SqlDataSource1"style=

46、"text-align: center; font-family: 楷?体?; font-size: large;"><Columns><asp:BoundFieldDataField="Courseid"HeaderText="Courseid"ReadOnly="True"SortExpression="Courseid"/><asp:BoundFieldDataField="CourseName"HeaderText="Co

47、urseName"SortExpression="CourseName"/><asp:BoundFieldDataField="Credit"HeaderText="Credit"SortExpression="Credit"/><asp:BoundFieldDataField="Datetime"HeaderText="Datetime"SortExpression="Datetime"/><asp:Comm

48、andFieldShowDeleteButton="True"/></Columns><FooterStyleBackColor="#F7DFB5"ForeColor="#8C4510"/><HeaderStyleBackColor="#A55129"Font-Bold="True"ForeColor="White"/><PagerStyleForeColor="#8C4510"HorizontalAlign

49、="Center"/><RowStyleBackColor="#FFF7E7"ForeColor="#8C4510"/><SelectedRowStyleBackColor="#738A9C"Font-Bold="True"ForeColor="White"/><SortedAscendingCellStyleBackColor="#FFF1D4"/><SortedAscendingHeaderStyleBa

50、ckColor="#B95C30"/><SortedDescendingCellStyleBackColor="#F1E5CE"/><SortedDescendingHeaderStyleBackColor="#93451F"/></asp:GridView></center><asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$

51、ConnectionStrings:StudentManagerConnectionString3 %>"DeleteCommand="DELETE FROM Course WHERE Courseid = Courseid"InsertCommand="INSERT INTO Course (Courseid, CourseName, Credit, Datetime) VALUES (Courseid, CourseName, Credit, Datetime)"SelectCommand="SELECT * FROM Co

52、urse"UpdateCommand="UPDATE Course SET CourseName = CourseName, Credit = Credit, Datetime = Datetime WHERE Courseid = Courseid"><DeleteParameters><asp:ParameterName="Courseid"Type="Int32"/></DeleteParameters>10. 学生成绩添加主要代码：protectedvoid Button1_

53、Click(object sender, EventArgs e) string connStr = "server=(local);uid=sa;pwd=123456;database=StudentManager"SqlConnection conn = newSqlConnection(connStr);SqlCommand cmd = newSqlCommand("insert into StudentCJ(Sno,Sname,CourseName,Score)values('" + this.TextBox1.Text + "

54、','" + this.TextBox2.Text + "','" + this.TextBox3.Text + "','" + this.TextBox4.Text + "')", conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Label1.Text = "添?加ó成é功|！?！?！?" 11. 学生成绩修改主要代码：<asp:GridViewID=&qu

55、ot;GridView1"runat="server"style="font-size: large; text-align: center;"AllowPaging="True"AutoGenerateColumns="False"BackColor="#DEBA84"BorderColor="#DEBA84"BorderStyle="None"BorderWidth="1px"CellPadding="3&quo

56、t;CellSpacing="2"DataKeyNames="Sno"DataSourceID="SqlDataSource1"Width="600px"><Columns><asp:BoundFieldDataField="Sno"HeaderText="Sno"ReadOnly="True"SortExpression="Sno"/><asp:BoundFieldDataField="S

57、name"HeaderText="Sname"SortExpression="Sname"/><asp:BoundFieldDataField="CourseName"HeaderText="CourseName"SortExpression="CourseName"/><asp:BoundFieldDataField="Score"HeaderText="Score"SortExpression="Score&

58、quot;/><asp:CommandFieldEditText="修T改?"ShowEditButton="True"/></Columns><FooterStyleBackColor="#F7DFB5"ForeColor="#8C4510"/><HeaderStyleBackColor="#A55129"Font-Bold="True"ForeColor="White"/><PagerStyl

59、eForeColor="#8C4510"HorizontalAlign="Center"/><RowStyleBackColor="#FFF7E7"ForeColor="#8C4510"/><SelectedRowStyleBackColor="#738A9C"Font-Bold="True"ForeColor="White"/><SortedAscendingCellStyleBackColor="#FFF1

60、D4"/><SortedAscendingHeaderStyleBackColor="#B95C30"/><SortedDescendingCellStyleBackColor="#F1E5CE"/><SortedDescendingHeaderStyleBackColor="#93451F"/></asp:GridView><asp:SqlDataSourceID="SqlDataSource1"runat="server"

61、ConnectionString="<%$ ConnectionStrings:StudentManagerConnectionString5 %>"DeleteCommand="DELETE FROM StudentCJ WHERE Sno = Sno"InsertCommand="INSERT INTO StudentCJ (Sno, Sname, CourseName, Score) VALUES (Sno, Sname, CourseName, Score)"SelectCommand="SELECT *

62、 FROM StudentCJ"UpdateCommand="UPDATE StudentCJ SET Sname = Sname, CourseName = CourseName, Score = Score WHERE Sno = Sno"><DeleteParameters><asp:ParameterName="Sno"Type="String"/></DeleteParameters>12. 学生成绩查询添加了GridView控件，使它与数据源连接，查询课程信息分三个条件，

63、按课程名称、学号、姓名方可查询，主要代码：protectedvoid Page_Load(object sender, EventArgs e) string connStr = "server=(local);uid=sa;pwd=123456;database=StudentManager"SqlConnection conn = newSqlConnection(connStr);SqlDataAdapter da = newSqlDataAdapter("select * from StudentCJ", conn);DataSet ds = n

64、ewDataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); protectedvoid Button2_Click(object sender, EventArgs e) string connStr = "server=(local);uid=sa;pwd=123456;database=StudentManager"SqlConnection conn = newSqlConnection(connStr);SqlDataAdapter da = newSqlDataAdapter

65、("select * from StudentCJ where CourseName='" + this.TextBox1.Text + "' or Sno='" + this.TextBox2.Text + "' or Sname='" + this.TextBox3.Text + "'", conn);DataSet ds = newDataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); 13. 学生成绩删除主要代码：<asp:GridViewID="GridView1"runat="server"AllowPaging="True"AutoGenerateColumns="False"BackColor="#DEBA84"BorderColor="#DEBA84"BorderStyle="None"BorderWidth="1px"CellPadding="3&q