title: How to retrieve values from DB using MySqlDataReader?
body: <p>By using this code I want to retrieve from the DB some rows from a table:</p>
  
  <pre><code>ID int
  ParentID int?
  IsVisible bool
  </code></pre>
  
  <hr>
  
  <pre><code>MySqlCommand myCommand = new MySqlCommand(mySelectQuery, myConnection);
  myConnection.Open();
  MySqlDataReader myReader = myCommand.ExecuteReader();
  
  try
  {
    while(myReader.Read()) 
    {
      //here I want to retrieve the all returned data
    }
  }
  finally
  {
    myReader.Close();
    myConnection.Close();
  }
  </code></pre>