... adapter.SelectCommand.CommandText = "SELECT * FROM Table1; SELECT * FROM Table2;"; adapter.Fill(dataset); ...