CODEWITHSUNDEEP
c#asp.netsqlmysql
Ishan
Ishan

Reputation: 4028

SQL query error - "Column cannot be null"

I have a SQL query:

String S = Editor1.Content.ToString(); 
     Response.Write(S);    
    string sql = "insert into testcase.ishan(nmae,orders) VALUES ('9',@S)"; 
   OdbcCommand cmd = new OdbcCommand(sql, myConn); 
            cmd.Parameters.AddWithValue("@S", S);  
            cmd.ExecuteNonQuery();

Error: Column 'orders' cannot be null at System.Data.Odbc.OdbcConnection.HandleError

Upvotes: 5

Views: 1724

Answers (2)

Quassnoi
Quassnoi

Reputation: 425381

From the manual:

When CommandType is set to Text, the .NET Framework Data Provider for ODBC does not support passing named parameters to an SQL statement or to a stored procedure called by an OdbcCommand. In either of these cases, use the question mark (?) placeholder. For example:

SELECT * FROM Customers WHERE CustomerID = ?

The order in which OdbcParameter objects are added to the OdbcParameterCollection must directly correspond to the position of the question mark placeholder for the parameter in the command text.

Use this:

string sql = "insert into testcase.ishan(nmae,orders) VALUES ('9', ?)";
OdbcCommand cmd = new OdbcCommand(sql, myConn); 
cmd.Parameters.AddWithValue("you_can_write_anything_here_its_ignored_anyway", S);  
cmd.ExecuteNonQuery();

Upvotes: 4

Saifal Maluk
Saifal Maluk

Reputation: 73

it will be helpful to you

cmd.Parameters.Add("@S", OdbcType.Char, S);

Upvotes: 0

Related Questions