C#SQL操作问题：必须声明标量变量错误

Question

       public int Login(Models.user m_user)
        {
            ConnectionStringSettings cnSetting =
               ConfigurationManager.ConnectionStrings["ConnectionString"];

            int res = -1;
            using (SqlConnection conn = new SqlConnection())
            {
                //conn.ConnectionString = "server=localhost;database=login;Trusted_Connection=true;";
                //conn.Open();

                string uid, pwd;
                uid = m_user.Id;
                pwd = m_user.Pwd;

                conn.ConnectionString = cnSetting.ConnectionString;

                SqlCommand cmd = conn.CreateCommand();
                string sql = "select * from Adm_Info where uid=@uid and pwd=@pwd";

                cmd.Parameters.AddWithValue("@uid", uid);//这里出错，@uid必须声明标量变量
                cmd.Parameters.AddWithValue("@pwd", pwd);
                conn.Open();

怎么办，在网上查了半天也没发现对我这个问题有帮助的。

Answer 1

你到底是什么数据库，sqlserver还是oracle，不同数据库里变量符号是不同的

Answer 2

SqlServer

Answer 3

换个变量名试试，比如前面加个前缀v_uid之类的，尽量避免和数据库中全局变量重名

Answer 4

comm.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar) { Value = "username1" });或者把参数带全了，可能默认的变量类型不正确