C# Class HacmeBank_v2_WS.SqlServerEngine

Summary description for DataFactory_SqlServer.

Afficher le fichier Open project: o2platform/Demos_Files Class Usage Examples

Méthodes publiques

Méthode	Description
SqlServerEngine ( ) : System
executeSQLCommand ( string sqlQueryToExecute ) : int
executeSQLCommand_onLocalSQLServer ( string sqlQueryToExecute ) : int
executeSQLCommand_returnSqldataReader ( string sqlQueryToExecute ) : System.Data.SqlClient.SqlDataReader
returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows ( string sqlQuery ) : ArrayList
returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows_andResultingSchema ( string sqlQuery ) : ArrayList
returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows ( string sqlQuery ) : ArrayList
returnArrayListFromSQLQuery_containing_FirstRow ( string sqlQuery ) : ArrayList
returnObjectFromSQLQuery_containing_FirstFieldFromFirstRow ( string sqlQuery ) : object

Method Details

SqlServerEngine() public méthode

public SqlServerEngine ( ) : System
Résultat	System

executeSQLCommand() public static méthode

public static executeSQLCommand ( string sqlQueryToExecute ) : int
sqlQueryToExecute	string
Résultat	int

executeSQLCommand_onLocalSQLServer() public static méthode

public static executeSQLCommand_onLocalSQLServer ( string sqlQueryToExecute ) : int
sqlQueryToExecute	string
Résultat	int

executeSQLCommand_returnSqldataReader() public static méthode

public static executeSQLCommand_returnSqldataReader ( string sqlQueryToExecute ) : System.Data.SqlClient.SqlDataReader
sqlQueryToExecute	string
Résultat	System.Data.SqlClient.SqlDataReader

returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows() public static méthode

public static returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows ( string sqlQuery ) : ArrayList
sqlQuery	string
Résultat	System.Collections.ArrayList

returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows_andResultingSchema() public static méthode

public static returnArrayListFromSQLQuery_containing_AllFieldsFromAllRows_andResultingSchema ( string sqlQuery ) : ArrayList
sqlQuery	string
Résultat	System.Collections.ArrayList

returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows() public static méthode

public static returnArrayListFromSQLQuery_containing_FirstFieldFromAllRows ( string sqlQuery ) : ArrayList
sqlQuery	string
Résultat	System.Collections.ArrayList

returnArrayListFromSQLQuery_containing_FirstRow() public static méthode

public static returnArrayListFromSQLQuery_containing_FirstRow ( string sqlQuery ) : ArrayList
sqlQuery	string
Résultat	System.Collections.ArrayList

returnObjectFromSQLQuery_containing_FirstFieldFromFirstRow() public static méthode

public static returnObjectFromSQLQuery_containing_FirstFieldFromFirstRow ( string sqlQuery ) : object
sqlQuery	string
Résultat	object