Interface ISqlExecuter

Namespace: Reportman.Drawing

Assembly: Reportman.Drawing.dll

Syntax

public interface ISqlExecuter

Methods

AddCustomOperation(int, string, byte[])

Declaration

void AddCustomOperation(int operation, string data, byte[] binarydata)

Parameters

Type	Name	Description
int	operation
string	data
byte[]	binarydata

AddExternalColumnsToLastCommand(string, string)

Declaration

void AddExternalColumnsToLastCommand(string externalcolumns, string deletes)

Parameters

Type	Name	Description
string	externalcolumns
string	deletes

BeginInsertBlock()

Declaration

void BeginInsertBlock()

Commit()

Declaration

void Commit()

Connect()

Declaration

void Connect()

CreateCommand(string)

Declaration

DbCommand CreateCommand(string cadsql)

Parameters

Type	Name	Description
string	cadsql

Returns

Type	Description
DbCommand

Disconnect()

Declaration

void Disconnect()

EndInsertBlock()

Declaration

void EndInsertBlock()

Execute(DbCommand)

Declaration

void Execute(DbCommand ncommand)

Parameters

Type	Name	Description
DbCommand	ncommand

Execute(string)

Declaration

void Execute(string sql)

Parameters

Type	Name	Description
string	sql

ExecuteInmediate(string)

Declaration

int ExecuteInmediate(string sql)

Parameters

Type	Name	Description
string	sql

Returns

Type	Description
int

Flush()

Declaration

void Flush()

Flush(ISqlExecuterProgressEvent)

Declaration

void Flush(ISqlExecuterProgressEvent pgevent)

Parameters

Type	Name	Description
ISqlExecuterProgressEvent	pgevent

GetGenerator(string, int)

Declaration

long GetGenerator(string generatorName, int increment)

Parameters

Type	Name	Description
string	generatorName
int	increment

Returns

Type	Description
long

GetValueFromSql(string)

Declaration

object GetValueFromSql(string sql)

Parameters

Type	Name	Description
string	sql

Returns

Type	Description
object

Open(DataSet, DbCommand, string)

Declaration

void Open(DataSet ndataset, DbCommand command, string tablename)

Parameters

Type	Name	Description
DataSet	ndataset
DbCommand	command
string	tablename

Open(DataSet, string, string)

Declaration

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

void Open(DataSet ndataset, string sql, string tablename, int maxrecords, ISqlExecuterPartialFillEvent eventpartial)

Parameters

Type	Name	Description
DataSet	ndataset
string	sql
string	tablename
int	maxrecords
ISqlExecuterPartialFillEvent	eventpartial

OpenInmediate(DataSet, string, string)

Declaration

DataTable OpenInmediate(DataSet ndataset, string sql, string tablename)

Parameters

Type	Name	Description
DataSet	ndataset
string	sql
string	tablename

Returns

Type	Description
DataTable

Rollback()

Declaration

void Rollback()

RollbackInmediate()

Declaration

void RollbackInmediate()

StartTransaction(IsolationLevel)

Declaration

void StartTransaction(IsolationLevel nisolation)

Parameters

Type	Name	Description
IsolationLevel	nisolation