Torna al Thread
private void toolStripButton1_Click(object sender, EventArgs e)
{
dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.Navy;
dataGridView1.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
dataGridView1.ColumnHeadersDefaultCellStyle.Font =
new Font(dataGridView1.Font, FontStyle.Bold);
dataGridView1.AutoSizeRowsMode =
DataGridViewAutoSizeRowsMode.DisplayedCellsExceptHeaders;
dataGridView1.ColumnHeadersBorderStyle =
DataGridViewHeaderBorderStyle.Single;
dataGridView1.CellBorderStyle = DataGridViewCellBorderStyle.Single;
dataGridView1.GridColor = Color.Black;
dataGridView1.RowHeadersVisible = false;
dataGridView1.SelectionMode =
DataGridViewSelectionMode.FullRowSelect;
dataGridView1.MultiSelect = false;
//create the connection string
string connString = @"driver={MySQL ODBC 3.51 Driver};server=localhost;database=arrtusm;uid=root;pwd=root;";
//create the database query
string query = "SELECT * FROM tbl_utenti";
//create an OleDbDataAdapter to execute the query
OdbcDataAdapter dAdapter =
new OdbcDataAdapter(query, connString);
//create a command builder
OdbcCommandBuilder cBuilder =
new OdbcCommandBuilder(dAdapter);
//create a DataTable to hold the query results
DataTable dTable = new DataTable();
//fill the DataTable
dAdapter.Fill(dTable);
//BindingSource to sync DataTable and DataGridView
BindingSource bSource = new BindingSource();
//set the BindingSource DataSource
bSource.DataSource = dTable;
//set the DataGridView DataSource
dataGridView1.DataSource = bSource;
}
}