ASP.NET CheckBox in DataTable

Question

I added a checkbox into my datatable

Initialization

 DataTable dt = new DataTable();
 DataRow dr = null;

Adding the checkbox

dt.Columns.Add(new DataColumn("CheckBoxCol", typeof(CheckBox)));

Add this new row

dr = dt.NewRow();

Problem happen when I try to initialize initial state of the checkbox of the new row

((CheckBox)dr["CheckBoxCol"]).Checked = false;

There was exception thrown that says:

Unable to cast object of type 'System.DBNull' to type *'System.Web.UI.WebControls.CheckBox'.*

Is my method wrong? Can someone advice how to cast back the DataColumn back to be CheckBox?

Anand · Accepted Answer · 2011-12-29 09:02:33Z

1

Why do you want to add check box to a datatable ? If you want to store some value, which would be used to populate a CheckBox, then suggest you to store values as Bool.

Even if you want to store the checkBox in datacolumn, then you have to do it like this

 DataTable dt = new DataTable();
 dt.Columns.Add(new DataColumn("Check", typeof(System.Web.UI.WebControls.CheckBox)));
 DataRow dr = dt.NewRow();
 CheckBox ck = new CheckBox();
 ck.Checked = true;
 dr["Check"] = ck;
 dt.Rows.Add(dr);

Since column would store reference type, then first you have to create an instance of it, set its value and then store it in the DataColumn.

If you are simply using OneColumn DataTable. I would suggest you to use List<CheckBox> which would make more sense.

 List<CheckBox> checkBoxList = new List<CheckBox>();
        CheckBox ck = new CheckBox();
        ck.Checked = true;
        checkBoxList.Add(ck);

edited Dec 29, 2011 at 9:02

answered Dec 29, 2011 at 8:56

Anand

15k8 gold badges35 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

rofans91 Over a year ago

Can you suggest me some snippets or workaround to actually do it?

Anand Over a year ago

I had run this code on my machine and was working fine. Paste your code.

Remy · Accepted Answer · 2011-12-29 08:46:54Z

0

What value is in the DataColumn? Sounds like it's a NULL value? And anyway, you cannot cast a datacolum to a Checkbox.
A checkbox is always false by default, so you don't need that.

answered Dec 29, 2011 at 8:46

Remy

12.8k14 gold badges66 silver badges106 bronze badges

1 Comment

rofans91 Over a year ago

I also need the casting to figure whether the CheckBox.Checked is TRUE or FALSE, not only to do the initialization. And when I tried, the same exception was thrown. Yes since the value is NULL therefore I need to initialize the value....

Collectives™ on Stack Overflow

ASP.NET CheckBox in DataTable

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related