asp.net gridview绑定按钮事件

来源：互联网发布：欧派油烟机知乎编辑：程序博客网时间：2024/04/28 09:47

前台gridview

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="AccessDataSource1" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" Width="527px" DataKeyNames="id" OnRowCommand="GridView1_RowCommand"> <Columns> <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" SortExpression="id" /> <asp:BoundField DataField="bigname" HeaderText="bigname" SortExpression="bigname" /> <asp:BoundField DataField="smallname" HeaderText="smallname" SortExpression="smallname" /> <asp:BoundField DataField="href" HeaderText="href" SortExpression="href" /> <asp:BoundField DataField="tagname" HeaderText="tagname" SortExpression="tagname" /> <asp:BoundField DataField="sort" HeaderText="sort" SortExpression="sort" /> <asp:BoundField DataField="zt" HeaderText="zt" SortExpression="zt"> <HeaderStyle BorderColor="Red" /> </asp:BoundField> <asp:BoundField DataField="setadd" HeaderText="setadd" SortExpression="setadd" /> <asp:BoundField DataField="bigtaghref" HeaderText="bigtaghref" SortExpression="bigtaghref" /> <asp:TemplateField HeaderText="操作"> <ItemTemplate> <asp:Button Text="启用" runat="server" CommandArgument=" <%# Container.DataItemIndex %>" CommandName="on" /> <asp:Button Text="禁用" runat="server" CommandArgument=" <%# Container.DataItemIndex %>" CommandName="off" /> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView>

后台事件

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { //得到id int index = int.Parse(e.CommandArgument.ToString()); string id = this.GridView1.DataKeys[index].Value.ToString(); string strUpdate = ""; if (e.CommandName == "on") { ////设置开启 strUpdate = " update [DataMasterAdditionalControl] set zt='y' where id= " + id; } else if (e.CommandName == "off") { //设置关闭 strUpdate = " update [DataMasterAdditionalControl] set zt='n' where id= " + id; } if (OledbHelp.sqlNoExecute(strUpdate) > 0) { ClientScript.RegisterStartupScript(this.GetType(), "d", "<mce:script type="text/javascript"></mce:script>"); GridView1.DataBind(); } else { ClientScript.RegisterStartupScript(this.GetType(), "d", "<mce:script type="text/javascript"></mce:script>"); GridView1.DataBind(); } }