 |  | Devart.Data | Send comments on this topic. |
| Devart.Common Namespace > DbCommandBase Class : ExecuteScalar Method |
| | Devart.Data | Send comments on this topic. |
| Devart.Common Namespace > DbCommandBase Class : ExecuteScalar Method |
Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.
[Visual Basic]
Overrides Public Function ExecuteScalar() As Object [C#]
public override object ExecuteScalar();The first column of the first row in the result set.
Use the ExecuteScalar method to retrieve a single value (for example, an aggregate value) from a database. This requires less code than using the ExecuteReader method, and then performing the operations necessary to generate the single value from the data returned by a DbDataReader.
This example shows typical usage of ExecuteScalar method
[C#]
using(OracleConnection conn = new OracleConnection(connectionString)) {
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT count(*) as NumberOfRegions FROM regions";
Int64 count = Convert.ToInt64(cmd.ExecuteScalar());
} [Visual Basic]
Dim conn As New OracleConnection(connectionString)
conn.Open()
Dim cmd As OracleCommand = conn.CreateCommand()
cmd.CommandText = "SELECT count(*) as NumberOfRegions FROM regions"
Dim count As Int64 = Convert.ToInt64(cmd.ExecuteScalar());
conn.Close()DbCommandBase Class | DbCommandBase Members
© 2002 - 2013 Devart. All Rights Reserved.