C# Class DBH.Helper.SybaseHelper

Sybase 的数据操作

Inheritance: DBHelperBase

Exibir arquivo Open project: bluedusk/DBHelper Class Usage Examples

Public Methods

Method	Description
DataTableInsert ( DataTable _dt ) : int	更新DataTable的方式插入数据
ExecuteNoQuery ( string cmdText, DBHelperParmCollection parameters ) : int
ExecuteProcedureNoQuery ( string procedureName, DBHelperParmCollection parameters ) : int
ExecuteProcedureQuery ( string procedureName, DBHelperParmCollection parameters ) : DataTable
ExecuteQuery ( string cmdText, DBHelperParmCollection parameters ) : DataTable
ExecuteQuery ( string cmdText, string talbeName ) : DataTable
GetDataSet ( string cmdText ) : DataSet
ProcessDataReader ( IDataReader dr ) : void
ProcessDataSet ( DataSet dataSet ) : void
ProcessDataTable ( DataTable dt ) : void
SybaseHelper ( AseConnection myConnection ) : System
SybaseHelper ( AseConnection myConnection, string DBEncoding ) : System

Protected Methods

Method	Description
CreateAdapter ( string cmdText ) : IDbDataAdapter
CreateCommand ( string cmdText, CommandType commandType ) : IDbCommand

Private Methods

Method	Description
ExecuteNoQuery ( string cmdText ) : int
ExecuteQuery ( string cmdText ) : DataTable

Method Details

CreateAdapter() protected method

protected CreateAdapter ( string cmdText ) : IDbDataAdapter
cmdText	string
return	IDbDataAdapter

CreateCommand() protected method

protected CreateCommand ( string cmdText, CommandType commandType ) : IDbCommand
cmdText	string
commandType	CommandType
return	IDbCommand

DataTableInsert() public method

更新DataTable的方式插入数据

public DataTableInsert ( DataTable _dt ) : int
_dt	System.Data.DataTable	DataTable
return	int

ExecuteNoQuery() public method

public ExecuteNoQuery ( string cmdText, DBHelperParmCollection parameters ) : int
cmdText	string
parameters	DBHelperParmCollection
return	int

ExecuteProcedureNoQuery() public method

public ExecuteProcedureNoQuery ( string procedureName, DBHelperParmCollection parameters ) : int
procedureName	string
parameters	DBHelperParmCollection
return	int

ExecuteProcedureQuery() public method

public ExecuteProcedureQuery ( string procedureName, DBHelperParmCollection parameters ) : DataTable
procedureName	string
parameters	DBHelperParmCollection
return	System.Data.DataTable

ExecuteQuery() public method

public ExecuteQuery ( string cmdText, DBHelperParmCollection parameters ) : DataTable
cmdText	string
parameters	DBHelperParmCollection
return	System.Data.DataTable

ExecuteQuery() public method

public ExecuteQuery ( string cmdText, string talbeName ) : DataTable
cmdText	string
talbeName	string
return	System.Data.DataTable

GetDataSet() public method

public GetDataSet ( string cmdText ) : DataSet
cmdText	string
return	System.Data.DataSet

ProcessDataReader() public method

public ProcessDataReader ( IDataReader dr ) : void
dr	IDataReader
return	void

ProcessDataSet() public method

public ProcessDataSet ( DataSet dataSet ) : void
dataSet	System.Data.DataSet
return	void

ProcessDataTable() public method

public ProcessDataTable ( DataTable dt ) : void
dt	System.Data.DataTable
return	void

SybaseHelper() public method

public SybaseHelper ( AseConnection myConnection ) : System
myConnection	AseConnection
return	System

SybaseHelper() public method

public SybaseHelper ( AseConnection myConnection, string DBEncoding ) : System
myConnection	AseConnection
DBEncoding	string
return	System