i get error during declaration of variable
Hi i am using this code
string str1 = "insert into tblAccessLevel(AccessLevel) values(@level)";
cmd1 = new OdbcCommand(str1, con);
OdbcParameter param = new OdbcParameter("@level", OdbcType.VarChar);
param.Value = DropDownList4.SelectedItem.ToString();
cmd1.Parameters.Add(param);
cmd1.Connection.Open();
cmd1.ExecuteNonQuery();
cmd1.Connection.Close();
and i got error message
"must declare the variable @level"..
please tell me what should i do.
|
