why DataGridBoolCol umn seems read only

[Ryan Liu]

Hi,

I have a strange problem, should be very simple, take me days I couldn't
finger out.
Really appreciate if you can help me fine the problem.

I am trying to use DataGridBoolCol umn, but I just can not check/unckeck the
checkbox with this column.

I can edit other DataGridTextBox Column in the same grid. So it is not read
only.

It can load data from db, so the mapping is right.

DataGridBoolCol umn stopUseColumnSt yle = new DataGridBoolCol umn();
stopUseColumnSt yle.AllowNull = false;
stopUseColumnSt yle.MappingName = "stop_use";
stopUseColumnSt yle.HeaderText= "STOP USE";
stopUseColumnSt yle.ReadOnly = false;
stopUseColumnSt yle.Width = 75;
stopUseColumnSt yle.FalseValue = false;
stopUseColumnSt yle.TrueValue = true;
myGridStyle.Gri dColumnStyles.A dd(stopUseColum nStyle);

DataColumn dcStopUse = new DataColumn("sto p_use", typeof(bool));
dcStopUse.Allow DBNull = false;
dcStopUse.Defau ltValue = false;
dt.Columns.Add( dcStopUse);
string selectSql = "select id, name, description, stop_use from skill" ;

MySqlConnection myDbcon = (MySqlConnectio n)conn;
MySqlDataAdapte r myDA = new MySqlDataAdapte r(selectSql,myD bcon );
myDA .Fill( dt);

I had similar code elsewhere for other db tables, works just fine.

I compared and compared, just can not find the difference and the problem.

Thanks a lot!
Ryan Liu