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.
public override object ExecuteScalar()
'Declaration
Public Overrides Function ExecuteScalar() As Object
Return Value
The first column of the first row in the result set.
This example shows typical usage of
ExecuteScalar method
using(SQLiteConnection conn = new SQLiteConnection(connectionString)) {
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT count(*) as NumberOfRegions FROM regions";
Int64 count = Convert.ToInt64(cmd.ExecuteScalar());
}
Dim conn As New SQLiteConnection(connectionString)
conn.Open()
Dim cmd As SQLiteCommand = conn.CreateCommand()
cmd.CommandText = "SELECT count(*) as NumberOfRegions FROM regions"
Dim count As Int64 = Convert.ToInt64(cmd.ExecuteScalar());
conn.Close()
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2