1、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=123456;database=StudentManager; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = n
2、ew 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控件,然后用户信
3、息运用了GridView控件,链接数据源,在页面中展示用户信息,主要代码: BoundField DataField= HeaderText=序号? ReadOnly= SortExpression= /UserNamePasswordEmail电?子哩?邮 ?件tCommandField ShowDeleteButton= ShowEditButton=/ColumnsFooterStyle BackColor=#F7DFB5 ForeColor=#8C4510HeaderStyle BackColor=#A55129 Font-Bold=WhitePagerStyle ForeColor=
4、 HorizontalAlign=CenterRowStyle BackColor=#FFF7E7SelectedRowStyle BackColor=#738A9CSortedAscendingCellStyle BackColor=#FFF1D4SortedAscendingHeaderStyle BackColor=#B95C30SortedDescendingCellStyle BackColor=#F1E5CESortedDescendingHeaderStyle BackColor=#93451F/asp:GridViewbr /SqlDataSource ID= Connecti
5、onString=%$ ConnectionStrings:StudentManagerConnectionString % 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
6、 SET UserName = UserName, Password = Password, Email = Email WHERE Userid = Userid3.学籍信息添加页面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.T
7、extBox3.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 + ) cmd.ExecuteNonQuery();4.学籍信息修改本页面也是用GridView控件,与数据
8、库连接,展示出学籍信息,然后生成“修改”,单击“修改”方可进行修改,主要代码:Snotext-align: center; font-family: large; margin-top: 0px;1471pxSnameSsexSbrithdayDepartNoClassNoTelSrxtimexuezhixueliaddressyoubianzzmmpingjiaCommandField EditText=修T改?StudentManagerConnectionString2 %DELETE FROM StudentXj WHERE Sno = SnoINSERT INTO StudentXj
9、 (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)SELECT * FROM StudentXjUPDATE StudentXj SET Sname = Sname, Ssex = Ssex,
10、 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(
11、object sender, EventArgs e) SqlDataAdapter da = new SqlDataAdapter(select * from StudentXj DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); protected void Button1_Click(object sender, EventArgs e)select * from StudentXj where Sno= or Sname= or DepartNo=6.课程信息添加insert into Course(Courseid,CourseName,Credit,Datetime)values(添 ?加成功|!7.课程信息修改 本页面运用了GridView控件,并启用了“修改”,单击修改方可实现修改功能,主要代码:Courseid630px课?程编括?CourseName称?Credit学分?Datetime日?期/centerStudentManagerConnectionString4 %DELETE FROM Course WHERE Courseid = CourseidINSERT INTO Cour