Delete all selected items

[El]

following this demo http://demos.telerik.com/aspnet-ajax/Grid/Examples/Programming/SelectRowWithCheckBox/DefaultCS.aspx
I manged it to selects all the rows .. now i would like to delete all selected items from the database by clicking the Delete Button which is not part of the radGrid .. just a common Button to the top of the page.
Column 1 which holds the primary key look like following:

<telerik:GridTemplateColumn Visible="false">
    <ItemTemplate><asp:Label ID="ID" runat="server" Text='<%# Eval("ID") %>'></asp:Label></ItemTemplate>
</telerik:GridTemplateColumn>

Thank you

[Princy]

Hi,

You can loop through the selected items and then delete the items as shown below:

protected void Button2_Click(object sender, EventArgs e)
    {
        foreach (GridDataItem item in RadGrid1.SelectedItems)
        {
           //delete query
        }
    }

Thanks
Princy.

[El]

Hi Princy,

Thanks for the reply .. it makes sense but i need to get the ID value of the selected row and then proceed to the sql query.
Something along this line:
String strSQL = "Delete * From Table Where ID=" + item.ID + "";

Btw, i didn't know that you can iterate the selected items collection in that way. This is great news !

Thanks for any further help

[El]

I think i've found it!

For Each item As GridDataItem In RadGrid1.SelectedItems
    Dim lblID As Label = CType(item.FindControl("ID"), Label)
    ' ToDo: call the delete query
Next

Please just if you can confirm that this is the right way for deleting all selected items.

Thanks

[Sebastian]

Hello El,

Indeed this seems to be a valid solution for deleting the selected items in the grid. Alternatively, you can consider the codeless approach with data source control assigned for item generator demonstrated here (taking advantage of the event bubbling mechanism of RadGrid).

Kind regards,
Sebastian
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[El]

this is so cool...  much appreciated! Thanks :)