Error when trying to save updated fields to Access database

Rao Varrey

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
Did you check:

1. You can use single quote(') in where condition.

2. If you have special character in your column then you need to use square bracket([])
0
Sundaram Subramanian9y ago
how many colums are there in ur table ???
0
Rao Varrey9y ago
I am able to display the data from the database using the same database path and I have re-checked the column names... no issues with that
0
Sundaram Subramanian9y ago
1) Check the column names in table and in your SQL statement

2) Check your Database path was corrrect.
0
Rao Varrey9y ago
Hi Manas...It didn't work
0
Manas Mohapatra9y ago
It can cause multiple reasons:

1. You can use single quote(') in where condition.
2. If you have special character in your column then you need to use square bracket([])
3. Make sure column name is correct.
+1