title: Fill Datagridview with MySQL data
body: <p>i tried several times to make it work but it just doesn't fill up the datagridview with mysql data ,here's my code :</p>
  
  <pre><code>string connectionString = "SERVER=localhost;DATABASE=shootsource;UID=root;PASSWORD=;";
          string sql = "SELECT * FROM characters";
          MySqlConnection connection = new MySqlConnection(connectionString);
          connection.Open();
          sCommand = new MySqlCommand(sql, connection);
          sAdapter = new MySqlDataAdapter(sCommand);
          sBuilder = new MySqlCommandBuilder(sAdapter);
          sDs = new DataSet();
          sAdapter.Fill(sDs, "characters");
          sTable = sDs.Tables["characters"];
          connection.Close();
          dataGridView1.DataSource = sDs.Tables["characters"];
          dataGridView1.ReadOnly = true;
          dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
  </code></pre>
  
  <p>It shows only the columns from the mysql table 'characters' : id,name,time etc...how can i populate it from the db?</p>
  
  <p>Here is an image of the problem:</p>
  
  <p><img src="https://i.stack.imgur.com/sbrqr.png" alt="enter image description here"></p>