ExecuteScalar

[MDB]

Hello All, what is the correct / proper way to check for null values in the
ExecuteScalar. System.DBNull.Value, Null or both?

[=?Utf-8?B?TWlzYmFoIEFyZWZpbg==?=]

it really depends on what you need to find out about the result
if you need to test if a the row/data exists then just check for null and
you need to test if the row/data exists and has a valid value then try the
following

///
object result = cmd.ExecuteScalar();

if (result == null)
return "Customer not found";
if (result == System.DBNull.Value)
return "Customer found but name is null";
return (string) result;
///
--
Misbah Arefin
https://mcp.support.microsoft.com/profile/MISBAH.AREFIN
http://www.linkedin.com/in/misbaharefin
"MDB" wrote:

Hello All, what is the correct / proper way to check for null values in the
ExecuteScalar. System.DBNull.Value, Null or both?

[MDB]

Okay, I am not thinking straight this morning and understand now. Thanks.

"Misbah Arefin" <Mi**********@discussions.microsoft.comwrote in message
news:F1**********************************@microsof t.com...

it really depends on what you need to find out about the result
if you need to test if a the row/data exists then just check for null and
you need to test if the row/data exists and has a valid value then try the
following

///
object result = cmd.ExecuteScalar();

if (result == null)
return "Customer not found";
if (result == System.DBNull.Value)
return "Customer found but name is null";
return (string) result;
///
--
Misbah Arefin
https://mcp.support.microsoft.com/profile/MISBAH.AREFIN
http://www.linkedin.com/in/misbaharefin
"MDB" wrote:

>Hello All, what is the correct / proper way to check for null values in
the
ExecuteScalar. System.DBNull.Value, Null or both?