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