How to change the data of the selected rows on grid?

[fanoftvb]

Hi, i currently has this code. When on click on the "Approve" button, the database of all the rows will change. I have "Approve" button on every row. How do i make it so that only the selected rows will change? Pls help. Thank in advance.

Sub CustomersGridVi ew_RowCommand(B yVal sender As Object, ByVal e As GridViewCommand EventArgs)


Dim str As String = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source= " & Server.MapPath( "database\db1.m db")
Dim row As GridViewRow = GridView1.Selec tedRow

If e.CommandName = "Approve" Then


'Dim index As Integer
Dim mySelectQuery As String = "SELECT State, FileID FROM Table3"

Dim myUpdateQuery As String = "Update Table3 Set State='6' "

Dim myConnection As New OleDbConnection (str)

Dim myCommand As New OleDbCommand(my SelectQuery, myConnection)

Dim myCommand2 As New OleDbCommand(my UpdateQuery, myConnection)

Dim retvalue As Integer

myConnection.Op en()

myCommand2.Exec uteNonQuery()

Console.WriteLi ne(retvalue)

Dim myReader As OleDbDataReader

myReader = myCommand.Execu teReader()


While myReader.Read()

Label1.Text = ("Approve")

End While


myReader.Close( )


myConnection.Cl ose()
End If



End Sub

p.s I'm using vb 2005

[kenobewan]

I believe that you need to use the id in your update query. HTH.

[fanoftvb]

I believe that you need to use the id in your update query. HTH.

Hi, thanks for the reply. How do i use id? I'm actually still learning vb so there are a lot that i don't know. Can u kindly show me how to do it? Thanks.