Best place to cancel delete

[David C]

I have a GridView with a Delete link and wondered where the best place was
to check and cancel delete of a row/record that is bound to an
SqlDatasource. I can use datasource Deleting event or GridView_RowDel eting
event. I need to get 2 values from the row I am trying to delete so I can
perform another function returns whether I can delete the record or not. I
am trying to do this in gridview event (see code below) but it is not
working. Neither string is returning a value from the 2 cells. Can anyone
point out what I am doing wrong? Thanks.

David

Sub SubfilesGridVie w_RowDeleting(B yVal sender As Object, ByVal e As
GridViewDeleteE ventArgs)

Dim strTextReturned As String
' Get the subfile of the record being deleted.

Dim row As GridViewRow = SubfilesGridVie w.Rows(e.RowInd ex)
'Set value of new Subfile text from cell

'Subfile text is contained in the 3rd column (index 2).
Dim strsubfile As String = row.Cells(2).Te xt

'Set value of SeqNo from cell

'SeqNo is contained in the 2nd column (index 1).

Dim strseqno As String = row.Cells(1).Te xt
'Run function in DBClass module to delete network subfile folder

strTextReturned = DBClass.DeleteS ubfolders(strse qno, strsubfile,
CLng(txtFileNum ber.Text))

If Left(strTextRet urned, 5) = "Error" Then

'There were files in the subdirectory or a runtime error occurred

'so cancel the delete of GridView row.

e.Cancel = True

End If

txtMsg.Text = strTextReturned

txtMsg.Visible = True

MultiView1.Acti veViewIndex = 0
End Sub