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.
Namespace: System.Data.Odbc Assembly: System.Data (in system.data.dll)
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.