string SQLString;
SQLString = @"SELECT tblServers.ID, tblServers.ServerName, tblServers.Status
FROM (tblServers)";
OleDbCommand SQLQuery = new OleDbCommand();
DataTable data = null;
dataGridViewJidoka.DataSource = null;
SQLQuery.Connection = null;
OleDbDataAdapter dataAdapter = null;
dataGridViewJidoka.Columns.Clear();
SQLQuery.CommandText = SQLString;
SQLQuery.Connection = database;
data = new DataTable();
dataAdapter = new OleDbDataAdapter(SQLQuery);
dataAdapter.Fill(data);
dataGridViewServers.DataSource = data;
dataGridViewServers.AllowUserToAddRows = false;
dataGridViewServers.ReadOnly = true;
dataGridViewServers.Columns[0].Visible = false;
dataGridViewServers.Columns[1].Width = 140;
dataGridViewServers.Columns[2].Width = 53;
In order to be able to check/uncheck a checkbox column imported from the data base into a datagridview, youu have to modify the underlined line of code like this:
dataGridViewServers.ReadOnly = false;
. now it will work just fine.