'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(ExactTargetConnection conn = new ExactTargetConnection(connectionString)) { conn.Open(); ExactTargetCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT count(*) as NumberOfRegions FROM regions"; Int64 count = Convert.ToInt64(cmd.ExecuteScalar()); }
Dim conn As New ExactTargetConnection(connectionString) conn.Open() Dim cmd As ExactTargetCommand = conn.CreateCommand() cmd.CommandText = "SELECT count(*) as NumberOfRegions FROM regions" Dim count As Int64 = Convert.ToInt64(cmd.ExecuteScalar()); conn.Close()