Change a column type to an checkbox

[Kobus]

Hi there

 

I have a column in my DataTable that is called "checked"

I want to make this a checkbox.

With this code it is not changing it:

                GridViewCheckBoxColumn checkboxcolumn = new GridViewCheckBoxColumn();
                checkboxcolumn.DataType = typeof(int);
                checkboxcolumn.Name = "checked";
                checkboxcolumn.FieldName = "checked";
                checkboxcolumn.HeaderText = "Checked?";
                this.grdIssueAcceptance.MasterTemplate.Columns.Add(checkboxcolumn);

With this it added the type nicely, but it is another field. I do not want to ADD a field. 

                GridViewCheckBoxColumn checkboxcolumn = new GridViewCheckBoxColumn();
                checkboxcolumn.DataType = typeof(int);
                checkboxcolumn.Name = "checked02";
                checkboxcolumn.FieldName = "checked02";
                checkboxcolumn.HeaderText = "Checked?";
                this.grdIssueAcceptance.MasterTemplate.Columns.Add(checkboxcolumn);

 

Regards

Kobus

[Dinko | Tech Support Engineer]

Hi Kobus,

Thank you for the provided image and code snippet.

I have checked this on my side and the column is created as expected. May I ask you to share the DataTable set-up so that I can check the data inside it and its column types?

Regards,
Dinko
Progress Telerik

[Kobus]

Hi Dinko

 

I share the DataTable below.

all the columns is string

[Kobus]

Thank you Dinko.

 

I change the type to Int and it is working perfect now.

 

Thank you for your guidance.

Regards

Kobus

[Dinko | Tech Support Engineer]

I am happy to hear that you have found a solution for your case. You are in the right direction. Basically, the checkbox expects the bool or int type of the values inside the DataTable column. If the column is a string it won't convert the value correctly.