'Declaration Public Overrides Function ExecuteScalar() As Object
public override object ExecuteScalar()
Return Value
The first column of the first row in the result set.
'Declaration Public Overrides Function ExecuteScalar() As Object
public override object ExecuteScalar()
using(QuickBooksConnection conn = new QuickBooksConnection(connectionString)) { conn.Open(); QuickBooksCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT count(*) as NumberOfRegions FROM regions"; Int64 count = Convert.ToInt64(cmd.ExecuteScalar()); }
Dim conn As New QuickBooksConnection(connectionString) conn.Open() Dim cmd As QuickBooksCommand = conn.CreateCommand() cmd.CommandText = "SELECT count(*) as NumberOfRegions FROM regions" Dim count As Int64 = Convert.ToInt64(cmd.ExecuteScalar()); conn.Close()