GridView 相关

前端：

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        onrowcancelingedit="GridView1_RowCancelingEdit" 
        onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating" 
        DataKeyNames="UserId" onrowdeleting="GridView1_RowDeleting" Width="745px">
        <Columns>
            
            <asp:TemplateField HeaderText="角色">
                    <HeaderTemplate>
                        角色
                    </HeaderTemplate>
                    <ItemTemplate>
                        <asp:Label ID="lblRoleId" runat="server" Text=""><%#Eval("RoleId ")%></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="txtRoleId" runat="server" Text="" value='<%#Eval("RoleId ")%>'></asp:TextBox>
                    </EditItemTemplate>      
                </asp:TemplateField>
 </Columns>
 </asp:GridView>

<asp:ButtonField HeaderText="用户详情" Text="详情"  />

<asp:CommandField EditImageUrl="~/images/edit.gif" HeaderText="修改" 
                ShowEditButton="True" />
            <asp:CommandField DeleteImageUrl="~/images/delete.gif" HeaderText="删除" 
                ShowDeleteButton="True" />

后端：

manageBLL manage = new manageBLL();

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DataBinds();
            }
        }

public void DataBinds()
        {//显示
            GridView1.DataSource = manage.GetmanageALL();
            GridView1.DataBind();
            
        }

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {//查询
        int index = e.RowIndex;
        string RoleId = ((this.GridView1.Rows[index].FindControl("txtRoleId") as TextBox).Text).ToString(); 
        UserModel usermodel = new UserModel();
        usermodel.RoleId = RoleId;
        bool result =manage.Editmanage(RoleId);
            if (result)
            {
                this.GridView1.EditIndex = -1;
                DataBinds();
            }

 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {//删除
            int index = e.RowIndex;
            bool result = manage.Daletamanage(UserId);
            if (result)
            {
                GridView1.EditIndex = -1;
                DataBinds();
            }
        }

BLL：

using MyOfficeDAL;
using MyOfficeModel;
using System.Data.SqlClient;

manageDAL managedal = new manageDAL();

public List<UserModel> GetmanageALL() 
       {//查询
           SqlDataReader reader=managedal.GetmanageALL();
           List<UserModel>list=new List<UserModel> ();
           while(reader.Read())
           {
               UserModel user=new UserModel ();
               user.RoleId = (reader["RoleId"]).ToString(); ;
               list.Add(user);
           }
           return list;
       }

public bool Editmanage(string RoleId) 
       {//修改
           int i = managedal.Editmanage(RoleId);
           bool result = false;
           if (i>0)
           {
               result = true;
           }
           return result;
       }

public bool Daletamanage(string UserId) 
       {//删除
           int i = managedal.Daletamanage(UserId);
           bool result = false;
           if (i>0)
           {
               result = true;
           }
           return result;
       }

DAL：

using System.Data.SqlClient;

DBHelper db = new DBHelper();

public SqlDataReader GetmanageALL() 
       {//查询
           string sql = "select (select RoleName from RoleInfo where RoleId=stu.RoleId)as RoleId from UserInfo as stu";	//外键查询
           SqlDataReader reader = db.ExecuteReader(sql);
           return reader;
       }

public int Editmanage( string RoleId) 
       {//修改
           string sql = "update UserInfo set RoleId='" + RoleId + "' where RoleId='" + RoleId + "'";
           int i = db.ExecuteNonQuery(sql);
           return i;
       }

public int Daletamanage(string UserId) 
       {//删除
           string sql = "delete from UserInfo where RoleId='" + RoleId + "'";
           int i = db.ExecuteNonQuery(sql);
           return i;
       }
    }