Image via Wikipedia05-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!
I have began my journey to learning Silverlight and Ajax. I have completed my first books, 
With these 2 books completed, I've grabbed a few others that will continue my learning of Silverlight and Ajax, what I believe to be the future of 
String to StringBuilder, AJAX, Silverlight
String to StringBuilder
AJAX
And these are some of the big things that I have 'learned' in my week-long course, so hopefully, I now will be a better software developer.
![Reblog this post [with Zemanta]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_scjDzEHcvMj83eTRIHyDpTggaFWFGr8TPvk51Y6C1Gtn4ZDxlYuPKfjmp0zVFJOVXWG2NZ-IwrtmrVwUXq-9qd0q98QEzRc9L7FXO7oQj4GiXIO5JJF5hUQKf7eIeWqR4tAsHhxvvvFAO6zYGK3Si7=s0-d)
![Reblog this post [with Zemanta]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_s4Nlrv1oPzEZWQC640Ak0o-uGXFyspuY-Xtd09y6YyOjcauchKyf6WG68TATD--esJihM9oJ0ldIPcogR5UU9RFGW2kBR3AtnXZoAF9OAm2Y1v15CiI1eLztGyUd82cCuph-ii7BD_wkA8Ab6hoCXD=s0-d)
