Command. Execute Scalar Method
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
public: virtual System::Object ^ ExecuteScalar();
public object ExecuteScalar ();
override this.ExecuteScalar : unit -> obj
Public Function ExecuteScalar () As Object
The first column of the first row in the result set, or a null reference if the result set is empty.
Use the ExecuteScalar method to retrieve a single value (for example, an aggregate value) from a data source. This requires less code than using the ExecuteReader method, and then performing the operations required to generate the single value from the data returned by an OdbcDataReader.