title: reader.Read() only read once even when there are multiple rows to read
body: <p>I have the code </p>
  
  <pre><code>while (reader.Read())
  {
      if (reader[incrementer]!=DBNull.Value){
          string playerToInform = reader.GetString(incrementer).ToString();
          string informClientMessage = "ULG=" + clientIP + ","; //User Left Game
          byte[] informClientsMessage = new byte[informClientMessage.Length];
          informClientsMessage = Encoding.ASCII.GetBytes(informClientMessage);
          playerEndPoint = new IPEndPoint(IPAddress.Parse(playerToInform), 8001);
          clientSocket.SendTo(informClientsMessage, playerEndPoint);
      }
      incrementer++;
  }
  </code></pre>
  
  <p>which after debugging my code i see contains 4 entries. However only the first result is ever read from the reader. After the first iteration to find if the result returned is null or not the loop starts again and immediately finishes even though there are three more rows to read.</p>
  
  <p>Any ideas as to why this may be occuring would be apprechiated.</p>
  
  <p><strong>edit - this is the reader i used</strong></p>
  
  <pre><code>OleDbDataReader reader = dBConn.DataSelect("SELECT player1_IP, player2_IP, player3_IP, player4_IP FROM running_games WHERE game_name = '" + gameName + "'", updateGameList);
  </code></pre>