No value given for one or more required parameters OleDBException

Question

User1979939751 posted

Hi,

I'm having this error and any of the post I found so far did not help me find an answer.
I'm trying to update a record into Access database. The connection string is correct, so is the sql statement. My main problem is that the name of the field i have to update vary depending on the month the user selected. My table has fields named as the 12 months. A user has to make a contribution and depending on the period, I have to update his record.

So I declare the month name as variable (TheMonth = MonthName(i); i =1 to 12) and the contribution as variable (TheAmount) and I put this:

Dim ContributionUpdate As OleDbCommand = New OleDbCommand(MySqlStatement, MyConnectionString)
ContributionUpdate.Parameters.Add(New OleDbParameter("@'" & TheMonth & "'", TheAmount))
ContributionUpdate.ExecuteNonQuery()

MySqlStatement is an update query against my database

When I execute, I'm getting the message "No value given for one or more required parameters" and "In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user."

How can I solve this and then isn't possible to use a variable for the field name in the command parameters?

Thanks 

Answer 1

User1992938117 posted

ContributionUpdate.Parameters.Add(New OleDbParameter("@'" & TheMonth & "'", TheAmount))

why not you are using like below:

Dim ConnString As String = Utils.GetConnString()
Dim SqlString As String = "Update Contacts Set FirstName = ?, LastName = ?"
Using conn As New OleDbConnection(ConnString)
  Using cmd As New OleDbCommand(SqlString, conn)
    cmd.CommandType = CommandType.Text
    cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text)
    cmd.Parameters.AddWithValue("LastName", txtLastName.Text)
    conn.Open()
    cmd.ExecuteNonQuery()
  End Using
End Using

Source:

http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access

Answer 2

User1867929564 posted

You mean to say that this month,you will update
update table set January=""
next month it may be Feb and so on.

write dynamic sql
or create if else if condition
If monthname=jan then
update.........
else if monthname=feb then
update...........

Explain ur requirment again.

Answer 3

User1979939751 posted

You mean to say that this month,you will update
update table set January=""
next month it may be Feb and so on

 

 

No. This month I will update the same table but the fiedl January for some members, and the field Febuary for others. Next month, I will update the same table, but the field January for some membes, the field Febuary for others and maybe the field March. The field varies.

 

Thanks

Answer 4

User1979939751 posted