title: C# - DataGridView not displaying full query result
body: <p>I'm working on a project and I add a query on navicat that displayed the results I wanted perfectly but when I used that same query on my project it only showed 5 rows of results.</p>
  
  <p>the code im using for filling the datagridview and fetching the data is the following.</p>
  
  <pre><code>    string cs = "*info*";
      MySqlConnection liga = new MySqlConnection(cs);
      string query = "*I have the full query futher down, its big and it looks stange in here*";
      MySqlCommand comando = new MySqlCommand(query, liga);
      int nInt = Convert.ToInt32(textBox1.Text);
  
      comando.Parameters.AddWithValue("@ni", nInt);
      try
      {
          liga.Open();
          MySqlDataReader leitor = comando.ExecuteReader();
  
          DataTable tabela = new DataTable();
          tabela.Load(leitor);
          dataGridView1.DataSource = tabela;
          leitor.Close();
      }
      catch (MySqlException ex)
      {
          MessageBox.Show(ex.Message);
      }
      finally
      {
          liga.Close();
      }
  </code></pre>
  
  <p>QUERY</p>
  
  <pre><code>SELECT
  disciplinas.nome AS Disciplina,
  mods_alunos.numero,
  mods_alunos.nota
  
  FROM
  mods_alunos
  
  INNER JOIN disciplinas ON mods_alunos.codDisc = disciplinas.codDisc
  
  WHERE
  nInterno = @ni
  </code></pre>
  
  <p>I've come to the conclusion that it has to do with the INNER JOIN because is i just do SELECT * FROM mods_alunos it displays more than 5 results</p>
  
  <p>EDIT 1:<a href="https://i.stack.imgur.com/2qEww.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2qEww.png" alt="table schema"></a></p>
  
  <p><a href="https://i.stack.imgur.com/67cNo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/67cNo.png" alt="What i should be getting on DGV"></a></p>