sqlCommand.ExecuteScalar return value 'undefined value'

  • Thread starter Thread starter RA
  • Start date Start date
R

RA

How can that be? Isn't it supposed to return dbnull if there is nothing in
the select?


Ronen
 
Hi RA,

You are getting Nothing (VB) or null(C#) value.
I guess if there is nothing (not even a dbnull field) to return you get null
(DBNull is a returned Null from database)
 
ExecuteScalar returns the value of the first column of the first row of the
first resultset. if there is no resultset, then there is no value to return,
so it returns null. makes perfect sense.

-- bruce (sqlwork.com)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlCommand.ExecuteScalar problem on return value 3
SQL Server functions and TableAdapters 9
DBNull Passed as Object Type failes 3
ExecuteScalar don't return the corrent Int value. 2
lost of performance 5
Checking for DBNull 3
TableAdapter returns null for stored proc returning a single value 3
DataGridViewComboBoxColumn, Guid and DBNull problem 0

Back
Top