Bind checkbox on DB initial null value

Question

I need to bind a checkBox but with this line of code,

<asp:CheckBox ID="CheckBoxRed" runat="server"  Checked='<%# Bind("red") %>'/>

because initially the value in the DB is null, I get an invalid cast. I therefore tried in this way:

 <asp:CheckBox ID="CheckBoxRed" runat="server"  Checked='<%# (DataBinder.Eval(Container.DataItem,"red") is DBNull ?false:Eval("red")) %>'/>

This avoids the initial invalid cast but if I check the checkbox the value is not saved to the db. Is there a way to avoid the initial invalid cast and get the checked/unchecked status saved into the db?

I already checked this answer but it does not bind the value.

Does it work if you change Eval("red") to Bind("red") in your second version? If not, maybe try to convert nulls to false in DataSource before binding? — PrzemG
– PrzemG, Commented Jun 9, 2014 at 16:23

Ali Umair · Accepted Answer · 2014-06-10 06:22:08Z

0

Try using this

<asp:CheckBox ID="CheckBoxRed" runat="server"  Checked='<%# Boolean.Parse(Eval("IsActive").ToString()) ? true : false%>'/>

answered Jun 10, 2014 at 6:22

Ali Umair

1,4241 gold badge22 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Bind checkbox on DB initial null value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related