Hi,

This is my second time trying to post this to this site so I appologize if its a repeat as the the first one didn't appear to go through.

I'm new to asp.net and am getting the error posted below. I have a formview and it contains fields OT and PT, which are set in the DB as allowing nulls. From what I've found googling this error, I will need codebehind but do not know what to write or what event to post in under.

Any help would be greatly apprecited.

Thanks,
Leesha
__________________________________________________ ____________

Conversion from type 'DBNull' to type 'Boolean' is not valid.

Source Error:


Line 402: <asp:Label ID="GradeLabel" runat="server" Text='<%# Bind("Grade") %>'></asp:Label><br />
Line 403: OT:
Line 404: <asp:CheckBox ID="OTCheckBox" runat="server" Checked='<%# Bind("OT") %>' Enabled="false" /><br />
Line 405: PT:
Line 406: <asp:CheckBox ID="PTCheckBox" runat="server" Checked='<%# Bind("PT") %>' Enabled="false" /><br />

If you have a field in your db that has no value (null) you code doesn't know what to do with it. Since the check setting requires a boolean (True False) it can't interpret a null. One way around this is to set a default when adding a row to the database. If there is no value chosen OT set it to True and same for PT...

For the rows you already have in the DB you will have to handle them so your code won't bomb out. Assuming you are using MSSQL you can use an isnull statement. Basically it looks like this:

I hope this helps! Also please try not to double post. We will see it the first time you post it. 2 of the same thing just boggs things down.

__________________
Jason Hall

Follow me on Twitter @jhall2013