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; } }
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5