如何使用链接按钮和复选框在grideview中删除选中的行 [英] how to delete checked row in grideview using linkbutton and checkbox

问题描述

如何使用删除链接按钮和复选框在grideview中删除选中的行.

how to delete checked row in grideview using delete linkbutton and checkbox.

推荐答案

处理行命令/行删除/链接按钮单击，获取数据键并删除相应的行.

Handle either row command/ row deleting/ link button click, get the datakey and delete the corresponding row.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="EmployeeID" DataSourceID="SqlDataSource1">
   <Columns>
      <asp:TemplateField>
          <ItemTemplate>
            <asp:CheckBox ID="cbRows" runat="server"/>
          </ItemTemplate>
       </asp:TemplateField>
<asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID" InsertVisible="False" ReadOnly="True" SortExpression="EmployeeID" />
<asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
   </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" Runat="server"
SelectCommand="SELECT EmployeeID, LastName, City FROM Employees"
DeleteCommand="DELETE FROM Employees WHERE [EmployeeID] = @EmployeeID"
ConnectionString="<%

ConnectionStrings:NorthwindConnectionString %>" > <DeleteParameters> <asp:Parameter Name="EmployeeID" /> </DeleteParameters> </asp:SqlDataSource> <asp:Button ID="btnMultipleRowDelete" OnClick="btnMultipleRowDelete_Click" runat="server" Text="Delete Rows" />

ConnectionStrings:NorthwindConnectionString %>" > <DeleteParameters> <asp:Parameter Name="EmployeeID" /> </DeleteParameters> </asp:SqlDataSource> <asp:Button ID="btnMultipleRowDelete" OnClick="btnMultipleRowDelete_Click" runat="server" Text="Delete Rows" />

protected void btnMultipleRowDelete_Click(object sender, EventArgs e)
{
        
        foreach (GridViewRow row in GridView1.Rows)
        {
            CheckBox checkbox = (CheckBox)row.FindControl("cbRows");
            
            if (checkbox.Checked)
            {
               int employeeID = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value);

SqlDataSource1.DeleteParameters["EmployeeID"].DefaultValue = employeeID.ToString();
                SqlDataSource1.Delete();
            }
        }
 }

这篇关于如何使用链接按钮和复选框在grideview中删除选中的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！