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.
Syntax
public override object ExecuteScalar ()
Returns
The first column of the first row in the result set, or a null reference if the result set is empty.
Remarks
Use the OleDbCommand.ExecuteScalar method to retrieve a single value, for example, an aggregate value, from a data source. This requires less code than using the OleDbCommand.ExecuteReader method, and then performing the operations that are required to generate the single value using the data returned by an System.Data.OleDb.OleDbDataReader.
A typical OleDbCommand.ExecuteScalar query can be formatted as in the following C# example:
Example
CommandText = "SELECT COUNT(*) FROM region"; Int32 count = (int32) ExecuteScalar();
Requirements
Namespace: System.Data.OleDb
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.5000.0, 2.0.0.0
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.5000.0, 2.0.0.0