Problem with System.InvalidCastException:

[neomax]

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


Line 313: end if
Line 314: publishername = "N/A"
Line 315: if rs.item("publisherid")>0 then publishername = rs.item("publishername")
Line 316: articleid=rs.item("articleid")
Line 317: %>


Source File: somefile.aspx
Line: 315

What it can be?

 

[vbkris]

if rs.item("publisherid")>0 then publishername = rs.item("publishername")
Line 316:    articleid=rs.item("articleid")

one of those columns have a null value.

2 ways to solve this:
a. At the query end (use isNull function)
b. .NET end (check each column is of type dbnull)

Known is handfull, Unknown is worldfull