ExecuteQuery(String,OrderedDictionary,DbProvider,String,String,String) Method

Execute SQL query and return result as string.

Syntax

public static string ExecuteQuery( 
   string query,
   OrderedDictionary param,
   DbProvider provider,
   string connectionString,
   string fieldSeparator,
   string rowSeparator
)

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.

fieldSeparator

Type: System.String

Field separator.

rowSeparator

Type: System.String

Row separator. If null - System.Environment.NewLine.

Return Value

Type: System.String

Result string.

Remarks

Example

The following example shows call the ExecuteQuery method.

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

$result = ZennoLab\CommandCenter\ZennoPoster::Db::ExecuteQuery("SELECT * 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
Overload List
ExecuteNonQuery Method
ExecuteScalar Method