C# Class RTDealsScanerEngine.RTDealsDataAccess.DBUtils

Show file Open project: jediskywalker/RTDeals Class Usage Examples

Public Methods

Method	Description
CloseConnection ( ) : void
DBUtils ( ) : System
ExecuteCommand ( MySqlCommand pcmd ) : int
ExecuteCommand ( SqlCommand pcmd ) : int
ExecuteNonQuery ( MySqlCommand sqlCommand ) : int
ExecuteNonQuery ( SqlCommand sqlCommand ) : int
ExecuteNonQuery ( string sql ) : int
ExecuteReader ( MySqlCommand sqlcmd ) : MySqlDataReader
ExecuteReader ( string sql ) : MySqlDataReader
ExecuteReader ( SqlCommand sqlcmd ) : System.Data.SqlClient.SqlDataReader
ExecuteReader ( string sql ) : System.Data.SqlClient.SqlDataReader
ExecuteScalar ( MySqlCommand sqlcmd ) : object
ExecuteScalar ( SqlCommand sqlcmd ) : object
ExecuteScalar ( string sql ) : object
FillDataSet ( MySqlCommand cmdin, DataSet &ds ) : void
FillDataSet ( SqlCommand cmdin, DataSet &ds ) : void
FillDataSet ( string sql, DataSet &ds ) : void
GetDataTable ( string table, string sql ) : DataTable

Private Methods

Method	Description
FillDataSet ( string p, ScanerDataSet &ds ) : void
OpenConnection ( ) : void

Method Details

CloseConnection() public method

public CloseConnection ( ) : void
return	void

DBUtils() public method

public DBUtils ( ) : System
return	System

ExecuteCommand() public method

public ExecuteCommand ( MySqlCommand pcmd ) : int
pcmd	MySqlCommand
return	int

ExecuteCommand() public method

public ExecuteCommand ( SqlCommand pcmd ) : int
pcmd	System.Data.SqlClient.SqlCommand
return	int

ExecuteNonQuery() public method

public ExecuteNonQuery ( MySqlCommand sqlCommand ) : int
sqlCommand	MySqlCommand
return	int

ExecuteNonQuery() public method

public ExecuteNonQuery ( SqlCommand sqlCommand ) : int
sqlCommand	System.Data.SqlClient.SqlCommand
return	int

ExecuteNonQuery() public method

public ExecuteNonQuery ( string sql ) : int
sql	string
return	int

ExecuteReader() public method

public ExecuteReader ( MySqlCommand sqlcmd ) : MySqlDataReader
sqlcmd	MySqlCommand
return	MySqlDataReader

ExecuteReader() public method

public ExecuteReader ( string sql ) : MySqlDataReader
sql	string
return	MySqlDataReader

ExecuteReader() public method

public ExecuteReader ( SqlCommand sqlcmd ) : System.Data.SqlClient.SqlDataReader
sqlcmd	System.Data.SqlClient.SqlCommand
return	System.Data.SqlClient.SqlDataReader

ExecuteReader() public method

public ExecuteReader ( string sql ) : System.Data.SqlClient.SqlDataReader
sql	string
return	System.Data.SqlClient.SqlDataReader

ExecuteScalar() public method

public ExecuteScalar ( MySqlCommand sqlcmd ) : object
sqlcmd	MySqlCommand
return	object

ExecuteScalar() public method

public ExecuteScalar ( SqlCommand sqlcmd ) : object
sqlcmd	System.Data.SqlClient.SqlCommand
return	object

ExecuteScalar() public method

public ExecuteScalar ( string sql ) : object
sql	string
return	object

FillDataSet() public method

public FillDataSet ( MySqlCommand cmdin, DataSet &ds ) : void
cmdin	MySqlCommand
ds	System.Data.DataSet
return	void

FillDataSet() public method

public FillDataSet ( SqlCommand cmdin, DataSet &ds ) : void
cmdin	System.Data.SqlClient.SqlCommand
ds	System.Data.DataSet
return	void

FillDataSet() public method

public FillDataSet ( string sql, DataSet &ds ) : void
sql	string
ds	System.Data.DataSet
return	void

GetDataTable() public method

public GetDataTable ( string table, string sql ) : DataTable
table	string
sql	string
return	System.Data.DataTable