Published 4/30/2007 1:45:08 AM  in  MySQL

As for other database engines this could be done by just separating the different queries with a ';'

        public DataSet GetDataMult_MySQL()
        {
            MySql.Data.MySqlClient.MySqlConnection oConn = new MySql.Data.MySqlClient.MySqlConnection();
            oConn.ConnectionString = "Database=sakila;Data Source=192.168.10.4;User id=stefan;Password=pekka";
            oConn.Open();

            DataSet oDataSet = new System.Data.DataSet("tab1");
            //Get data
            MySql.Data.MySqlClient.MySqlCommand command =
                new MySql.Data.MySqlClient.MySqlCommand("select * from city;select * from country", oConn);

            MySql.Data.MySqlClient.MySqlDataAdapter oAdapter =
                new MySql.Data.MySqlClient.MySqlDataAdapter(command);
            oAdapter.Fill(oDataSet, "tab1");
            oConn.Close();

            return oDataSet;


        }

So:

            dataGridView1.DataSource = GetDataMult_MySQL().Tables[0];

shows all cities and

            dataGridView1.DataSource = GetDataMult_MySQL().Tables[1];

shows all countries.