Dim mysqladapter1 As MySql.Data.MySqlClient.MySqlDataAdapter()
Dim conn_sum As MySql.Data.MySqlClient.MySqlConnection()
 
conn_sum.ConnectionString = New MySql.Data.MySqlClient.MySqlConnection( _
  myConnectionString)
 
mysqladapter1 = New MySql.Data.MySqlClient.MySqlDataAdapter("SELECT * FROM" & _
  "MYSQL1 ", conn_sum)
mysqladapter1.Fill(.....)  'fülle dein Dataset/Datatable
mysqladapter1.dispose
mysqladapter1 = New MySql.Data.MySqlClient.MySqlDataAdapter("SELECT * FROM" & _
  "MYSQL2 ", conn_sum)
mysqladapter1.Fill(.....)  'fülle dein Dataset/Datatable
mysqladapter1.dispose
mysqladapter1 = New MySql.Data.MySqlClient.MySqlDataAdapter("SELECT * FROM" & _
  "MYSQL3 ", conn_sum)
mysqladapter1.Fill(.....)  'fülle dein Dataset/Datatable
mysqladapter1.dispose
 
conn_sum.close

Micke