View Single Post
  #1 (permalink)  
Old March 12th, 2007, 09:30 AM
srivastavaavivek srivastavaavivek is offline
Registered User
 
Join Date: Mar 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.