title: ')' expected error when formatting a string
body: <p>I am currently stuck on a piece of work I am creating. In Visual Studio, I have a gridview which is bound to a datasource from a SQL table. I have a bit type column named Sold and what I am trying to do is use a drop down box (which is bound to the same source) and according to that selected index, change the sold row for that ID to 1 - to show that its been sold oddly enough!</p>
  
  <p>Here is my code for the procedure to update my database.</p>
  
  <pre><code>Sub markAsSold()
      strSQL = ("Update Vehicles set Sold = 1  where VehicleID={0}",DropDownList1.SelectedValue)
      conn = New SqlConnection(strconn)
      cmd = New SqlCommand(strSQL, conn)
      conn.Open()
  
      cmd.ExecuteNonQuery()
      displayVehicle()
  End Sub
  </code></pre>
  
  <p>I know its not parametrised but I'm just trying to get it working for the time being, and then I'll tidy it up.</p>
  
  <p>The error states that a ')' is expected after VehicleID={0}" (and a blue mark on Visual Studio shows it too).</p>