[RESOLVED] ADO.NET Update Code with Parameter - How?

[Mark Gambo]

Here is a snippet of code that I am using to update a row in a DB:

       Dim MyCONNECTIONSTRING As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb"
        Dim DBConnection As New OleDb.OleDbConnection(MyCONNECTIONSTRING)
        Dim strSQL As String = "UPDATE Customers SET Rank = + @SearchFor + WHERE ID=1;"
        Dim OLECmd As New OleDb.OleDbCommand(strSQL)

        Dim SelectParameter As OleDb.OleDbParameter = OLECmd.CreateParameter
        SelectParameter.ParameterName = "@SearchFor"
        SelectParameter.Value = "Test Rank"
        OLECmd.Parameters.Add(SelectParameter)

        DBConnection.Open()
        OLECmd.ExecuteNonQuery()

I can't seem to be able to get this code to work by using the Parameter, any ideas?

Thanks!