I have a variable defined as Nullable (Of Int32). But I can't seem to assign it a value of DBNull. Seems it can only take VBNull. How the heck am I supposed to use it with a database then? The following code breaks every time a null value comes out of the database:

dim myNullableInt as Nullable (of Int32)
myNullableInt = myDataReader("myPossiblyNullField")

HELP!

Aaron

hi Aaron
this is Shakti, i work as Software Programmer.

Your query can be easily solved.
You dont have to define a nullable variable.
Just define a variable of ur required type, in this case integer.

the code goes like this (the code has been written in C#, u can transform it to VB)

int i;
if(myDataReader("myPossiblyNullField")==DBNULL.Val ue)
{
i=0;// whatever the value u want to pass for null database values.
}
else
{
i=myDataReader("myPossiblyNullField");
}


hope u find it helpful.
reply ur comments.