62,046
社区成员
发帖
与我相关
我的任务
分享
string Username=this.mobileIpt.Text;
string Userpwd = this.TextBox1.Text;
string sqlAdd=("insert into Customer(Username,Userpwd) values('Username','Userpwd')");
// string sqlAdd = "('insert into Customer(Username,Userpwd')values
SqlCommand addNew = new SqlCommand(sqlAdd,conn);
addNew.ExecuteNonQuery();
string sql = string.Format("insert into Customer(Username,Userpwd) values('{0}','{1}')", Username, Userpwd);
SqlCommand addNew = new SqlCommand();
string Username = this.mobileIpt.Text.Trim();
string Userpwd = this.TextBox1.Text.Trim();
addNew.CommandText = "insert into Customer(Username,Userpwd) values(@User,@pwd)";
addNew.Parameters.Add("User",sqlDbType.Varchar,20).Value=Username;
addNew.Parameters.Add("pwd",sqlDbType.Varchar).Value=Userpwd;
addNew.Connection = conn;
addNew.ExecuteNonQuery();
错误 2 当前上下文中不存在名称“sqlDbType” F:\日常学习\课设\tpr\tpr\register.aspx.cs 37 41 tpr
string Username=this.mobileIpt.Text;
string Userpwd = this.TextBox1.Text;
string sqlAdd=("insert into Customer(Username,Userpwd) values('"+Username+"','"+Userpwd+"')");
SqlCommand addNew = new SqlCommand(sqlAdd,conn);
addNew.ExecuteNonQuery();
string sqlAdd=("insert into Customer(Username,Userpwd) values(@U,@pwd)");
addNew.Parameters.Add("@U",Username);
addNew.Parameters.Add("@pwd",Userpwd);
SQL
语句中@var,var就会被看作一个变量