C# Class DBH.Helper.OdbcHelper

OdbcDBHelper
Inheritance: DBHelperBase
显示文件 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
OdbcHelper ( System.Data.Odbc.OdbcConnection myConnection ) : System

Protected Methods

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

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
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

OdbcHelper() public method

public OdbcHelper ( System.Data.Odbc.OdbcConnection myConnection ) : System
myConnection System.Data.Odbc.OdbcConnection
return System