When SxecuteScalar() returns null

Image via Wikipedia

05-Dec-2011

I was working on a new web page today, and I decided to use ExecuteScalar() as my method to fetch a singular data that returns a string.

I completed the whole code, and during debugging, I encountered some issues. One of them is simply throwing an exception, and when I stepped through, I found that it was due to a null value being returned by the ExecuteScalar() procedure.

I then checked from the web on possible solutions to this problem, and after putting in all the patches, all scenarios can now be handled.

Here’s how it works. Detect first if the return value is null, then handle it appropriately:

if (cmd.ExecuteScalar() == null)

{

:

:

}

An else clause is then added to handle possible return values other than null:

else

{

bfrResult = cmd.ExecuteScalar().ToString();

:

:

}

And that’s all there is to it. Hope that this helps you also, as it did me.

Till then!

Related articles

• Order of executions or ExecuteScalar issue (stackoverflow.com)
• In which situation use ExecuteReader , Executenonquery and ExecuteScalar (bhavik4u.wordpress.com)
• Result of calling IEquatable.Equals(T obj) when this == null and obj == null? (stackoverflow.com)
• It's all about context (stonehenge.com)
• Writing functions in c++ (stackoverflow.com)
• [ADO.NET Tutorial] Lesson 03: Đối tượng SqlCommand (yinyangit.wordpress.com)
• Anatomy of a CRUTEM3 bug (jgc.org)
• Null (jonathanlewis.wordpress.com)
• Accessing a static field with a NULL object in Java (stackoverflow.com)