1、 and passWord= + value_passWord + ; /创建并打开Connection对象 SqlConnection con = new SqlConnection(strCon); con.Open(); /创建SqlCommand对象。 SqlCommand cmd = con.CreateCommand(); cmd.CommandText = strqry; /执行查询 SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read() /若找到该用户则返回其ID值 result = Convert.ToInt32(druse
2、rID.ToString(); else result = 0; /若未能找到该用户则result值设为0 return result; protected void btnLogin_Click(object sender, EventArgs e) /取得用户输入的用户名和密码 string userName = txtUserName.Text.ToString(); string passWord = txtPassword.Text.ToString(); /查看数据库中是否存在该用户名且密码正确 int chkResult = CheckUser(userName, passWor
3、d); if (0 = chkResult) /若不存在此用户 Response.Write(alert(用户名或密码错误!); else /若存在此用户 Session = chkResult; Response.Redirect(taskList.aspx(2)完成任务管理系统主界面的设计a)模板的设计% Master Language=C# AutoEventWireup=true CodeFile=MasterPage.master.cs Inherits=MasterPage %!DOCTYPE html PUBLIC -/W3C/DTD XHTML 1.0 Transitional
4、/EN http:/www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtml xmlns=/www.w3.org/1999/xhtml head id=Head1 runat=server 无标题页link href=App_Themes/SkinFile/StyleSheet.css rel=stylesheet type=text/css /headbodyform id=form1 table align=center style=width:550px;border:0trtdasp:Label ID=navigator Text=导航/
5、asp:Label/td/trtd style=border-right: #000000 1px solid; border-top: border-left: border-bottom: background-color: #dcdcdc; height: 24px;discription描述contentplaceholder id=ContentPlaceHolder1contentplaceholder/table/form/body/htmlb)GridView控件的设计GridView Width=100% ID=gridViewTask AutoGenerateColumns
6、=False OnRowDataBound=gridViewTask_RowDataBound DataKeyNames=id AllowPaging=True PageSize=5 DataSourceID=SqlDataSource1 OnSelectedIndexChanged=gridViewTask_SelectedIndexChanged OnRowEditing=grid_EditingColumnsBoundField DataField=taskName HeaderText=任务名称createTime创建时间 ReadOnly=taskStatus任务状态CommandF
7、ield HeaderText=编辑 ShowEditButton=选择 ShowSelectButton= SelectText=改变状态TemplateField HeaderText=删除 ShowHeader=ItemTemplateLinkButton ID=LinkButton1 OnClientClick=return confirm(确认要删除吗?) CausesValidation= CommandName=DeleteLinkButton/ItemTemplateTemplateField/ColumnsGridView(3)完成任务管理系统删除功能、更改任务状态功能、编辑
8、功能的设计(利用SqlDataSource控件)SqlDataSource ID= ConnectionString=%$ ConnectionStrings:TrainningDSN % SelectCommand=SELECT * FROM Task WHERE (userID = userID) ORDER BY taskName DeleteCommand=DELETE FROM Task WHERE (id = id) UpdateCommand=update Task set taskName=taskName where id=idSelectParametersSessionP
9、arameter Name= SessionField=userid Type=Int32/SelectParametersDeleteParametersParameter Name=/DeleteParametersUpdateParameters/UpdateParametersSqlDataSource(4)完成任务管理系统增加任务功能的设计public partial class taskAdd : string taskName; int userID; /获得用户名和任务名称 taskName = userID = Convert.ToInt32(Session if (!Pag
10、e.IsPostBack) Label1.Visible = false; Master.lblNavigator.Text = 任务管理 新建任务 Master.lblDiscrption.Text = 输入新任务名称创建任务 protected void btnCommit_Click(object sender, EventArgs e) int taskNameLength=txtTaskName.Text.Length; if (taskNameLength 10) Label1.Visible = true; return; taskName = txtTaskName.Text.
11、ToString(); /向数据库添加新任务 int result = AddTask(userID, taskName); /返回任务列表页 protected void btnReset_Click(object sender, EventArgs e) txtTaskName.Text = protected void btnBackToList_Click(object sender, EventArgs e) protected int AddTask(int value_userID, string value_taskName) /得到查询字符串insert into Task
12、(taskName,createTime,taskStatus,userID) values ( + value_taskName + , + DateTime.Now + 0 + value_userID + int result = cmd.ExecuteNonQuery();实训二 任务管理系统(ADO版)利用C#程序设计中学习到的ADO.NET技术,实现任务管理系统。 掌握ADO.NET技术的用法 分析ADO.NET技术的优缺点3、SqlDataSource的优缺点分析SqlDataSource 在使用的时候更加容易操作,他直接绑定的是数据库中的表。所以只要绑定好了,对该表的增删改查操
13、作对应的就完成了,快速开发的首选。但缺点是不可变通,整个程序功能被SqlDataSource 限制的死死的。并且还打乱了分层体系。4、实训内容完成任务管理系统增、删、改功能的设计public partial class taskList : 任务列表 这里列出了您创建的所有任务 GetTaskByUserID(userID); protected void GetTaskByUserID(int value_userID) string strCon =ConfigurationManager.ConnectionStringsselect * from Task where userID=
14、+ order by taskName /创建Connection对象 SqlConnection con= new SqlConnection(strCon); /创建SqlCommand方法一:使用Connection对象的CreateCommand方法来创建一个Command对象。 cmd.CommandText=strqry; /创建SqlCommand方法二:直接使用new 关键字来创建 /SqlCommand cmd = new SqlCommand(); /cmd.CommandText=strqry; /cmd.Connection=con; /创建SqlCommand方法三:
15、直接在new的时候带两个参数来创建 /SqlCommand cmd = new SqlCommand(strqry, con); /创建DataAdapter对象 SqlDataAdapter adp = new SqlDataAdapter(cmd); /创建DataSet对象 DataSet ds = new DataSet(); /填充DataSet对象,将其填充后的表命名task adp.Fill(ds, task /绑定数据对象 gridViewTask.DataSource = ds; gridViewTask.DataMember = gridViewTask.DataBind(
16、); protected void btnNewTask_Click(object sender, EventArgs e)taskAdd.aspx?taskName= protected void btnQuit_Click(object sender, EventArgs e) /清空session,返回到登录页面 Session.Abandon();login.aspx protected void gridViewTask_RowCreated(object sender, GridViewRowEventArgs e) if (e.Row.RowType = DataControlR
17、owType.DataRow) / 实例化三个操作按钮 LinkButton linkButtonEdit = (LinkButton)e.Row.FindControl(linkButtonEdit LinkButton linkButtonChange = (LinkButton)e.Row.FindControl(linkButtonChange LinkButton linkButtonDelete = (LinkButton)e.Row.FindControl(linkButtonDelete / 将该行行号作为操作按钮的命令参数 linkButtonEdit.CommandArgu
18、ment = e.Row.RowIndex.ToString(); linkButtonChange.CommandArgument = e.Row.RowIndex.ToString(); linkButtonDelete.CommandArgument = e.Row.RowIndex.ToString(); /为删除按钮添加onclick属性 linkButtonDelete.Attributes.Add(onclick, JavaScript:确定删除该任务? protected void gridViewTask_RowDataBound(object sender, GridVie
19、wRowEventArgs e) /改变状态的名称 Int32 iStatus = Convert.ToInt32(e.Row.Cells2.Text); if (iStatus = 0) e.Row.Cells2.Text = 未完成 e.Row.Cells2.Style.Add(colorred else已完成green protected void gridViewTask_RowCommand(object sender, GridViewCommandEventArgs e) int index = Convert.ToInt32(e.CommandArgument.ToString
20、(); if (e.CommandName = editTask) /编辑任务 int id = int.Parse(gridViewTask.DataKeysindex.Value.ToString().Trim(); string taskName = gridViewTask.Rowsindex.Cells0.Text.ToString(); = id; + taskName); else if (e.CommandName = changeStatus) /修改任务状态 int statusToChange; /将要修改为的任务状态值 string status=gridViewTask.Rowsindex.Cells2.Text.ToString(); if ( = status) statusToChange = 1; statusToChange = 0; int result = ChangeStatus(id , statusToChange);deleteTask) /删除任务 int id = int.Parse(gridViewTask.DataKeysindex.V
copyright@ 2008-2023 冰点文库 网站版权所有
经营许可证编号:鄂ICP备19020893号-2