必须声明变量 '@pp'...求救!!
string queryString = "select Pwd,id,name,dept,job,lishu from Sw_Users where UserName = @pp and Fettle='正常'";
using (OleDbConnection connection = new OleDbConnection(ConfigurationManager.AppSettings["ConnStr"]))
{
OleDbCommand command = new OleDbCommand(queryString, connection);
command.Parameters.Add(new OleDbParameter("@pp", OleDbType.VarChar, 20));
command.Parameters["@pp"].Value = UserName;
connection.Open();
try
{
OleDbDataReader reader = command.ExecuteReader();
if (reader.Read())
{
return true;
}
else
{
objConn.Close();
return false;
}
}
catch (Exception ex)
{
Response.Write(ex.Message + "<br>" + ex.Source + "<br>" + ex.StackTrace + "<br>" + ex.TargetSite);
Response.End();
}
OleDbDataReader reader = command.ExecuteReader();这一行出错!我从别处抄来的代码也会出错,郁闷!求救!!