title: Set boolean value with SQL with Button click
body: <p>Currently im trying to when i select a row within a datagridview and then click a button it sets a Boolean field in an access database to be true, and nothing seems to be working </p>
  
  <p>Here is my code</p>
  
  <pre><code>    If DbConnect() Then
          Dim SQLCmd As New OleDbCommand
          With SQLCmd
              .Connection = cn
              .CommandText = "Update Tbl_Rental Set @Collected = True Where CarID = @SelectedCarID "
              .Parameters.AddWithValue("@CarID", SelectedCarID)
  </code></pre>
  
  <p>Any help would be appreciated thanks</p>