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

Execute SQL query and fill list.

Syntax

public static int ExecuteQuery( 
   string query,
   OrderedDictionary param,
   DbProvider provider,
   string connectionString,
   ref IZennoList list,
   string separator
)

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.

list

Type: ZennoLab.InterfacesLibrary.ProjectModel.IZennoList

List for result data.

separator

Type: System.String

Field separator.

Return Value

Type: System.Int32

The number of rows affected.

Remarks

Example

The following example shows call the ExecuteQuery method.

var list = project.Lists["List 1"];
var rowCount = 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",
    ref list, " | ");

$list = $project.Lists["Table 1"];
$rowcount = 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",
    $list, " | ");

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