Null values in a datagrid checkbox column

[Rock]

I have a checkbox column in a bound datagrid that returns an error when it
hits a null value: [FormatException: Input string was not in a correct
format.]

I can't modify the sql query to anticipate a null value, how can I do this
programmatically or in html code? Such as in the ItemDataBound even of the
datagrid?? Thanks for any help.


<asp:TemplateColumn HeaderText="Validated">
<ItemTemplate>
<asp:checkbox id=chk1 runat="server" Checked='<%#
DataBinder.Eval(Container.DataItem,"Validated") %>'>
</asp:checkbox>
</ItemTemplate>
</asp:TemplateColumn>

 

[Ken Cox [Microsoft MVP]]

Hi,

One way is to use a helper function. Pass the (possibly) null value into it,
test for dbnull and return a boolean. Some code below.

Does this help?

Ken
Microsoft MVP [ASP.NET]
Toronto

Function fixnull(ByVal blnIn As Object) _
As Boolean
If IsDBNull(blnIn) Then
Return False
End If
Return CType(blnIn, Boolean)
End Function

<asp:templatecolumn HeaderText="Validated">
<itemtemplate>
<asp:checkbox id="chk1" runat="server"
Checked='<%# fixnull( DataBinder.Eval(Container.DataItem,"Validated") )%>'>
</asp:checkbox>
</itemtemplate>
</asp:templatecolumn>