c# Datagridview + Mysql

[SkyDangerous 395]

 

 

Código:

 

string config = "server=127.0.0.1;userid=root;database=testess";

string query = String.Format("SELECT * FROM {0}", "bd");

 

MySqlConnection conexao = new MySqlConnection(config);

conexao.Open();

 

MySqlCommand command = new MySqlCommand(query, conexao);

MySqlDataAdapter adapter = new MySqlDataAdapter(command);

 

DataTable data = new DataTable();

adapter.Fill(data);

dataGridView1.DataSource = data;