DataGridViewChe ckbox Column and TabControl

[trak77]

Hi All,

I'm relatively new to vb .net and am probably making a simple mistake and would appreciate any help.

I have a tab control with 4 tabs. Each tab has a DataGridView and I'm populating all 4 of them from a SQL Server db via code. The data comes from multiple tables via a UNION.

The leftmost column in each DataGridView should be a checkbox which I'm creating like this:

Dim grdCheckBoxColu mn As New DataGridViewChe ckBoxColumn
MyGrid.Columns. Add(grdCheckBox Column)

Then I execute my SQL commands. I had trouble making the checkbox checked/unchecked directly from the sql query so I kludged it by making column(1) a "*" if that row should be checked or a "" if it shouldn't and then running this:

For I = 0 To (MyGrid.RowCoun t - 1)
If MyGrid.Rows(I). Cells(1).Value = "*" Then
MyGrid.Rows(I). Cells(0).Value = true
End If
Next

This works fine for the Grid on Tab1 but doesn't work for the other grids. The funny thing is that I can set the other columns in the other grids but not the checkbox. I set the column to Read/write like this:

MyGrid.Columns( 0).ReadOnly = False
MyGridCheckBoxC olumn.ReadOnly = False

Any help would be appreciated.

Trakk77

[thewingedlion]

you can bind a datagridviewche ckbox control directly to the database without this workaround, in this case checked would be = 0 and any thing else would be unchecked, further more you can define what value for checked and what value for unchecked by using truevalue and falsevalue properties of the control.

I'm not sure what're trying to do, however if you need any further assistance please don't hesitate to contact me.