asked on

Sorting a boolean column in datagridview +vb.net 2005 windows programming

Hi,
I am struggling on how to sort a boolean column in datagridview.
When grid is bound with datatable the column has no value in it.Now when I check the row the item value of the boolean column value is true and when uncheck it the value gets false.
When the column is sorted it sorts by the false and blank value.This is a problem how do I make blank and false same when sorted.Any suggestions?

John (Yiannis) Toutountzoglou

1.What do you mean with Blank Value
2.Set the ThreeState of datagridviewCheckBoxColumn to false
me.DatagridviewCheckBoxColumn.ThreeState=False

John (Yiannis) Toutountzoglou

Otehr Question ..Isn't the column contains CheckBoxes A DatagridView CheckBoxColumn?

RIAS

ASKER

Hi,
No its a not a checkbox column it is a

dtTemp.Columns.Add("Selection", GetType(Object))
so it has a false or true value as I didnt want he checkboxes to appear in the column I created a column like the above.

RIAS

ASKER

Blank Value is dbnull value

John (Yiannis) Toutountzoglou

I think that the column add method requires string,string
Me.datagriview1.Columns.Add("ColumnName" as string,HeaderText as string)

RIAS

ASKER

But how do you add a object column to datatable.Isn't this the way
dtTemp.Columns.Add("Selection", GetType(Object))

John (Yiannis) Toutountzoglou

a sory it is a datatable...

ASKER CERTIFIED SOLUTION

John (Yiannis) Toutountzoglou