String Variable with "\0"

[Arulmanoj]

Hi All,

Am running a SQL query (Select EmpName, Address, PhoneNo, ISNULL(AddressT ype,'') FROM Employee) and assigning the results to a BO property class.
Later when i access this BO class, the AddressType string variable is having "\0".
How to check this AddressType string variable whether it has "\0" value.

I am already using != null, but this is not working.

Thanks.

[ramradha]

Hi,
Try using the String.Empty()

[arie]

check if

 yourString.CompareTo(string.Empty) != 0

[Frinavale]

I was pretty sure that you should be checking for DBNull when working with data retrieved from a database....but then again this is going to depend on how you are retrieving your data.

-Frinny