Error when trying to save updated fields to Access database

Question

private void button1_Click(object sender, EventArgs e)

{

// Saves changes made in the details

OdbcConnection myConnection = new OdbcConnection();

OdbcCommand cmd = myConnection.CreateCommand();

string myConnectionString = @"Driver={Microsoft Access Driver (*.mdb)};" + "Dbq=C:/DROPS-Data/Derrick.mdb";

{

myConnection.ConnectionString = myConnectionString;

//execute queries, etc

cmd.CommandText = "UPDATE InspInfo SET CompanyName = @cName, CustomerRef = @cRef Where WONo = @WO";

cmd.Parameters.AddWithValue("@cName",textBox1.Text);

cmd.Parameters.AddWithValue("@cRef", textBox2.Text);

cmd.Parameters.AddWithValue("@WO", textBox6.Text);

myConnection.Open();

cmd.ExecuteNonQuery();

myConnection.Close();

}

}

 

Error message

System.Data.Odbc.OdbcException (0x80131937): ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.

 

Can somebody help please