asp.net (update from listbox)

hi, i have done the code for updating data fro the listbox but the code jus get the last data in the listbox. Did i write my sql wrongly? below is my code. Please advice. thanks




Dim DBAconn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("dvd_rental.mdb"))
DBAconn.Open()


Dim actor As Integer
actor =

Me.lstbxUActor.Items.Count

Dim i As Integer

Dim Actorvalue As String
Actorvalue =

""

For i = 0 To actor - 1
Actorvalue =

"'" & Me.lstbxUActor.Items(i).Value & "'"



Dim adapterA As New OleDb.OleDbDataAdapter("SELECT `Actor Name` FROM Actor", DBAconn)

Dim Acmd As New OleDb.OleDbCommand("UPDATE Actor SET `Actor Name` = @Actorname WHERE `Movie ID` = '" & Movie & "' ", DBAconn)
Acmd.Parameters.AddWithValue(

"@Actorname", Actorvalue)
Acmd.Parameters.AddWithValue(

"@Actorname1", Movie)
adapterA.UpdateCommand = Acmd

Acmd.ExecuteNonQuery()




Next
DBAconn.Close()

DBAconn =

Nothing