Getting Failed when Updating Data using Oledb C#

Question

I have problem when updating data using OleDb in C#. Error says

No value given for one or more required parameters.

Here my code

OleDbConnection kon = new OleDbConnection(koneksi);
            OleDbCommand command = kon.CreateCommand();

            kon.Open();

            if (LimitCB.SelectedItem == "30")
            {
                command.CommandText = "UPDATE [Data] SET [Denom 50]= @den50, [Denom 100]= @den100 WHERE [Limit] = @lim30";
                command.Parameters.AddWithValue("@den50", CRMden50.Text);
                command.Parameters.AddWithValue("@den100", CRMden100.Text);
                command.Parameters.AddWithValue("@lim30", 30);
                command.ExecuteNonQuery();
            }  
            kon.Close();

[Denom 50] and [Denom 100] are your columns names within table? — M. Adeel Khalid
– M. Adeel Khalid, Commented Feb 7, 2017 at 4:08

Joel Coehoorn · Accepted Answer · 2017-02-07 04:20:20Z

1

OleDb does not have named parameters. From the first sentence in the Remarks section of the documentation:

The OLE DB .NET Provider does not support named parameters for passing parameters to an SQL statement

Instead of @name, it uses the ? token as parameter placesholders and relies on the ordering of the parameters in the collection to match parameter values to the placeholder.

answered Feb 7, 2017 at 4:20

Joel Coehoorn

418k114 gold badges582 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting Failed when Updating Data using Oledb C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related