参数化查询未提供参数这是怎么回事?已经提供参数了啊。。
protected void btnUpdate_Click(object sender, EventArgs e)
{
string strCon = @"Server=.\SQLExpress;Integrated Security=true;AttachDbFileName=|DataDirectory|USERDATA.mdf;"
+"User Instance=true";
using(SqlConnection conn=new SqlConnection(strCon))
{
string update = "UPDATE UDATA SET PASSWORD=@PASSWORD WHERE USERNAME=@USERNAME";
conn.Open();
using(SqlCommand cmd=new SqlCommand(update,conn))
{
cmd.Parameters.AddWithValue("@PASSWORD",txtNew.Text);
cmd.Parameters.AddWithValue("@USERNAME",userName);
cmd.ExecuteNonQuery();
}
conn.Close();
Server.Transfer("go.aspx");
}
老是报错,说我未给@USERNAME提供参数,之前已定义private string userName;然后在Page_Load事件里给userName赋值
userName=Request.Form["txtUserName"];