错误提示: 必须声明标量变量 "@pwd
夜雨夜话 2015-05-29 12:02:48 代码如下
string constr = @"Data Source=TESTSERVERIT;Initial Catalog=khgltest;Persist Security Info=True;User ID=sa;Password=abc.123";
using (SqlConnection con=new SqlConnection(constr))
{
con.Open();
string sql = @"select USERID from wh_user where [PASSWORD]=@pwd";
using (SqlCommand com=new SqlCommand(sql,con))
{
SqlParameter para = new SqlParameter("@pwd", SqlDbType.VarChar, 18);
//com.Parameters.AddWithValue("@pwd","abc.123");
para.Value = "abc.123";
SqlDataAdapter adp = new SqlDataAdapter(com.CommandText,con);
DataTable dt = new DataTable();
adp.Fill(dt);
foreach (DataRow dr in dt.Rows )
{
DataColumn dc = dt.Columns["USERID"];
string uid= (string)dr[dc];
}
这里SqlParameter para = new SqlParameter("@pwd", SqlDbType.VarChar, 18);
//com.Parameters.AddWithValue("@pwd","abc.123");
para.Value = "abc.123";不是已经申明了吗,为什么还是报错??