“System.Data.SqlClient.SqlException”类型的未经处理的异常在 System.Data.dll 中发生 其他信息: 'Use
运行一段代码,总是出现这个问题,该怎么解决
public UserInfo SelectUser( string userName ,string password )
{
using ( SqlConnection conn = new SqlConnection(DbUtil.ConnString))
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT ID,UserName,PassWord,Email FROM USERS WHERW UserName=@UserName AND PassWord=@PassWord";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@UserName", userName));
cmd.Parameters.Add(new SqlParameter("@PassWord", password));
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
UserInfo user = null;
while (reader.Read())
{
if (user == null)
{ user = new UserInfo(); }
user.ID = reader.GetInt32(0);
user.UserName = reader.GetString(1);
user.PassWord = reader.GetString(2);//not successtion
if (!reader.IsDBNull(3))
{
user.Email = reader.GetString(3);
}
}
return user;
}
使用的数据库是用视图建立的,求大神帮忙!!