Multiple select statement for sqldataadapter

    SqlDataAdapter adapter = new SqlDataAdapter(

      "SELECT * FROM Customers; SELECT * FROM Orders", connection);

            adapter.TableMappings.Add("Table", " Customers ");

            adapter.TableMappings.Add("Table1", " Orders ");

            adapter.Fill(ds);

        }