Asp.Mvc 2.0用户的编辑与删除实例讲解(5)_实用技巧_

 public ActionResult Index() { //查询出所有用户 DataSet ds = new Models.SqlHelper().GetAllUsers(); if (ds!=null&&ds.Tables[0].Rows.Count>0) { List lists = new List(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Models.UserModels model = new Models.UserModels(); model.UserName = ds.Tables[0].Rows[i]["UserName"].ToString(); model.UserPwd = ds.Tables[0].Rows[i]["UserPwd"].ToString(); model.Email = ds.Tables[0].Rows[i]["Email"].ToString(); lists.Add(model); } if (lists.Count>0) { ViewData["users"] = lists; } } return View(); } 

<%foreach (var item in (ViewData["users"] as IEnumerable) ) {%><% } %>
用户名
密码
邮箱
编辑
删除
<%:item.UserName %>
<%:item.UserPwd %>
<%:item.Email %>
编辑 <%:Html.ActionLink("编辑", "EditUser","user",new { userName=item.UserName},null)%>
<%:Html.ActionLink("删除", "DelUser", "user", new { userName=item.UserName},null)%>

 /// 
 /// 转向编辑页面 /// 
 ///  ///  public ActionResult EditUser(string userName) { //根据用户名获取用户信息 DataSet ds = new Models.SqlHelper().GetSingleUser(userName); if (ds != null && ds.Tables[0].Rows.Count > 0) { ViewData["username"] = ds.Tables[0].Rows[0]["username"].ToString(); ViewData["userPwd"] = ds.Tables[0].Rows[0]["userpwd"].ToString(); ViewData["email"] = ds.Tables[0].Rows[0]["email"].ToString(); return View("edituser"); } else { return View("error"); } } 

">
 修改用户信息 
 用户名：
" />
 密码：
"/>
 邮箱:
" />
<%if (ViewData["errMsg"] != null) {%><%:ViewData["errMsg"].ToString()%><%} %>

 [HttpPost] public ActionResult EditUser() { string userName = Request.QueryString["UserName"].ToString(); string userPwd = Request.Form["txtUserPwd"].ToString(); string email = Request.Form["txtemail"].ToString(); if (userName == "" || userPwd == "") { ViewData["errMsg"] = "用户名和密码不能为空"; return EditUser(userName); } else { //更新数据库 bool result=new Models.SqlHelper().UpdateUser(userName, userPwd, email); if (result) { //转向主页 DataSet ds = new Models.SqlHelper().GetAllUsers(); if (ds != null && ds.Tables[0].Rows.Count > 0) { List lists = new List(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Models.UserModels model = new Models.UserModels(); model.UserName = ds.Tables[0].Rows[i]["UserName"].ToString(); model.UserPwd = ds.Tables[0].Rows[i]["UserPwd"].ToString(); model.Email = ds.Tables[0].Rows[i]["Email"].ToString(); lists.Add(model); } if (lists.Count > 0) { ViewData["users"] = lists; } } return View("index"); } else { ViewData["errMsg"] = "更新失败"; return EditUser(userName); } } 

 /// 
 /// 删除用户 /// 
 ///  ///  public ActionResult DelUser(string userName) { bool result = new Models.SqlHelper().DelUser(userName); DataSet ds = new Models.SqlHelper().GetAllUsers(); if (ds != null && ds.Tables[0].Rows.Count > 0) { List lists = new List(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Models.UserModels model = new Models.UserModels(); model.UserName = ds.Tables[0].Rows[i]["UserName"].ToString(); model.UserPwd = ds.Tables[0].Rows[i]["UserPwd"].ToString(); model.Email = ds.Tables[0].Rows[i]["Email"].ToString(); lists.Add(model); } if (lists.Count > 0) { ViewData["users"] = lists; } } return View("index");