[2008] Using variables in an SQL string

[nickf77]

It is possible to use a variable in the SQL string below?
Because the string is in quotes, I didn't know if it would recognize it as a variable.

Just for some background, 'bfguide' is the name of the database, 'rate' is the name of the table, and 'count' is the name of a field in the table.

myConnection = New MySqlConnection("server=localhost; user id=admin; password=******; database=bfguide; pooling=false;")
 
 --->   strSQL = "UPDATE rate SET count =  **variable** WHERE ID = 1;"
 
        myDataAdapter = New MySqlDataAdapter(strSQL, myConnection)
        myDataSet = New DataSet()
        myDataAdapter.Fill(myDataSet, "bfguide")
 
        MySQLDataGrid.DataSource = myDataSet
        MySQLDataGrid.DataBind()