Add Confirm Box to Select button

[fanoftvb]

Hi, i would like to ask if it is possible to add confirm box to the select button. I wish to add a confirm box to my code below, pls help...Thank in advance.

Sub CustomersGridView_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
 
        Dim row As GridViewRow = GridView1.SelectedRow
        Dim str As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath("database\db1.mdb")
        Dim conn As New OleDbConnection(str)
 
        If row.Cells(2).Text = "" Then
            Dim mySelectQuery As String = "SELECT State, FileID FROM Table3"
 
            Dim myUpdateQuery As String = "Update Table3 Set State='6' where FileID=" & "'" & row.Cells(1).Text & "'" & ""
 
            Dim myConnection As New OleDbConnection(str)
 
            Dim myCommand As New OleDbCommand(mySelectQuery, myConnection)
 
            Dim myCommand2 As New OleDbCommand(myUpdateQuery, myConnection)
 
            Dim retvalue As Integer
 
            myConnection.Open()
 
            myCommand2.ExecuteNonQuery()
 
            Console.WriteLine(retvalue)
 
            Dim myReader As OleDbDataReader
 
            myReader = myCommand.ExecuteReader()
 
 
            While myReader.Read <> 0
 
                Label1.Text = ("Successfully Approve")
 
 
            End While
            myReader.Close()
 
 
            myConnection.Close()
 
        End If
 

[Frinavale]

Hi there,

I don't see a "select button" in this code.

I'm assuming that you are implementing a web application
You can add JavaScript to a button so that when the user clicks it, a confirm box shows up:

BTN_Select.Attributes.Add("onclick", "javascript:" + "if(confirm('Are you sure you'd like to select?')==true) {document.getElementById('__Reset').value=True;})
 

You have to make sure that you've registered the hidden form variable "__Reset" so that the JavaScript works properly.

ClientScript.RegisterHiddenField("__Reset","False")

Then you'll have to check this hidden field's value in your code to see if the Select Button's logic should be done or not.

Hope this helps

-Frinny