G
Guinness Mann
Greetings,
I'm developing database applications using C# on VS.NET 2003 and SQL
Server Standard edition (SP3a), and the Microsoft Data Application
Blocks.
I've run into a situation I'm trying to understand, to wit, if I submit
a query using SqlHelper.ExecuteScalar which returns no results, why is
the returned item a System.Object of <undefined value>?
How do I do error checking for that condition?
I guess I can sort of see why they didn't want to throw an exception --
lot's of queries don't return any results, but on the other hand, I
can't figure out how to test for <undefined value>, either.
Any ideas?
-- Rick
I'm developing database applications using C# on VS.NET 2003 and SQL
Server Standard edition (SP3a), and the Microsoft Data Application
Blocks.
I've run into a situation I'm trying to understand, to wit, if I submit
a query using SqlHelper.ExecuteScalar which returns no results, why is
the returned item a System.Object of <undefined value>?
How do I do error checking for that condition?
I guess I can sort of see why they didn't want to throw an exception --
lot's of queries don't return any results, but on the other hand, I
can't figure out how to test for <undefined value>, either.
Any ideas?
-- Rick