title: how to display data from multiple tables to dataGridView
body: <p>I want to display the phonebook and email data in one dataGridView. and the problem is it will only display the email table</p>
  
  <pre><code>MySqlConnection connection = new MySqlConnection(MyConnectionString);
  connection.Open();
  try
  {
      MySqlCommand cmd = connection.CreateCommand();
      cmd.CommandText = "SELECT * FROM phonebook";
      cmd.CommandText = "SELECT * FROM email";
      MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
      DataSet ds = new DataSet();
      adap.Fill(ds);
      dataGridView1.DataSource = ds.Tables[0].DefaultView;
  }
  catch(Exception ex)
  {
      MessageBox.Show(ex.Message);
  }
  finally
  {
      if (connection.State == ConnectionState.Open)
      {
          connection.Clone();
      }
  }
  </code></pre>