DaniWeb Forum Index > Software Development > C#

sqlException--invalid expression

Please support our C# advertiser: Programming Forums - DaniWeb Sister Site

Thread Solved

•

Join Date: Sep 2009

Posts: 26

Reputation: dima shawahneh is an unknown quantity at this point

Solved Threads: 2

dima shawahneh dima shawahneh is offline

Offline

Light Poster

sqlException--invalid expression

Nov 1st, 2009

Hello every one..
I have this exception while trying to execute an insert command into a simple sql database

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
string myChar = charNameTextBox.Text;
 
 string command = "insert into data (char,Entropy,Uniformity,stadev,smoothness,skewness,kurtosis) values(" + myChar + "," + entropy + "," + uniformity + "," + standardDeviation + "," + Smoothness + "," + skewness + "," + kurtosis + ")";
 
sqlComm = new SqlCommand(command, sqlConn);
sqlComm.ExecuteNonQuery();
string myChar = charNameTextBox.Text;

 string command = "insert into data (char,Entropy,Uniformity,stadev,smoothness,skewness,kurtosis) values(" + myChar + "," + entropy + "," + uniformity + "," + standardDeviation + "," + Smoothness + "," + skewness + "," + kurtosis + ")";

sqlComm = new SqlCommand(command, sqlConn);
sqlComm.ExecuteNonQuery();

this is the exception ..occures against char with value myChar..
char is defined as nvarchar(MAX)
--------
The name "ب" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
--------

im sure i made a mistake but i can't discover where and i have not been working with database for a long time..

thanks in advance..

•