title: "Invalid attempt to call Read when reader is closed" when using a SqlDataReader
body: <p>1) I have the following codes:</p>
  
  <pre><code>private static sqlDataReader gCandidateList = null;
  
  public SqlDataReader myCandidateList
  {
      set
      {
          gCandidateList = value;
      }
      get
      {
          return gCandidateList;
      }
  }
  </code></pre>
  
  <p>2) In FormA I have:</p>
  
  <pre><code>sqlConn.ConnectionString = mySettings.myConnString;
  sqlConn.Open();
  SqlCommand cmdAvailableCandidate = new SqlCommand(tempString, sqlConn);
  SqlDataReader drAvailableCandidate = cmdAvailableCandidate.ExecuteReader();
  mySettings.myCandidateList = drAvailableCandidate;
  sqlConn.Close();
  </code></pre>
  
  <p>3) In FormB I want to reuse the data saved in myCandidatList so I use:</p>
  
  <pre><code>SqlDataReader drCandidate = mySettings.myCandidateList;
  drCandidate.Read();
  </code></pre>
  
  <p>4) I then got the error "Invalide attempt to call Read when reader is closed."</p>
  
  <p>5) I tried mySettings.myCandidateList.Read() in (3) above and again received the same error message.</p>
  
  <p>6) How can I re-open SqlDataReader drCandidate to read data?</p>
  
  <p>7) Would appreciate very much for advise and help, please.</p>