C# Class Disco.Services.Expressions.Extensions.DataExt

Afficher le fichier Open project: garysharp/Disco

Méthodes publiques

Méthode Description
QueryOdbcDatabase ( string ConnectionString, string OdbcQuery ) : DataTable
QueryOdbcDatabase ( string ConnectionString, string OdbcQuery, Hashtable OdbcParameters ) : DataTable
QueryOdbcDatabaseScalar ( string ConnectionString, string OdbcQuery ) : object
QueryOdbcDatabaseScalar ( string ConnectionString, string OdbcQuery, Hashtable OdbcParameters ) : object
QuerySqlDatabase ( string Server, string Database, string SqlQuery ) : DataTable
QuerySqlDatabase ( string Server, string Database, string SqlQuery, Hashtable SqlParameters ) : DataTable
QuerySqlDatabase ( string Server, string Database, string Username, string Password, string SqlQuery, Hashtable SqlParameters ) : DataTable
QuerySqlDatabaseScalar ( string Server, string Database, string SqlQuery ) : object
QuerySqlDatabaseScalar ( string Server, string Database, string SqlQuery, Hashtable SqlParameters ) : object
QuerySqlDatabaseScalar ( string Server, string Database, string Username, string Password, string SqlQuery, Hashtable SqlParameters ) : object

Private Methods

Méthode Description
BuildOdbcConnection ( string ConnectionString ) : System.Data.Odbc.OdbcConnection
BuildOdbcParameters ( System.Data.Odbc.OdbcCommand dbCommand, Hashtable OdbcParameters ) : void
BuildSqlConnection ( string Server, string Database, string Username, string Password ) : SqlConnection
BuildSqlParameters ( SqlCommand dbCommand, Hashtable SqlParameters ) : void

Method Details

QueryOdbcDatabase() public static méthode

public static QueryOdbcDatabase ( string ConnectionString, string OdbcQuery ) : DataTable
ConnectionString string
OdbcQuery string
Résultat System.Data.DataTable

QueryOdbcDatabase() public static méthode

public static QueryOdbcDatabase ( string ConnectionString, string OdbcQuery, Hashtable OdbcParameters ) : DataTable
ConnectionString string
OdbcQuery string
OdbcParameters System.Collections.Hashtable
Résultat System.Data.DataTable

QueryOdbcDatabaseScalar() public static méthode

public static QueryOdbcDatabaseScalar ( string ConnectionString, string OdbcQuery ) : object
ConnectionString string
OdbcQuery string
Résultat object

QueryOdbcDatabaseScalar() public static méthode

public static QueryOdbcDatabaseScalar ( string ConnectionString, string OdbcQuery, Hashtable OdbcParameters ) : object
ConnectionString string
OdbcQuery string
OdbcParameters System.Collections.Hashtable
Résultat object

QuerySqlDatabase() public static méthode

public static QuerySqlDatabase ( string Server, string Database, string SqlQuery ) : DataTable
Server string
Database string
SqlQuery string
Résultat System.Data.DataTable

QuerySqlDatabase() public static méthode

public static QuerySqlDatabase ( string Server, string Database, string SqlQuery, Hashtable SqlParameters ) : DataTable
Server string
Database string
SqlQuery string
SqlParameters System.Collections.Hashtable
Résultat System.Data.DataTable

QuerySqlDatabase() public static méthode

public static QuerySqlDatabase ( string Server, string Database, string Username, string Password, string SqlQuery, Hashtable SqlParameters ) : DataTable
Server string
Database string
Username string
Password string
SqlQuery string
SqlParameters System.Collections.Hashtable
Résultat System.Data.DataTable

QuerySqlDatabaseScalar() public static méthode

public static QuerySqlDatabaseScalar ( string Server, string Database, string SqlQuery ) : object
Server string
Database string
SqlQuery string
Résultat object

QuerySqlDatabaseScalar() public static méthode

public static QuerySqlDatabaseScalar ( string Server, string Database, string SqlQuery, Hashtable SqlParameters ) : object
Server string
Database string
SqlQuery string
SqlParameters System.Collections.Hashtable
Résultat object

QuerySqlDatabaseScalar() public static méthode

public static QuerySqlDatabaseScalar ( string Server, string Database, string Username, string Password, string SqlQuery, Hashtable SqlParameters ) : object
Server string
Database string
Username string
Password string
SqlQuery string
SqlParameters System.Collections.Hashtable
Résultat object