Syntax error converting the nvarchar value to a column of data type int.

Posted by Phil on Stack Overflow See other posts from Stack Overflow or by Phil
Published on 2010-05-05T07:38:31Z Indexed on 2010/05/05 7:48 UTC
Read the original article Hit count: 298

Filed under:

conversion

|

integer

|

ASP.NET

|

dropdownlist

|

vb

I have 1,2,3,4,5,6,7,8,9 stored as nvarchar inside Level in my db.

I then have a dropdownlist with values 1,2,3,4,5,6,7,8,9. When a user makes a selection (i.e 1) (Level.SelectedValue.ToString). This builds an sql query via a param like this:

"Select things From MBA_EOI Where level = 1"

When I run the select I get the following error:

Syntax error converting the nvarchar value '1,2,3,4,5,6,7,8,9' to a column of data type int.

I was under the impression that I was dealing with an Nvarchar field and the selected value as string, where does the int conversion come in?

p.s I have also tried Level.SelectedItem.ToString

© Stack Overflow or respective owner

Related posts about conversion

Conversion constructor vs. conversion operator: precedence

as seen on Stack Overflow - Search for 'Stack Overflow'
Reading some questions here on SO about conversion operators and constructors got me thinking about the interaction between them, namely when there is an 'ambiguous' call. Consider the following code: class A; class B { public: B(){} B(const A&) //conversion constructor … >>> More
Conversion of bytes into a type without changing the application (ie storing the conversion method i

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to store a conversion strategy (for converting some bytes) into a database and then execute it on the run time. If one were to store a complete java file, you would need to compile it, store the class and some how inject into the already running system. I am not sure how this would… >>> More
General type conversion without risking Exceptions

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on a control that can take a number of different datatypes (anything that implements IComparable). I need to be able to compare these with another variable passed in. If the main datatype is a DateTime, and I am passed a String, I need to attempt to convert the String to a DateTime… >>> More
Create a Unit Conversion Application with the Zend_Measure Component

as seen on Internet.com - Search for 'Internet.com'
Learn how to create a simple conversion calculator using the Zend Framework's Zend_Measure component ... >>> More
Create a Unit Conversion Application with the Zend_Measure Component

as seen on Internet.com - Search for 'Internet.com'
Learn how to create a simple conversion calculator using the Zend Framework's Zend_Measure component ... >>> More

Related posts about integer

Finding out why Dell Controler is Degraded

as seen on Server Fault - Search for 'Server Fault'
I installed open manage on a couple of my PE 2950s for snmp monitoring of the RAID. All the checks seem to come back okay except for controllerState: [root@aMachine ~]# snmpwalk -v 2c -c bestNotToPostPasswords myMachine -m +StorageManagement-MIB controllerstate StorageManagement-MIB::controllerState… >>> More
Bit reversal of an integer, ignoring integer size and endianness

as seen on Stack Overflow - Search for 'Stack Overflow'
Given an integer typedef: typedef unsigned int TYPE; or typedef unsigned long TYPE; I have the following code to reverse the bits of an integer: TYPE max_bit= (TYPE)-1; void reverse_int_setup() { TYPE bits= (TYPE)max_bit; while (bits <<= 1) max_bit= bits; } TYPE reverse_int(TYPE… >>> More
What is a Delphi version of the C++ header for the DVP7010B video card DLL?

as seen on Stack Overflow - Search for 'Stack Overflow'
I need help with converting c++ header file to delphi. I spent several days on this problem without success. Below is the original header file and my Delphi translation. C++ header #if _MSC_VER > 1000 #pragma once #endif // _MSC_VER > 1000 #ifdef DVP7010BDLL_EXPORTS #define DVP7010BDLL_API… >>> More
Need help converting a C++ header file to delphi

as seen on Stack Overflow - Search for 'Stack Overflow'
I need help with converting c++ header file to delphi. I spent several days on this problem without success. Below is the original header file and my Delphi translation. ///////////////////////// C++ header file //////////////////////////////////// if _MSC_VER 1000 pragma once endif // _MSC_VER… >>> More
SQLiteOpenHelper.getWriteableDatabase() null pointer exception on Android

as seen on Stack Overflow - Search for 'Stack Overflow'
I've had fine luck using SQLite with straight, direct SQL in Android, but this is the first time I'm wrapping a DB in a ContentProvider. I keep getting a null pointer exception when calling getWritableDatabase() or getReadableDatabase(). Is this just a stupid mistake I've made with initializations… >>> More