在gridview中使用linkbutton实现禁止启动操作。

 

 

1，利用gridview中使用linkbutton实现禁止操作，先给图吧，有图好说话

 

 

效果如图：

 

 

我的设计思路是：当单击禁用按钮是，文本变启动。同时是数据库中的字段enable的值改变。（根据需要而定）

 

 

 

前台代码：如下：

 

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="UserManage.ascx.cs" Inherits="adminmanage" %> <table style="margin:40px; width: 421px;" > <tr> <td colspan="3"> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="User_id" OnRowEditing="GridView1_OnRowCommand" OnRowCancelingEdit="GridView1_OnCancelCommand"　 OnRowDataBound="　　GridView1_RowDataBound" 　OnRowUpdating="GridView1_OnUpdateCommand" 　AllowPaging="True" OnPageIndexChanging="GridView1_PageIndexChanging" style="z-index: 100;" mce_style="z-index: 100;" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal" OnRowDeleted="GridView1_RowDeleted" OnRowCommand="GridView1_RowCommand" PageSize="5" Width="418px" onselectedindexchanged="GridView1_SelectedIndexChanged" > <Columns> <asp:TemplateField HeaderText="编号"> <ItemTemplate> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="用户名"　 > <ItemTemplate > <%# Eval("User_name") %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="密码"> <ItemTemplate > <%# Eval("User_password") %> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="txtUser_password" runat="server" Text=' <%# Eval("User_password") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="密码不能为空" ControlToValidate="txtUser_password"></asp:RequiredFieldValidator> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="编辑"> <ItemTemplate> <asp:ImageButton ID="ImageButton1" runat="server" CommandName="Edit" ImageUrl="~/Back-end/anmin_manage/image/Edit.jpg" BorderWidth="0 " ImageAlign="AbsMiddle"/> </ItemTemplate> <EditItemTemplate> <asp:ImageButton ID="ImageButton3" runat="server" CommandName="Update" ImageUrl="~/Back-end/anmin_manage/image/updateArticle.png" BorderWidth="0 " ImageAlign="AbsMiddle"/> <asp:ImageButton ID="ImageButton4" runat="server" CommandName="Cancel" ImageUrl="~/Back-end/anmin_manage/image/Cancel.jpg" BorderWidth="0 " ImageAlign="AbsMiddle"/> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="禁/启"> <ItemTemplate> <asp:LinkButton ID="LBenable" runat="server" CommandName="lbenable" CommandArgument='<%# DataBinder.Eval(Container,"RowIndex") %>'>启用</asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" /> <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" /> <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" /> <PagerTemplate> <asp:Label ID="lblPage" runat="server" Text='<%# "第" + (((GridView)Container.NamingContainer).PageIndex + 1) + "页/共" + (((GridView)Container.NamingContainer).PageCount) + "页" %> '></asp:Label> <asp:LinkButton ID="lbnFirst" runat="Server" Text="首页" Enabled='<%# ((GridView)Container.NamingContainer).PageIndex != 0 %>' CommandName="Page" CommandArgument="First" ></asp:LinkButton> <asp:LinkButton ID="lbnPrev" runat="server" Text="上一页" Enabled='<%# ((GridView)Container.NamingContainer).PageIndex != 0 %>' CommandName="Page" CommandArgument="Prev" ></asp:LinkButton> <asp:LinkButton ID="lbnNext" runat="Server" Text="下一页" Enabled='<%# ((GridView)Container.NamingContainer).PageIndex != (((GridView)Container.NamingContainer).PageCount - 1) %>' CommandName="Page" CommandArgument="Next" ></asp:LinkButton> <asp:LinkButton ID="lbnLast" runat="Server" Text="尾页" Enabled='<%# ((GridView)Container.NamingContainer).PageIndex != (((GridView)Container.NamingContainer).PageCount - 1) %>' CommandName="Page" CommandArgument="Last" ></asp:LinkButton> 到第<asp:TextBox runat="server" ID="inPageNum"></asp:TextBox>页 <asp:ImageButton ID="ImageButton5" runat="server" CommandName="go" Text="GO" ImageUrl="~/Back-end/anmin_manage/image/go.gif"/> <%--<asp:Button ID="Button1" runat="server" Text="GO" /> --%> <br /> </PagerTemplate> <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" /> <HeaderStyle BackColor="#296fc4" Font-Bold="True" ForeColor="#F7F7F7" /> <AlternatingRowStyle BackColor="#F7F7F7" /> </asp:GridView> </td> </tr> </table> <br />

 

 

 

 

 

 

后台代码涉及到初始化和设置这两方面：

 

初始化代码;

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { 鼠标经过时，行背景色变 e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E6F5FA'"); 鼠标移出时，行背景色变 e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'"); 当有编辑列时，避免出错，要加的RowState判断 //if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) //{ // ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除：/"" + e.Row.Cells[1].Text + "/"吗?')"); //} } if (e.Row.RowIndex != -1) { int id = e.Row.RowIndex + 1; e.Row.Cells[0].Text = id.ToString(); } //初始化LBTest的Text的值 LinkButton lb = (LinkButton)e.Row.FindControl("LBenable"); if (lb != null) { string strUserID = GridView1.DataKeys[e.Row.DataItemIndex%5].Value.ToString(); DataSet ds = objBaseDb.getdatabydataset("SELECT User_enable FROM Useinfo WHERE User_id =" + "'" + strUserID + "'"); string enable = ds.Tables[0].Rows[0][0].ToString(); if (enable == "0") lb.Text = "启用"; else lb.Text = "禁用"; } }

 

 

 

设置代码：

 

 

if (e.CommandName == "lbenable") { GridViewRow gvrow = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); //获取被点击的linkButton所在的GridViewRow int index = gvrow.RowIndex; //获取到行索引 RowIndex int intUserID = Convert.ToInt32(GridView1.DataKeys[index].Value.ToString()); int SelectedRowIndex = Convert.ToInt32(e.CommandArgument.ToString()); LinkButton lb = (LinkButton)GridView1.Rows[SelectedRowIndex].FindControl("LBenable"); if (lb.Text == "启用") { lb.Text = "禁用"; objBaseDb.UpdateUserEnable("1", intUserID ); } else { lb.Text = "启用"; objBaseDb.UpdateUserEnable("0", intUserID ); } } if (e.CommandName == "go") { try { TextBox tb = (TextBox)GridView1.BottomPagerRow.FindControl("inPageNum"); int num = Int32.Parse(tb.Text); GridViewPageEventArgs ea = new GridViewPageEventArgs(num - 1); GridView1_PageIndexChanging(null, ea); } catch { } } }

 

 

总结：这个功能终于实现了。皇天不负有心人。虽然过程很艰辛，但最后还是成功了，还是值得庆幸的。

           写这段程序让我认识到正确的坚持是多么宝贵，做每一件事都要持之以恒的去做。。

 

       因为我要实现这功能花了一段时间，所以比较辛苦，所以我将它拿出来共享，希望能帮助更多人。

 

我能实现这功能主要来自于此博：http://hi.baidu.com/sdwffzlll/blog/item/3d76d0083a5e4e34b0351dee.html