Executenonquery returns an error after finishing insert

Question

0.00/5 (No votes)

See more:

Im trying to insert records into an SQL table through VB.Net.
The Records are inserted but I get the following Error Message:

The parameterized query '(@EmpName varchar(8000),@USDBasic money,@OtherUSDEarnings money,' expects the parameter '@EmpName', which was not supplied.

What I have tried:

I have tried to cater for Null values through this code ,but to no avail.
If @EmpName = Nothing Then
cmd.Parameters.Add("@EmpName", SqlDbType.VarChar).Value = BDNull.value
Else
cmd.Parameters.Add("@EmpName", SqlDbType.VarChar).Value = DataGridView1.Rows(i).Cells(0).Value

Posted 5-Feb-23 9:56am

Charm Mukuwane

Updated 5-Feb-23 19:07pm

Add a Solution

Comments

Dave Kreskowiak 5-Feb-23 23:12pm

Need to see the code, including the setup of the query and parameters.

Sandeep Mewara 5-Feb-23 23:14pm

2 things:
1. Believe it's a typo and it's DBNull and not BDNull
2. You want to change the if condition. A quick debug might help to assure.

// check for valid value before using for comparison
If DataGridView1.Rows(i).Cells(0).Value = Nothing Then
cmd.Parameters.Add("@EmpName", SqlDbType.VarChar).Value = BDNull.value
Else
cmd.Parameters.Add("@EmpName", SqlDbType.VarChar).Value = DataGridView1.Rows(i).Cells(0).Value

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2023-02-05T19:07:00

Ignoring that the VB code won't even compile ...

Look at the error message:

Error

The parameterized query '(@EmpName varchar(8000),@USDBasic money,@OtherUSDEarnings money,' expects the parameter '@EmpName', which was not supplied.

That is pretty explicit, and for an SQL error message it is pretty clear: it means that the EmpName you supplied was a NULL value, and the SP is set up specifically not to accept nulls. YOu could change the SP to allow nulls, but a better solution is to prevent the INSERT from happening at all if there is no such data.

We can't help you fix that - it's a design decision you need to take and which is very relevant to your DB design that we have no access to!