How I Can Show More Table In Datagridview C#

See more:

C#

MySQL

hi,

can i show two table or more in one datagridview using c# and mysql sorting by date ?

for ex:
---------------------------------------------------------
| table1.salesNo | table1.salesMoney | table1.date1 |
---------------------------------------------------------
| table2.salesNo | table2.salesMoney | table2.date2 |
---------------------------------------------------------
| table2.salesNo | table2.salesMoney | table2.date3 |
---------------------------------------------------------
| table1.salesNo | table1.salesMoney | table1.date4 |
---------------------------------------------------------
| table1.salesNo | table1.salesMoney | table1.date5 |
---------------------------------------------------------

i used this code but no data appear

 private MySqlDataAdapter salesinvoices, purchasesinvoices;
        private DataSet jedataset;
private void button2_Click(object sender, EventArgs e)
      {
          const string SELECT_salesinvoices = "SELECT * FROM sales_invoices";
          const string SELECT_purchasesinvoices = "SELECT * FROM purchase_invoices";



          // Compose the connection string.
          string connect_string = Publics.je_Coonn;

          // Create a DataAdapter to load the Addresses table.
          salesinvoices = new MySqlDataAdapter(SELECT_salesinvoices,
              connect_string);

          // Create a DataAdapter to load the Addresses table.
          purchasesinvoices = new MySqlDataAdapter(SELECT_purchasesinvoices,
              connect_string);

          // Create and fill the DataSet.
          jedataset = new DataSet("je_coronasalesdbDataSet");
          salesinvoices.Fill(jedataset, "sales_invoices");
          purchasesinvoices.Fill(jedataset, "purchase_invoices");

          // Bind the DataGrid to the DataSet.
          dataGridView1.DataSource = jedataset;
      }

thanks