sqlcommand的命名参数，是怎么添加值的？

[ncowboy]

this.DBCommand.CommandText="INSERT INTO [userinfo]( [username], [password], [email]) VALUES(@username, @password,@email)";
this.DBCommand.Parameters.Add("username",this.Request["username"]);
this.DBCommand.Parameters.Add("password",this.Request["password"]);
this.DBCommand.Parameters.Add("email",this.Request["email"]);


这样整，是错了的。错在什么地方呢。谢谢了

[looner]

把@換成冒號試試呢

[huqiyang]

this.DBCommand.CommandText="INSERT INTO [userinfo]( [username], [password], [email]) VALUES(@username, @password,@email)";
this.DBCommand.Parameters.Add("@username",this.Request["username"]);
this.DBCommand.Parameters.Add("@password",this.Request["password"]);
this.DBCommand.Parameters.Add("@email",this.Request["email"]);

[Naruke]

this.DBCommand.CommandText="INSERT INTO [userinfo]( [username], [password], [email]) VALUES(@username, @password,@email)";
this.DBCommand.Parameters.Add("@username",this.Request["username"]);
this.DBCommand.Parameters.Add("@password",this.Request["password"]);
this.DBCommand.Parameters.Add("@email",this.Request["email"]);

[huqiyang]

MyCommand.Parameters.Add("@content", SqlDbType.NVarChar, 50).Value=TextBox2.Text;

[welshem]

参数类型没设置
String insertCmd = "insert into Authors (au_id, au_lname, au_fname, phone, address, city, state, zip, contract) values (@Id, @LName, @FName, @Phone, @Address, @City, @State, @Zip, @Contract)";

SqlCommand myCommand = new SqlCommand(insertCmd, myConnection);

myCommand.Parameters.Add(new SqlParameter("@Id", SqlDbType.NVarChar, 11));
myCommand.Parameters["@Id"].Value = au_id.Value;

myCommand.Parameters.Add(new SqlParameter("@LName", SqlDbType.NVarChar, 40));
myCommand.Parameters["@LName"].Value = au_lname.Value;

myCommand.Parameters.Add(new SqlParameter("@FName", SqlDbType.NVarChar, 20));
myCommand.Parameters["@FName"].Value = au_fname.Value;

myCommand.Parameters.Add(new SqlParameter("@Phone", SqlDbType.NChar, 12));
myCommand.Parameters["@Phone"].Value = phone.Value;

myCommand.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 40));
myCommand.Parameters["@Address"].Value = address.Value;

myCommand.Parameters.Add(new SqlParameter("@City", SqlDbType.NVarChar, 20));
myCommand.Parameters["@City"].Value = city.Value;

myCommand.Parameters.Add(new SqlParameter("@State", SqlDbType.NChar, 2));
myCommand.Parameters["@State"].Value = state.Value;

myCommand.Parameters.Add(new SqlParameter("@Zip", SqlDbType.NChar, 5));
myCommand.Parameters["@Zip"].Value = zip.Value;

myCommand.Parameters.Add(new SqlParameter("@Contract", SqlDbType.NVarChar,1));
myCommand.Parameters["@Contract"].Value = contract.Value;

myCommand.Connection.Open();

[welshem]

myCommand.ExecuteNonQuery();