Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 24th, 2009, 11:31 AM
Registered User
 
Join Date: Aug 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Conversion from type 'DBNull' to type 'Boolean' is not valid.

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 />
Reply With Quote
  #2 (permalink)  
Old October 24th, 2009, 09:42 PM
Friend of Wrox
 
Join Date: Nov 2007
Location: Central Florida, USA.
Posts: 207
Thanks: 2
Thanked 15 Times in 15 Posts
Default It's due to null...

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:

Code:
Select Grade, isnull(OT, 'True') as OT, isnull(PT,'True') as PT from myTable
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conversion from type 'DBNull' to type 'Boolean' is not valid. alcsew ASP.NET 2.0 Basics 4 October 28th, 2009 03:38 AM
Conversion from type 'DBNull' to type 'Boolean' is not valid. alcsew ASP.NET 2.0 Basics 0 October 24th, 2009 11:25 AM
Conversion from type 'DBNull' to type 'String' is not valid. phuc2583 ASP.NET 3.5 Professionals 4 October 1st, 2009 09:46 AM
Conversion from type 'DBNull' to type 'String' is GailCG ASP.NET 2.0 Basics 5 February 22nd, 2007 03:12 PM
Conversion from type 'DBNull' to type 'Boolean' is steve35719 VB Databases Basics 4 June 29th, 2006 06:13 PM



All times are GMT -4. The time now is 07:20 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.