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

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