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,
   bool throwExceptions
)

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.

throwExceptions

Type: System.Boolean

If true, exceptions will not be supressed. Default is false.

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",False);

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