Urgent: DBNull error

supernova122 · December 10th, 2013, 05:34 AM

Using Visual Studio 2008 and generating .net 2.0 framework with VB.net for a web application.

I encountered a very strange problem currently. After I build a solution and click a link in a web page, I got an error message as following. The same thing happened when I tried to run in debug mode.

************* Error ***************************************
"An exception of type 'System.InvalidCastException' occurred in Microsoft.VisualBasic.dll but was not handled in user code"

"Additional information: Operator '=' is not defined for type 'DBNull' and string "". "
************************************************** ********

The problem part is simply as below in a vb file. The value of dataview(0)(ânameâ) is NULL and my_name is a variable string. The strange is thing I didnât change any code in this vb file. This vb file was built previously and used for a long time ago without any problem. It just suddenly happened today. I have this syntax all over the program without causing any problem. I have tried to restore the whole solution back to original but still have the problem. Can anyone please advise why all the sudden and how to fix? Thanks.

âIf dataview(0)(ânameâ) = my_name then â¦â

Imar · December 10th, 2013, 02:36 PM

This could be caused by the database containing a Null value where previously it didn't. So, this problem could occur even without a change to the code. Check your database to see if that's the case and then determine if that's desirable or not.

Cheers,

Imar

supernova122 · December 10th, 2013, 09:21 PM

I checked. In fact, I have DB Null in the value of the column before and worked before. Thanks.

Imar · December 11th, 2013, 10:56 AM

Are you sure? You get the error you mentioned when you compare a value in the database that is Null. You should compare it with DbNull instead.

Cheers,

Imar