title: display data from my database using dataGridView?
body: <p>I want to display data from my database using dataGridView, but I am not getting the desired result. It's showing blank spaces in the table when I run the code.
  Here is the code:</p>
  
  <pre><code>     MySqlCommand cmd = new MySqlCommand(query, ca.getConnection());
       cmd.CommandType = CommandType.Text;                  
       MySqlDataAdapter MyAdapter = new MySqlDataAdapter(cmd);               
       DataSet dSet = new DataSet();                        
       MyAdapter.Fill(dSet);                                       
       dataGridView1.DataSource = dSet.Tables[0];
  </code></pre>