How do I select the Data from the repeater and then delete it on click of a button in same repeater

Question

0.00/5 (No votes)

See more:

I have one repeater one page. Liek this

From To depart arrive operation

LHR JFK 25july 30aug ButtonDeleteSector
LHR JFK 25july 30aug ButtonDeleteSector
LHR JFK 25july 30aug ButtonDeleteSector

now, when I click particular button on particular row, then it should delete the clicked row. So I created this in html for the buttons

ASP.NET

<td class="ItemTemplate" style="text-align: left; width: 75px;">
<asp:Button ID="btnDeleteSector" runat ="server" Text="Delete Sector"  CommandName ="Delete" UseSubmitBehavior ="false"/>
</td>

And in the VB code

VB

Protected Sub rptDatabaseItinerary_Delete_Sector(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterCommandEventArgs) Handles rptDatabaseItinerary.ItemCommand

 If e.Item.ItemType = ListItemType.Item Then

           Dim btnDeleteSector As Button = CType(e.Item.FindControl("btnDeleteSector"), Button)

           Dim id As String = btnDeleteSector.CommandArgument

       End If

       If e.CommandName = "Delete" Then

           For Each objSector As Calrom.BLL.Common.BookingModel.Sector In DatabaseBookingPart.Sectors()

               If e.Item.ItemIndex = 0 Then
                   objSector.Status = BLL.Common.BookingModel.Status.Deleted
               End If


           Next
           rptDatabaseItinerary.DataBind()

       End If

   End Sub

but it is deleting the all sectors, Can anyone tell me how can i select the particualr row and delete it.

Posted 3-Aug-15 1:57am

Member 11491784

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kedar001 · Answer 1 · 2015-08-03T22:27:00

Solution 2

please check ..

edit/update/delete record in repeater control/[^]

Posted 3-Aug-15 22:27pm

kedar001

F-ES Sitecore · Answer 2 · 2015-08-03T23:23:00

Solution 3

As well as a commandname, you need to give the button a CommandArgment that represents the ID of the data you want to delete. On the ItemCommand event of the repeater you check the commandname and commandargument and if the name is "Delete" you delete the record related to the ID held in the CommandArgument.

Posted 3-Aug-15 23:23pm

F-ES Sitecore

Comments

Member 11491784 4-Aug-15 5:26am

but if there are more rows because it will dynamically generate buttons, it will delte other rows also

F-ES Sitecore 4-Aug-15 5:30am

No, because each button has a commandargument that is unique to it. When you click a button the itemcommand event is fired once and it passes the commandname and commandargument of the button clicked. If you google for "repeater itemcommand event" you'll find examples.

Member 11491784 4-Aug-15 5:41am

CommandName ="Delete" UseSubmitBehavior ="false" CommandArgument="<%# Container.ItemIndex.ToString()%>"
I added this bit in html to get command name and command argument.

And i am also handling the same in vb
For Each myitem As RepeaterItem In rptDatabaseItinerary.Items
Dim id As Button = CType(myitem.FindControl("btnDeleteSector"), Button)
If id.CommandName = "Delete" Then
// do stuff

End if

Next

e.command argument is also coming with unique id, But how can I know which button i pressed. Is there any event you know?
Because there can be many rows and rows id they are created at run time

F-ES Sitecore 4-Aug-15 6:11am

The index isn't related to your data though. I'd made the commandargument the ID of the "Sector" record that row is bound to.

How do I select the Data from the repeater and then delete it on click of a button in same repeater

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

How do I select the Data from the repeater and then delete it on click of a button in same repeater

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us