Char Value in SQL Server

[shangrilla]

name is a char field stored as null in the database. I send name to the following function, but It never returns true.


static private bool checkSpaces(char name)
{
bool val=false;
try
{
if (name.Equals("&quot || name.Equals(null) || Convert.IsDBNull(name))
val =true;
}
catch
{val= false;}
return val;
}

 

[obislavu]

Convert.IsDBNull(value) returns true if and only if the value is of type TypeCode.DBNull; otherwise, false. "name" is a char , so never will return true.
name never will be equal to "" because name is a char and "" is a string.
Regarding your code:
name never will be equal to null because char is a value type and null is the NULL object.

-obislavu-

 

[chiph]

Right - you need to check for DBNull against the ADO field object, not a char-type object.

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first

 

[shangrilla]

obislavu:

Thanks for your very descriptive explanation. Learning something new everyday. Do you know of a way to check if a char field is empty/null?