getting error - Object cannot be cast from DBNull to other types.while editing status column whose data type is bit

Question

while editing the status column grid view im getting this error - Object cannot be cast from DBNull to other types.i have newly added one column status(bit,null) in table so status column having null value. while binding status column with NULL value getting error .

<asp:TemplateField HeaderText="status">
                        <ItemTemplate>
                        <asp:Label ID="lblstatus" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "status") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                        <asp:CheckBox ID="chkEditStatus" runat="server" Checked='<%# Convert.ToBoolean(Eval("status")) %>' />
                        </EditItemTemplate>
                        <FooterTemplate>
                        <asp:CheckBox ID="chkAddStatus" runat="server" Checked='<%# Convert.ToBoolean(Eval("status")) %>' />
                        </FooterTemplate>
                    </asp:TemplateField>

how to edit edititem template so that this error will not come while editing grid ?

Rahul Singh · Accepted Answer · 2015-10-15 09:02:25Z

1

That's because you are trying to convert a DBNull to Boolean, you need to check this while retrieving the data and calculate accordingly while fetching it from DB:-

bool status = reader["status"] is DBNull ? false : Convert.ToBoolean(reader["status"]);

answered Oct 15, 2015 at 9:02

Rahul Singh

21.8k6 gold badges43 silver badges61 bronze badges

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

1 Comment

Rahul Singh Over a year ago

@krishnamohan - Hey were you able to solve it? By reader I meant while fetching your data by SqlDataReader.

Collectives™ on Stack Overflow

getting error - Object cannot be cast from DBNull to other types.while editing status column whose data type is bit

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