Hi every one ,
I'm programming with C# and I wrote below code :
command = new System.Data.Odbc.OdbcCommand();
command.CommandType = System.Data.CommandType.Text;
commString = "INSERT INTO MyTable (MySign) VALUES (@MySign)";
command.CommandText = commString;
command.Connection = SqlConn; //is defined
command.Parameters.Add("@MySign", OdbcType.VarBinary).Value = MySign;
SqlConn.Open();
command.ExecuteNonQuery();
SqlConn.close()
but I get <Must declare the scalar variable "@Mysign"> error,what is my mistake?
Please help me.
yours sincerely.
Orchid

Hi,

Try using

OdbcParameter param = new OdbcParameter("@MySign", OdbcType.VarBinary);
param.Value = MySign
command.Parameters.Add(param);

instead of the line

command.Parameters.Add("@MySign", OdbcType.VarBinary).Value = some variable;

and make sure that the variable you are setting the variable to has already been defined and has a value.