[thelist] Null Value from a database to a string?

Casey Crookston casey at thecrookstons.com
Wed Dec 29 11:36:16 CST 2004

asp.net in vb...

I'm populating a form from a database row.  There's a column in the db for
address and address2 incase the user needs a second line for their address.
In the db address2 is allowed a null value, but when trying to populate the
form I get this error:

Cast from type 'DBNull' to type 'String' is not valid.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Cast from type 'DBNull' to
type 'String' is not valid.

Source Error:

Line 95:   baddress2.text=mySingleMemberDtr("b_address2")

Makes sense, I guess.  It won't let a null value be passed into a text
string.  What can I do to allow a null value to be entered. I REALLY don't
want to have to force the user to enter something like "n/a" into the field
if it is empty.  Or, what's the best way to have a value look empty when
it's not?


More information about the thelist mailing list