SQL query error - "Column cannot be null"

Question

I have an 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 empty in System.Data.Odbc.OdbcConnection.HandleError

Answer 1

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 stored procedure called OdbcCommand. In any of these cases, use a question mark (?). For instance:

SELECT * FROM Customers WHERE CustomerID = ?

, OdbcParameter OdbcParameterCollection, .

:

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(); 

Answer 2

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