DataGridBoolColumn

[Vipul Bhatt]

It does not reflect db values. It shows greyed checked checkboxes.
please help me out.

Thanx for your earlier answers.This service is excellent.I haven't found any thing like it on the net.KEEP IT UP.
Thanx once again.

[Clay Burch]

If you are using custom column styles, then setting the AllowNull property on the bool columnstyle will avoid the tri-state checkbox.

((DataGridBoolColumn)boolCol).AllowNull = false;

You can take a look at the FAQ below that shows how you can add a column of checkboxes to your datagrid. You should also set the AllowDBNull propery to false on the DataColumn which is a member of the Columns collection on your datatable.

[Vipul Bhatt]

> If you are using custom column styles, then setting the AllowNull property on the bool columnstyle will avoid the tri-state checkbox.
>
> ((DataGridBoolColumn)boolCol).AllowNull = false;
>
> You can take a look at the FAQ below that shows how you can add a column of checkboxes to your datagrid. You should also set the AllowDBNull propery to false on the DataColumn which is a member of the Columns collection on your datatable.

Ok. I will try this, but as such Clay there are no null values currently in DB. Yet it shows grayed checked checkbox.
Thanx.

[Vipul Bhatt]

> If you are using custom column styles, then setting the AllowNull property on the bool columnstyle will avoid the tri-state checkbox.
>
> ((DataGridBoolColumn)boolCol).AllowNull = false;
>
> You can take a look at the FAQ below that shows how you can add a column of checkboxes to your datagrid. You should also set the AllowDBNull propery to false on the DataColumn which is a member of the Columns collection on your datatable.

Ok. I will try this, but as such Clay there are no null values currently in DB. Yet it shows grayed checked checkbox.
Thanx.

[Vipul Bhatt]

> > If you are using custom column styles, then setting the AllowNull property on the bool columnstyle will avoid the tri-state checkbox.
> >
> > ((DataGridBoolColumn)boolCol).AllowNull = false;
> >
> > You can take a look at the FAQ below that shows how you can add a column of checkboxes to your datagrid. You should also set the AllowDBNull propery to false on the DataColumn which is a member of the Columns collection on your datatable.
>
> Ok. I will try this, but as such Clay there are no null values currently in DB. Yet it shows grayed checked checkbox.
> Thanx.

Hi Clay.Sorry but it didn't work. Below is the code that i used

Dim ss As DataGridBoolColumn
ss = New DataGridBoolColumn()
ss.AllowNull = False
ss.Width = 45
ss.MappingName = "Status"
ss.HeaderText = "Status"
ss.Alignment = HorizontalAlignment.Right
tsx.GridColumnStyles.Add(ss)

[Clay Burch]

Is this columnstyle being used for the column? For example, if you change the width to 200, do you see a wider column? If it is not being used, then you need to figure out why.

[Vipul Bhatt]

> Is this columnstyle being used for the column? For example, if you change the width to 200, do you see a wider column? If it is not being used, then you need to figure out why.

Hi Clay.
I have attatched a small picture file with this.
It shows above 2 checkboxes(Unchecked) reflecting the database value(i.e. the value is 0[Unchecked])
You can see the same record selected in the datagrid (marked blue). Is there any property I have to set for reflecting DB value

[Vipul Bhatt]

Kindly check a small picture file with this.

The 2 checkboxes(Unchecked) above reflects the database values(i.e. value=0[Unchecked])
You can see the same record selected in the datagrid below (as selected row).
Is there any property I have to set for reflecting DB value
Thanx.

[Clay Burch]

Have you set AllowDBNull to False for your datacolumn? The online help has a code snippet. You use the Columns collection on your datatable. Maybe something like

MyTable.Columns(3).AllowDBNull = False

[Vipul Bhatt]

> Have you set AllowDBNull to False for your datacolumn? The online help has a code snippet. You use the Columns collection on your datatable. Maybe something like
>
> MyTable.Columns(3).AllowDBNull = False

Sorry Clay, but it does not work.

[Vipul Bhatt]

> > Have you set AllowDBNull to False for your datacolumn? The online help has a code snippet. You use the Columns collection on your datatable. Maybe something like
> >
> > MyTable.Columns(3).AllowDBNull = False
>
>
> Sorry Clay, but it does not work.

Can U please look into it.
Thanx a lot.

[Vipul Bhatt]

> > > Have you set AllowDBNull to False for your datacolumn? The online help has a code snippet. You use the Columns collection on your datatable. Maybe something like
> > >
> > > MyTable.Columns(3).AllowDBNull = False
> >
> >
> > Sorry Clay, but it does not work.
>
> Can U please look into it.
> Thanx a lot.

Hi Clay.
Clay there is no response from you.

[Vipul Bhatt]

> > > > Have you set AllowDBNull to False for your datacolumn? The online help has a code snippet. You use the Columns collection on your datatable. Maybe something like
> > > >
> > > > MyTable.Columns(3).AllowDBNull = False
> > >
> > >
> > > Sorry Clay, but it does not work.
> >
> > Can U please look into it.
> > Thanx a lot.
>
> Hi Clay.
> Clay there is no response from you.

Clay i just found the ans for displaying the checkbox in the datagrid. I am using SQL server.
I had defined that field as smallint. When i changed it to 'bit' it worked.

A BIG THANX for all your support.

[Michael Sparks]

I ran into the same problem having a field defined as smallint. Unfortunately, I could not change the field datatype to bit.
My solution was to build the dataset's table and columns in code and set the column of interest to a System.Boolean.

For example:
DataTable dt = new DataTable("Table");
DataColumn idColumn = new DataColumn("ID", System.Type.GetType("System.Int16"));
DataColumn columnOfInterestColumn = new DataColumn("ColumnOfInterest", System.Type.GetType("System.Boolean"));
dt.Columns.Add(idColumn);
dt.Columns.Add(columnOfInterestColumn);
ds.Tables.Add(dt);

HTH,
Michael

> > > > > Have you set AllowDBNull to False for your datacolumn? The online help has a code snippet. You use the Columns collection on your datatable. Maybe something like
> > > > >
> > > > > MyTable.Columns(3).AllowDBNull = False
> > > >
> > > >
> > > > Sorry Clay, but it does not work.
> > >
> > > Can U please look into it.
> > > Thanx a lot.
> >
> > Hi Clay.
> > Clay there is no response from you.
>
>
> Clay i just found the ans for displaying the checkbox in the datagrid. I am using SQL server.
> I had defined that field as smallint. When i changed it to 'bit' it worked.
>
> A BIG THANX for all your support.

[Administrator]

I had a similar problem with the dataGridBoolColumn.I just had to change the Datagrid property readonly to false and worked fine

>I ran into the same problem having a field defined as smallint. Unfortunately, I could not change the field datatype to bit.
>My solution was to build the dataset''s table and columns in code and set the column of interest to a System.Boolean.
>
>For example:
>DataTable dt = new DataTable("Table");
>DataColumn idColumn = new DataColumn("ID", System.Type.GetType("System.Int16"));
>DataColumn columnOfInterestColumn = new DataColumn("ColumnOfInterest", System.Type.GetType("System.Boolean"));
>dt.Columns.Add(idColumn);
>dt.Columns.Add(columnOfInterestColumn);
>ds.Tables.Add(dt);
>
>
>
>
>HTH,
>Michael
>
>
>
>
>
>> > > > > Have you set AllowDBNull to False for your datacolumn? The online help has a code snippet. You use the Columns collection on your datatable. Maybe something like
>> > > > >
>> > > > > MyTable.Columns(3).AllowDBNull = False
>> > > >
>> > > >
>> > > > Sorry Clay, but it does not work.
>> > >
>> > > Can U please look into it.
>> > > Thanx a lot.
>> >
>> > Hi Clay.
>> > Clay there is no response from you.
>>
>>
>> Clay i just found the ans for displaying the checkbox in the datagrid. I am using SQL server.
>> I had defined that field as smallint. When i changed it to ''bit'' it worked.
>>
>> A BIG THANX for all your support.

[Sevil Bähr]

use this code:
myDataset.Tables[0].Columns[myIndex].DefaultValue=0;

[Swapnil]

If you are using custom column styles, then setting the AllowNull property on the bool columnstyle will avoid the tri-state checkbox. ((DataGridBoolColumn)boolCol).AllowNull = false; You can take a look at the FAQ below that shows how you can add a column of checkboxes to your datagrid. You should also set the AllowDBNull propery to false on the DataColumn which is a member of the Columns collection on your datatable.

Need Community Edition

[SaBrena Toler]

Hello Vipul, 

We thank you for your interest in our controls.  I have forwarded your inquiry to our Sales Department; one of our team members will contact you shortly. 

Please be advised that I am closing this incident; please let me know if you have any questions. 

Best, 

SaBrena