net实验报告.doc

一、实验目的：1掌握NET程序设计方法。2理解并运行C#语言操作语言。3. 掌握Gridview,DetailView,SqlDatasource,SqlDatareader等控件。4. 培养学生独立学习思索以及组织管理能力二、实验内容：1对建立电子商务网站需要使用的技术，工具进行分析。2对购物网站前后台操作过程中所使用的知识点进行分析。3书写整个数据库资料表字段的含义及数据类型。4画出购物车流程图三、软件运行截图：1.软件名称：Visual Studio 20052.软件名称：SQL Server 2000（1）企业管理器：（2）查询分析器：四、软件设计文档，代码及对代码进行说明：1、数据库的建立（企业管理器、查询分析器） 2、网站代码截图：1）登陆页面：Login.aspx代码： 登錄 登錄 用戶名:* 密碼:* Login.aspx.cs代码：public partial class Login : System.Web.UI.Page private string uid; private string pwd; private clsUser cUser = new clsUser(); protected void Page_Load(object sender, EventArgs e) protected void Button2_Click(object sender, EventArgs e) string url = Request.QueryStringurl; uid = UserName.Text.Trim(); pwd = Password.Text.Trim(); if (string.IsNullOrEmpty(url) url=Manage_Users.aspx; clsUser.UserLoginValid(uid, pwd, url); 界面截图：2）用户注销页面：Logout.aspx代码：内容为空Logout.aspx.cs代码：public partial class admin_Logout : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) Sessionuser = null; Session.Abandon(); Response.Redirect(login.aspx); 界面截图：3）用户管理页面：ManagerUser.aspx代码：asp:SqlDataSource ID=SqlDataSourceUsers runat=server ConnectionString=DeleteCommand=DELETE FROM t_user WHERE (userid = userid) SelectCommand=SELECT * FROM t_userasp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString=InsertCommand=INSERT INTO t_user(userid, userpwd, username, roleid) VALUES (userid, userpwd, username, roleid)SelectCommand=SELECT userid, userpwd, username, roleid FROM t_user WHERE (userid = userid)UpdateCommand=UPDATE t_user SET userpwd = userpwd, username = username, roleid = roleid WHERE (userid = userid) ManagerUser.aspx.cs代码：public partial class admin_Manage_Users : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) string rolename = ; clsUser u = new clsUser(); u = (clsUser)HttpContext.Current.Sessionuser; if (u = null) Response.Write(你沒有登入！); Response.Redirect(Login.aspx?url= + Server.UrlEncode(Request.RawUrl); protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) DetailsView1.ChangeMode(DetailsViewMode.Edit); protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e) GridView1.SelectedIndex = -1; GridView1.DataBind(); protected void DetailsView1_ItemInserted(object sender, DetailsViewInsertedEventArgs e) GridView1.SelectedIndex = -1; GridView1.DataBind(); protected void DetailsView1_ItemUpdated(object sender, DetailsViewUpdatedEventArgs e) GridView1.SelectedIndex = -1; GridView1.DataBind(); 设计界面截图：4）用户权限页面：UsersRight.aspx代码：asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString=DeleteCommand=DELETE FROM x_rightname WHERE (roleid = roleid) SelectCommand=SELECT * FROM x_rightname  asp:SqlDataSource ID=SqlDataSource2 runat=server ConnectionString=InsertCommand=INSERT INTO x_rightname(rolename, rolenamech) VALUES (rolename, rolenamech)SelectCommand=SELECT roleid, rolename, rolenamech FROM x_rightname WHERE (roleid = roleid)UpdateCommand=UPDATE x_rightname SET rolename = rolename, rolenamech = rolenamech UsersRight.aspx.cs代码：同上界面截图：5）新闻种类网页：ManagerArticles.aspx代码 asp:SqlDataSource ID=SqlDataSourceArticletypes runat=server ConnectionString= DeleteCommand=delete ArticleTypes where id=id SelectCommand=SELECT ID, TheName, Description FROM ArticleTypes asp:SqlDataSource ID=SqlDataSourceArticletype runat=server ConnectionString=InsertCommand=INSERT INTO ArticleTypes(TheName, Description) VALUES (TheName, Description)SelectCommand=SELECT ID, TheName, Description FROM ArticleTypes WHERE (ID = ID)UpdateCommand=UPDATE ArticleTypes SET TheName = TheName, Description = Description WHERE (ID = id) ManagerArticles.aspx.cs代码：同上设计界面截图：运行界面截图：6）新闻小类网页：代码：新闻大类：请选择asp:SqlDataSource ID=SqlDataSourceArticleCategories runat=serverConnectionString= SelectCommand=SELECT ID, TheName FROM ArticleTypesasp:SqlDataSource ID=SqlDataSourceArticleCategory runat=server ConnectionString=DeleteCommand=DELETE FROM ArticleCategories WHERE (CategoryID = categoryid)SelectCommand=SELECT ArticleCategories.CategoryID, ArticleCategories.Title, ArticleCategories.Description, ArticleCategories.TypeId, ArticleTypes.TheName FROM ArticleCategories INNER JOIN ArticleTypes ON ArticleCategories.TypeId = ArticleTypes.ID WHERE (ArticleCategories.TypeId = TypeId)asp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString=InsertCommand=INSERT INTO ArticleCategories(Title, Description, TypeId) VALUES (Title, Description, TypeId)SelectCommand=SELECT C