Class DbSqlExecuter

Inheritance
object
DbSqlExecuter
Implements
Inherited Members
Namespace: Reportman.Drawing
Assembly: Reportman.Drawing.dll
Syntax
public class DbSqlExecuter : ISqlExecuter

Constructors

DbSqlExecuter(DbConnection, DbProviderFactory)

Declaration
public DbSqlExecuter(DbConnection nconnection, DbProviderFactory nfactory)
Parameters
Type Name Description
DbConnection nconnection
DbProviderFactory nfactory

Fields

transaction

Declaration
public DbTransaction transaction
Field Value
Type Description
DbTransaction

Methods

AddCustomOperation(int, string, byte[])

Declaration
public void AddCustomOperation(int operation, string data, byte[] binarydata)
Parameters
Type Name Description
int operation
string data
byte[] binarydata

AddExternalColumnsToLastCommand(string, string)

Declaration
public void AddExternalColumnsToLastCommand(string external_columns, string deletions)
Parameters
Type Name Description
string external_columns
string deletions

BeginInsertBlock()

Declaration
public void BeginInsertBlock()

Commit()

Declaration
public void Commit()

Connect()

Declaration
public void Connect()

CreateCommand(string)

Declaration
public DbCommand CreateCommand(string cadsql)
Parameters
Type Name Description
string cadsql
Returns
Type Description
DbCommand

Disconnect()

Declaration
public void Disconnect()

EndInsertBlock()

Declaration
public void EndInsertBlock()

Execute(DbCommand)

Declaration
public void Execute(DbCommand ncommand)
Parameters
Type Name Description
DbCommand ncommand

Execute(string)

Declaration
public void Execute(string sql)
Parameters
Type Name Description
string sql

ExecuteInmediate(string)

Declaration
public int ExecuteInmediate(string sql)
Parameters
Type Name Description
string sql
Returns
Type Description
int

Flush()

Declaration
public void Flush()

Flush(ISqlExecuterProgressEvent)

Declaration
public void Flush(ISqlExecuterProgressEvent nevent)
Parameters
Type Name Description
ISqlExecuterProgressEvent nevent

GetGenerator(string, int)

Declaration
public long GetGenerator(string generatorName, int increment)
Parameters
Type Name Description
string generatorName
int increment
Returns
Type Description
long

GetValueFromSql(string)

Declaration
public object GetValueFromSql(string sql)
Parameters
Type Name Description
string sql
Returns
Type Description
object

Open(DataSet, DbCommand, string)

Declaration
public void Open(DataSet ndataset, DbCommand nCommand, string tablename)
Parameters
Type Name Description
DataSet ndataset
DbCommand nCommand
string tablename

Open(DataSet, string, string)

Declaration
public void Open(DataSet ndataset, string sql, string tablename)
Parameters
Type Name Description
DataSet ndataset
string sql
string tablename

Open(DataSet, string, string, int, ISqlExecuterPartialFillEvent)

Declaration
public void Open(DataSet ndataset, string sql, string tablename, int maxrecords, ISqlExecuterPartialFillEvent nevent)
Parameters
Type Name Description
DataSet ndataset
string sql
string tablename
int maxrecords
ISqlExecuterPartialFillEvent nevent

OpenInmediate(DataSet, string, string)

Declaration
public DataTable OpenInmediate(DataSet ndataset, string sql, string tablename)
Parameters
Type Name Description
DataSet ndataset
string sql
string tablename
Returns
Type Description
DataTable

Rollback()

Declaration
public void Rollback()

RollbackInmediate()

Declaration
public void RollbackInmediate()

StartTransaction()

Declaration
public void StartTransaction()

StartTransaction(IsolationLevel)

Declaration
public void StartTransaction(IsolationLevel nlevel)
Parameters
Type Name Description
IsolationLevel nlevel

Implements