请运行以下代码并得到错误“必须声明标量变量"@Firstname".".

问题描述

SqlCommand comm = new SqlCommand("INSERT INTO APPLICANTDETAILS(Username,Password,Firstname,Lastname,OtherNames,dateofbirth) VALUES(@Username,@Password,@Firstname,@LastName,@OtherNames,@dateOfbirth)", conn2);

comm.Parameters.Add("@Username", SqlDbType.VarChar, 100).Value = app.Username;
            comm.Parameters.Add("@Password", SqlDbType.VarChar, 100).Value = app.Password;
            comm.Parameters.Add("@Firstname", SqlDbType.VarChar, 100).Value = app.FirstName;
            comm.Parameters.Add("@LastName", SqlDbType.VarChar, 100).Value = app.LastName;
            comm.Parameters.Add("@OtherNames", SqlDbType.VarChar, 100).Value = app.OtherNames;
            comm.Parameters.Add("@dateOfBirth",SqlDbType.VarChar,50).Value = app.DateOfBirth;

try
            {
                comm.Connection.Open();
                comm.ExecuteNonQuery();
                
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                comm.Connection.Close();
            }

推荐答案

这篇关于请运行以下代码并得到错误“必须声明标量变量"@Firstname".".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！