“步步精心”——三层架构下GridView控件实现增删改查

第一步：建立三层，并添加他们之间的引用关系，如下图所示：

第二步：添加GridView表格，并且套用格式样式，如下图所示：

第三步：点击表格右侧的小三角，并选中编辑列，如下图所示：

第四步：添加三个绑定列，并为其绑定上数据，如下图所示：

并且修改命令列的名称为“管理”，做好之后如下图所示：

下面是源代码的整体架构

接下来是所有的源代码：

DiaryModels层的Users

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using DiaryModels;using DiaryBLL;public partial class _Default : System.Web.UI.Page{    UserManager usermgr = new UserManager();    Users user = new Users();        //为表格绑定数据源    private void Bind() {        GridView1.DataSource = usermgr.Select();        GridView1.DataBind();    }    protected void Page_Load(object sender, EventArgs e)    {        if (!IsPostBack) {            Bind();        }    }    //添加用户信息    protected void btnOk_Click(object sender, EventArgs e)    {        user.UserID = Convert.ToInt16( txtUserID.Text);        user.UserName = txtUserName.Text;        user.password = txtPassword.Text;        if (usermgr.Add(user))        {            Response.Write("<script>('添加成功！')</script>");            Bind();        }        else {            Response.Write("<script>('添加失败！')</script>");        }            }    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)    {        user.UserID = Convert.ToInt16(((GridView1.Rows[e.RowIndex].FindControl("Label1") as Label).Text));        if (usermgr.Delete(user))        {            Response.Write("<script>('删除成功！')</script>");            Bind();        }        else {            Response.Write("<script>('删除失败！')</script>");        }    }//让当前行处于修改状态    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)    {        GridView1.EditIndex = e.NewEditIndex;        Bind();    }    //取消编辑    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)    {        GridView1.EditIndex = -1;        Bind();    }    //更新至数据库    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)    {        user.UserID = Convert.ToInt16((GridView1.Rows[e.RowIndex].FindControl("Label1")as Label).Text);        user.UserName = (GridView1.Rows[e.RowIndex].FindControl("TextBox2") as TextBox).Text;        user.password = (GridView1.Rows[e.RowIndex].FindControl("TextBox3") as TextBox).Text;        if (usermgr.Modify(user))        {            Response.Write("<script>('修改成功！')</script>");            GridView1.EditIndex = -1;            Bind();        }        else {            Response.Write("<script>('修改失败！')</script>");        }    }}

3楼lmdcszh昨天 08:02

又见三层啊

2楼lfmilaoshi前天 19:30

文尾，要是有个总结陈词，就是画龙点睛了。。。米老师

Re: wangboxian昨天 22:21

回复lfmilaoshin嗯，下次注意，米老师

1楼lilongsheng11253天前 16:21

很好，学习

Re: wangboxian前天 19:15

回复lilongsheng1125n常来啊