no value given for one or more required parameters. oledb c# – SOLVED

When you get this error, this is almost always as a result of a misspelt column name.

I recently received this error with the following line of code:


cmdContactSync = new OleDbCommand(“update connectContacts set ConnectCellphoneNumber = ‘” + newNumber + “‘, sycned = ‘false’ where ConnectCellphoneNumber = ‘” + oldNumber + “‘”, conContactSync);


The problem as the misspelt column name synced which as you can see from above was spelt sycned

Double and triple check the spelling of your column names, and you’ll save quite some time googling around ?

Cheerio ?