Hi All

I am using the ShowDeleteButton within a Gridview and the Gridiew is bound to an SQLDataSource control that houses the Delete command. I wondered what would be the best way to provide the user with a confirmation alert box before the record is deleted to make sure they really want to delete that particular record. Also it helps to stay clear of accidental deletions too.

What would be the best way to tackle this?

Many thanks

Rit

__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER

Use the rowdatabound event to add an attribue to the linkbutton("Select"), assuming the linkbutton is in the first column of the gridview:

If e.Row.RowType = DataControlRowType.DataRow Then
   Dim lb As LinkButton
   lb = e.Row.Cells(0).Controls(0)
   lb.Attributes.Add("onclick", "javascript:return confirm('Are you sure you want to delete this row?');")
End If

Jim

What the solution that Jim proposed should generally work, there are easier ways to do this.

On the LinkButton, you can add an OnClientClick directly, with the following code:

OnClientClick="return confirm('Are you sure you want to delete
          this item?');"

However, to make that work, you'll need to convert the Delete button into a Template field. The following post gives more details about this:

http://p2p.wrox.com/topic.asp?TOPIC_ID=45586

It also gives an answer to why under certain circumstances your confirmation button no longer seems to delete stuff.

One final note: you don't need the javascript: prefix in Jim's code. The onclick already indicates that script should be fired.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

THats brilliant, Many thanks, I'll explore both options.

Rit

The row databound example you gave is exactly what I am looking for. However, I am having a slight problem with it. I have a gridview that is generating the Edit and Delete functions. When I insert your code into the row databound event, it fires on the Edit link instead of the Delete. I thought that since the Edit button is listed first, the index of the Delete link inside of the cell would be 1. This is not work. Below is what I tried. Any suggestions?

If e.Row.RowType = DataControlRowType.DataRow Then
   Dim lb As LinkButton
   lb = e.Row.Cells(0).Controls(1)
   lb.Attributes.Add("onclick", "javascript:return confirm('Are you sure you want to delete this row?');")
End If

This works.

If e.Row.RowType = DataControlRowType.DataRow Then
   Dim lb As LinkButton
   lb = e.Row.Cells(0).Controls(0)
   lb.Attributes.Add("onclick", "if(!confirm('Are you sure you want to delete this row?') return false;")
End If

You can use the field template as others have suggested but this is much more simple and will fire the correct event.