IsDBNULL Error ~ Help Please....

[Brad Isaacs]

I am using ASP.NET 2.0 codebehind Visual Basic, Visual Studio 2005

Working with DataSet creating a Data Access Layer via VS 2005.

My error is when the code that is prewritten by VS 2005 Casts to String but
the data inside the column is a NULL.

Code prewritten by visual studio:
<System.Diagnos tics.DebuggerNo nUserCodeAttrib ute()_

Public Property SuiteFloor() As String

Get

Try

Return CType(Me(Me.tab leaspnet_getMyI nfo.SuiteFloorC olumn),String)

Catch e As System.InvalidC astException

Throw New System.Data.Str ongTypingExcept ion("The value for column
'SuiteFloor' in table 'aspnet_getMyIn fo' is DBNull.", e)

End Try

End Get

Set

Me(Me.tableaspn et_getMyInfo.Su iteFloorColumn) = value

End Set

End Property

It throws an error becuase the value in the database is NULL.
{"The value for column 'SuiteFloor' in table 'aspnet_getMyIn fo' is DBNull."}

I tried to perform this code in my .aspx page:
Public Sub populateMyInfoD ata(ByVal orgID As String)

Dim MyInfoDataAdapt er As New
dsMyInfoTableAd apters.aspnet_g etMyInfoDataTab leAdapter

Dim MyInfoData As dsMyInfo.aspnet _getMyInfoDataD ataTable

Dim cc As dsMyInfo.aspnet _getCrownCorpDa taRow

MyInfoData = crownDataAdapte r.GetData_Byorg IDLanguageID(la nguageID, orgID)

For Each cc In MyInfoData

'Response.Write ("Suite/Floor: " & cc.SuiteFloor & "<br>")

'Response.Write ("Street Address: " & cc.StreetAddres s & "<br>")

'On all fields below,

'Check that the field does not contain a NULL value

'SuiteFloor

If IsDBNull(cc.Sui teFloor) Then

txtSuiteFloor.T ext = ""

Else

txtSuiteFloor.T ext = cc.SuiteFloor

End If
This had no affect because the error is THROWN when inside the Property
method.

Does anyone have any ideas how to resolve this issue?

Thanks in advance,

~Brad

------------------------------
Brad Isaacs
bi*****@rogers. com

[Alexey Smirnov]

On Feb 15, 9:14 pm, "Brad Isaacs" <bisa...@rogers .comwrote:

I am using ASP.NET 2.0 codebehind Visual Basic, Visual Studio 2005

Working with DataSet creating a Data Access Layer via VS 2005.

My error is when the code that is prewritten by VS 2005 Casts to String but
the data inside the column is a NULL.

Code prewritten by visual studio:
<System.Diagnos tics.DebuggerNo nUserCodeAttrib ute()_

Public Property SuiteFloor() As String

Get

Try

Return CType(Me(Me.tab leaspnet_getMyI nfo.SuiteFloorC olumn),String)

Catch e As System.InvalidC astException

Throw New System.Data.Str ongTypingExcept ion("The value for column
'SuiteFloor' in table 'aspnet_getMyIn fo' is DBNull.", e)

>From the first look, the error is System.InvalidC astException.

Comment "Throw New System.Data.Str ongTypingExcept ion......." line to
see the real error message.

[Brad Isaacs]

Alexey,

I did as you mentioned and received the same error:

InnerException: ::{"Conversion from type 'DBNull' to type 'String' is not
valid."}

In addition, this code is prewritten by Visual Studio 2005 and everytime I
comment out a line, it just recreates the file with a new name.
Any ideas???

very frustrating.... .............
"Alexey Smirnov" <al************ @gmail.comwrote in message
news:11******** **************@ k78g2000cwa.goo glegroups.com.. .

On Feb 15, 9:14 pm, "Brad Isaacs" <bisa...@rogers .comwrote:

>I am using ASP.NET 2.0 codebehind Visual Basic, Visual Studio 2005

Working with DataSet creating a Data Access Layer via VS 2005.

My error is when the code that is prewritten by VS 2005 Casts to String
but
the data inside the column is a NULL.

Code prewritten by visual studio:
<System.Diagno stics.DebuggerN onUserCodeAttri bute()_

Public Property SuiteFloor() As String

Get

Try

Return CType(Me(Me.tab leaspnet_getMyI nfo.SuiteFloorC olumn),String)

Catch e As System.InvalidC astException

Throw New System.Data.Str ongTypingExcept ion("The value for column
'SuiteFloor' in table 'aspnet_getMyIn fo' is DBNull.", e)

>>From the first look, the error is System.InvalidC astException.

Comment "Throw New System.Data.Str ongTypingExcept ion......." line to
see the real error message.

[Brad Isaacs]

Show output from Debug:

A first chance exception of type 'System.Invalid CastException' occurred in
Microsoft.Visua lBasic.dll

A first chance exception of type 'System.Data.St rongTypingExcep tion'
occurred in App_Code.pcnwys he.dll

"Alexey Smirnov" <al************ @gmail.comwrote in message
news:11******** **************@ k78g2000cwa.goo glegroups.com.. .

On Feb 15, 9:14 pm, "Brad Isaacs" <bisa...@rogers .comwrote:

>I am using ASP.NET 2.0 codebehind Visual Basic, Visual Studio 2005

Working with DataSet creating a Data Access Layer via VS 2005.

My error is when the code that is prewritten by VS 2005 Casts to String
but
the data inside the column is a NULL.

Code prewritten by visual studio:
<System.Diagno stics.DebuggerN onUserCodeAttri bute()_

Public Property SuiteFloor() As String

Get

Try

Return CType(Me(Me.tab leaspnet_getMyI nfo.SuiteFloorC olumn),String)

Catch e As System.InvalidC astException

Throw New System.Data.Str ongTypingExcept ion("The value for column
'SuiteFloor' in table 'aspnet_getMyIn fo' is DBNull.", e)

>>From the first look, the error is System.InvalidC astException.

Comment "Throw New System.Data.Str ongTypingExcept ion......." line to
see the real error message.

[Alexey Smirnov]

On Feb 15, 10:42 pm, "Brad Isaacs" <bisa...@rogers .comwrote:

Show output from Debug:

A first chance exception of type 'System.Invalid CastException' occurred in
Microsoft.Visua lBasic.dll

It's here:

If IsDBNull(cc.Sui teFloor) Then

because cc.SuiteFloor is trying to return
CType(Me(Me.tab leaspnet_getMyI nfo.SuiteFloorC olumn),String) where
SuiteFloorColum n has DbNull value.

Why not to do the following:

Public Property SuiteFloor() As String
Get
Try
if isDbNull(Me.tab leaspnet_getMyI nfo.SuiteFloorC olumn)
Return ""
else
Return CType(Me(Me.tab leaspnet_getMyI nfo.SuiteFloorC olumn),String)
Catch e As System.InvalidC astException
Throw New System.Data.Str ongTypingExcept ion("The value for column
'SuiteFloor' in table 'aspnet_getMyIn fo' is DBNull.", e)
End Try
End Get

or

Public Property SuiteFloor() As String
Get
Try
Return CType(Me(Me.tab leaspnet_getMyI nfo.SuiteFloorC olumn),String)
Catch e As System.InvalidC astException
return ""
End Try
End Get

and then instead the

If IsDBNull(cc.Sui teFloor) Then
txtSuiteFloor.T ext = ""
Else
txtSuiteFloor.T ext = cc.SuiteFloor
End If

do simple

txtSuiteFloor.T ext = cc.SuiteFloor