title: C# Sqlite ExecuteReader maximum return
body: <p>What is the maximum amount of rows that can be returned by <code>ExecuteReader</code>? I have some 67 rows in a table and it only returns the first 20.</p>
  
  <p>Here's a piece of my source:</p>
  
  <pre><code>SQLiteConnection sDBConnection = new SQLiteConnection("Data Source=Database.ddb;Version=3");
  sDBConnection.Open();
  string sqlCom = "SELECT * FROM Table1";
  SQLiteCommand scdCommand = new SQLiteCommand(sqlCom, sDBConnection);
  SQLiteDataReader reader = scdCommand.ExecuteReader();
  
  while(reader.Read())
  {
      string Value1 = (string)reader["Col1"];
      bool Value2 = true;
      string Value3 = (string)reader["Col2"];
      object[] row = { Value1, Value2, Value3, Value4, Value5 };
      DataGridView1.Rows.Add(row);
  }
  
  reader.Close();
  sDBConnection.Close();
  </code></pre>
  
  <p>Of course, the values that aren't in the while loop are defined elsewhere.</p>