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

Datei anzeigen Open project: garysharp/Disco

Public Methods

Method 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

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

public static QueryOdbcDatabase ( string ConnectionString, string OdbcQuery ) : DataTable
ConnectionString string
OdbcQuery string
return System.Data.DataTable

QueryOdbcDatabase() public static method

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

QueryOdbcDatabaseScalar() public static method

public static QueryOdbcDatabaseScalar ( string ConnectionString, string OdbcQuery ) : object
ConnectionString string
OdbcQuery string
return object

QueryOdbcDatabaseScalar() public static method

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

QuerySqlDatabase() public static method

public static QuerySqlDatabase ( string Server, string Database, string SqlQuery ) : DataTable
Server string
Database string
SqlQuery string
return System.Data.DataTable

QuerySqlDatabase() public static method

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

QuerySqlDatabase() public static method

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
return System.Data.DataTable

QuerySqlDatabaseScalar() public static method

public static QuerySqlDatabaseScalar ( string Server, string Database, string SqlQuery ) : object
Server string
Database string
SqlQuery string
return object

QuerySqlDatabaseScalar() public static method

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

QuerySqlDatabaseScalar() public static method

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