Selectedvalue which is invalid because it does not exist

Question

0.00/5 (No votes)

See more:

error message

txt_pay' has a SelectedValue which is invalid because it does not exist in the
list of items. Parameter name: value

Select
@ZAPPRS_NO = APPRS_NO ,
@ZBANKCODE = BANKCD ,
@ZPAY = PAY_TYPE ,
@ZACT_STAT = PAYRUN ,
@ZBANKNAME = BANKNAME ,
@ZINT_CODE = INT_NO
from LOANS Where IDNO= @ZIDNO AND APPRS_NO=@ZAPPRS_NO AND LOANUMBER=@ZLOANUMBER

The above gives the error message

Select
@ZAPPRS_NO = APPRS_NO ,
@ZBANKCODE = BANKCD ,
@ZPAY = PAY_TYPE ,
@ZACT_STAT = PAYRUN ,
@ZBANKNAME = BANKNAME ,
@ZINT_CODE = INT_NO
from LOANS Where IDNO= @ZIDNO AND APPRS_NO=@ZAPPRS_NO

However when I take of the 3rd condition the progam works "LOANUMBER=@ZLOANUMBER:

txt_Pay is a drop down list

What I have tried:

Checked on the internet but there is no example on select statement

Posted 1-Nov-16 11:33am

Member 12770648

Updated 1-Nov-16 17:36pm

v2

Add a Solution

Comments

phil.o 1-Nov-16 18:26pm

"there is no example on select statement"
Sorry, but I seriously doubt that.
Since you did not tell which database engine you are working with, it's hard to give you an appropriate link.
You tagged your question as C# and ASP.NET, but apparently what it should be tagged with is the database engine (MSSQL, Oracle, MySQL, etc...).

Member 12770648 2-Nov-16 0:38am

sorry the database is MSSQL -2008

HANKS

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)

Wendelius · Answer 1 · 2016-11-01T17:36:00

From what I gather, the problem is not in the SQL statement itself but in the code where you call or bind the statement.

You seem to have an object named txt_pay and you try to get a value from it using SelectedValue property. This fails because there is no selection or the value isn't bound to your select statement.

Double check all the parameter bindings int the ASP.NET code. For an example, have a look at SqlDataSource.SelectParameters Property (System.Web.UI.WebControls)[^]