How to get a null value from database to a checkbox in gridview

Question

i have a checkbox in gridview.

 <asp:CheckBox  ID="chkStatus"
runat="server"
 Checked='<%#GetStatus(Eval("VaccinationCompletedStatus"))
 %>'/>

The function GetStatus is as follows

  Public Function GetStatus(ByVal objStatus As Object) As Boolean
        If objStatus = True Then
            Return True
        ElseIf objStatus = False Then
            Return False
        Else
            Return False
        End If

    End Function

But if Status is coming as null from database then one error is coming as System.DBNull cannot be cast to object.If null is coming from database i want to get checkbox checked false.

RuudKok · Accepted Answer · 2009-04-06 08:37:56Z

3

You could check for DBNull first:

If DBNull.Value.Equals(objStatus) Then
  Return False
Else
  Return objStatus
End If

answered Apr 6, 2009 at 8:37

RuudKok

5,3022 gold badges29 silver badges28 bronze badges

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

Comments

Rune Grimstad · Accepted Answer · 2009-04-06 08:38:45Z

2

Use the TypeOf function to check if the input type if a boolean. If it isn't just return false.

If TypeOf objStatus Is Boolean Then
  Your code here
Else
  Return False
End If

answered Apr 6, 2009 at 8:38

Rune Grimstad

36.5k10 gold badges66 silver badges77 bronze badges

Comments

Rd_Madnezz · Accepted Answer · 2010-08-16 08:26:47Z

1

<asp:TemplateField HeaderText="foo" >
    <ItemTemplate>    
        <asp:CheckBox  runat="server"
                    Checked='<%# Eval("foo").GetHashCode() == 1 %>'
                    Enabled="false"
                    Visible='<%# Eval("foo").GetType() == typeof(Boolean) %>' />
    </ItemTemplate>
</asp:TemplateField>

answered Aug 16, 2010 at 8:26

Rd_Madnezz

111 bronze badge

Collectives™ on Stack Overflow

How to get a null value from database to a checkbox in gridview

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related