阅读器关闭时尝试调用 Read 无效，解决办法

阅读器关闭时尝试调用 Read 无效，解决方法
阅读器关闭时尝试调用 Read 无效请问是怎么回事，如何解决。下面是代码

SqlDataReader odr=LogingUserName();
if(odr.read())
{
......
}
   
 public SqlDataReader LogingUserName()
  {
  try
  {
  StrSql = "select * from [WIN_ADMINISTRATOR] where [WIN_ADMIN_USERNAME]=@StrName and [WIN_ADMIN_PASSWORD]=@StrPass";
  SqlParameter Username = new SqlParameter("@StrName", SqlDbType.NVarChar, 16);
  Username.Value = Convert.ToString(username);
  SqlParameter Password = new SqlParameter("@StrPass", SqlDbType.NVarChar, 50);
  Password.Value = Convert.ToString(password);
  SqlParameter[] ArryPars = { Username, Password };
  return ExecuteReader(connString, CommandType.Text, StrSql, ArryPars);

  }

  catch
  {
  throw;
  }
   
  }
   
下面这个是类里面的
public static SqlDataReader ExecuteReader(SqlConnection connection, CommandType cmdType, string cmdText, params SqlParameter[] cmdParms)
  {
  SqlCommand cmd = new SqlCommand();
  try
  {
  PrepareCommand(cmd, connection, null, cmdType, cmdText, cmdParms);
  SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
  cmd.Parameters.Clear();
  return rdr;
  }
  catch
  {
  connection.Close();
  throw;
  }
  }

[解决办法]

C# code

public static SqlDataReader ExecuteReader(SqlConnection connection, CommandType cmdType, string cmdText, params SqlParameter[] cmdParms)        {            SqlCommand cmd = new SqlCommand();            DataReader reader = null;            try            {                PrepareCommand(cmd, connection, null, cmdType, cmdText, cmdParms);                reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);                cmd.Parameters.Clear();                return reader;            }            catch (Exception e)  {   throw e;  }            finally            { if (reader != null) {  reader.Close();  }  }        }
[解决办法]
别用READER 你那样用要出问题
如果访问量大了 连接池就暴了。。。