[RESOLVED] datagridview column formatting

[jlbantang]

hi guru's Im trying to format datagridview column to a checkbox as its column is assigned to msaccess YES/NO data type.

DataGridView.Columns(2).DefaultCellStyle.Format = "Bit"

AND

DataGridView.Columns(2).DefaultCellStyle.Format = "Boolean"

is there anyway to do this. thanks.

[ForumAccount]

Use a DataGridViewCheckBoxColumn

[jmcilhinney]

If you simply populate a DataTable from your database and bind that to the grid then it will use a check box column automatically. Any particular reason you're not doing that?

[jlbantang]

If you simply populate a DataTable from your database and bind that to the grid then it will use a check box column automatically. Any particular reason you're not doing that?

I agree unless there something wrong in the code.

            With _grid
                .DataSource = Nothing

                .DataSource = dtDataGrid

                'hide column 0 
                .Columns(0).Visible = False

                .SelectionMode = DataGridViewSelectionMode.FullRowSelect
                .Cursor = Cursors.Hand

                If _readonly Then
                    .ReadOnly = True
                    .AllowUserToAddRows = False
                End If
            End With

[Nitesh]

otherwise just create a checkboxcolumn and bind it to the appropriate column:

Dim checkboxcolumn As New DataGridViewCheckBoxColumn

checkboxcolumn.HeaderText = "Test"
            checkboxcolumn.DataPropertyName = "TestColumn"
            checkboxcolumn.DisplayIndex = 3

            With dgvTest
                .Columns.Add(checkboxcolumn)
            end with

[jlbantang]

Nitesh: the code work indeed as it ADD a column with checkbox format but it doesnt solve the issue. I just want the column to be formatted as checkbox.

i did it like this:

        Dim checkboxcolumn As New DataGridViewCheckBoxColumn

        borrowerloanDataGridView.Columns(2).DefaultCellStyle = checkboxcolumn

obviously it has convertion error

[jmcilhinney]

There's no such thing as "formatting a column as checkbox". If you want a column of check boxes then you use a DataGridViewCheckBoxColumn, plain and simple. You can't use some other type of column, e.g. a DataGridViewTextBoxColumn, and then somehow change its type to display check boxes. Each different type of column is designed to host a different type of control. If you want check boxes you use a DataGridViewCheckBoxColumn.

The DefaultCellStyle has absolutely nothing to do with this. The control hosted in the cells of a column is nothing to do with format.

There's also no reason for you to have any code for this. You should be adding the column in the designer. If you need to bind it to a column or property in the grid's DataSource then you need to set the column's DataPropertyName.

[jlbantang]

Right, and i found out it was TOTALLY a WRONG column passed in sql-select.

OMG!!!

Thanks anyway.