correct syntax for if statement to check dbnull inline asp

Question

I am looking for some help on the syntax to check for DBNull inline in asp...

<EditItemTemplate>
  <asp:CheckBox ID="Checkbox1" runat="server" Checked='<%# If(isDBNull(Eval("activeType")).Value, False, Convert.ToBoolean(Eval("activeType"))) %>'></asp:CheckBox>
 </EditItemTemplate>

Hoping someone can show me the light on this one..

Thanks,

you can use ternay operator to accomplish the same.

Nudier Mena
– Nudier Mena

2012-10-15 18:28:48 +00:00
Commented Oct 15, 2012 at 18:28 — Nudier Mena
– Nudier Mena, Commented Oct 15, 2012 at 18:28
could you provide an example?

htm11h
– htm11h

2012-10-15 18:30:29 +00:00
Commented Oct 15, 2012 at 18:30 — htm11h
– htm11h, Commented Oct 15, 2012 at 18:30
The .Value seems incorrect, remove it and try again.

Magnus
– Magnus

2012-10-15 19:04:01 +00:00
Commented Oct 15, 2012 at 19:04 — Magnus
– Magnus, Commented Oct 15, 2012 at 19:04

Scott Selby · Accepted Answer · 2012-10-15 19:18:10Z

2

you had it fine , just take out .Value , isDBNull(Eval("activeType")) this will work , you can not get the Value of dbNull , so the exception is thrown before it actually gets to check if it's null

<EditItemTemplate>
<asp:CheckBox ID="Checkbox1" runat="server" Checked='<%# If(isDBNull(Eval("activeType")), False, Convert.ToBoolean(Eval("activeType"))) %>'></asp:CheckBox>
</EditItemTemplate>

answered Oct 15, 2012 at 19:18

Scott Selby

9,58012 gold badges63 silver badges97 bronze badges

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

1 Comment

htm11h Over a year ago

UPDATE is not posting the value back to the database. Correctly removes True, but also does not place False back in database.

Collectives™ on Stack Overflow

correct syntax for if statement to check dbnull inline asp

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related