ExecuteScalar Method

Executes the query, and returns the first column of the first row in the result set returned by the query.Additional columns or rows are ignored.

Syntax

public static string ExecuteScalar( 
   string query,
   OrderedDictionary param,
   DbProvider provider,
   string connectionString
)

Parameters

query

Type: System.String

SQL query.

param

Type: System.Collections.Specialized

Query parameters .

provider

Type: ZennoLab.InterfacesLibrary.Enums.Db.DbProvider

Data provider type.

connectionString

Type: System.String

Connection string.

Return Value

Type: System.String

The first column of the first row in the result set or empty string

Remarks

Example

The following example shows call the ExecuteScalar method.

var count = ZennoPoster.Db.ExecuteScalar("SELECT COUNT(*) FROM User", null,
    ZennoLab.InterfacesLibrary.Enums.Db.DbProvider.SqlClient, 
    "Data Source=SQLSERVER;Initial Catalog=TestDb;Integrated Security=True;max pool size=500");

$count = ZennoLab\CommandCenter\ZennoPoster::Db::ExecuteScalar("SELECT COUNT(*) FROM User", null,
    ZennoLab\InterfacesLibrary\Enums\Db\DbProvider::SqlClient,
    "Data Source=SQLSERVER;Initial Catalog=TestDb;Integrated Security=True;max pool size=500");

Requirements

Target Platforms: Desktop: Windows XP SP3 and older. Server: Windows Server 2003 and older.

Reference

ZennoPoster.Db Class
ZennoPoster.Db Members
ExecuteNonQuery Method
ExecuteQuery Method