Méthode | Description | |
---|---|---|
ExecuteDataset ( System.Data.OleDb.OleDbConnection connection, CommandType commandType, string commandText ) : |
Execute an OleDbCommand (that returns a resultset and takes no parameters) against the provided OleDbConnection. e.g.: DataSet ds = ExecuteDataset(conn, CommandType.StoredProcedure, "GetOrders"); |
|
ExecuteDataset ( System.Data.OleDb.OleDbConnection connection, string spName ) : |
Execute a stored procedure via an OleDbCommand (that returns a resultset) against the specified OleDbConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: DataSet ds = ExecuteDataset(conn, "GetOrders", 24, 36); |
|
ExecuteDataset ( System.Data.OleDb.OleDbTransaction transaction, CommandType commandType, string commandText ) : |
Execute an OleDbCommand (that returns a resultset and takes no parameters) against the provided OleDbTransaction. e.g.: DataSet ds = ExecuteDataset(trans, CommandType.StoredProcedure, "GetOrders"); |
|
ExecuteDataset ( System.Data.OleDb.OleDbTransaction transaction, string spName ) : |
Execute a stored procedure via an OleDbCommand (that returns a resultset) against the specified OleDbTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: DataSet ds = ExecuteDataset(trans, "GetOrders", 24, 36); |
|
ExecuteDataset ( string connectionString, CommandType commandType, string commandText ) : |
Execute an OleDbCommand (that returns a resultset and takes no parameters) against the database specified in the connection string. e.g.: DataSet ds = ExecuteDataset(connString, CommandType.StoredProcedure, "GetOrders"); |
|
ExecuteDataset ( string connectionString, string spName ) : |
Execute a stored procedure via an OleDbCommand (that returns a resultset) against the database specified in the conneciton string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: DataSet ds = ExecuteDataset(connString, "GetOrders", 24, 36); |
|
ExecuteNonQuery ( System.Data.OleDb.OleDbConnection connection, CommandType commandType, string commandText ) : int |
Execute an OleDbDbCommand (that returns no resultset and takes no parameters) against the provided OleDbConnection. e.g.: int result = ExecuteNonQuery(conn, CommandType.StoredProcedure, "PublishOrders"); |
|
ExecuteNonQuery ( System.Data.OleDb.OleDbConnection connection, string spName ) : int |
Execute a stored procedure via an OleDbCommand (that returns no resultset) against the specified OleDbConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: int result = ExecuteNonQuery(conn, "PublishOrders", 24, 36); |
|
ExecuteNonQuery ( System.Data.OleDb.OleDbTransaction transaction, CommandType commandType, string commandText ) : int |
Execute an OleDbCommand (that returns no resultset and takes no parameters) against the provided OleDbTransaction. e.g.: int result = ExecuteNonQuery(trans, CommandType.StoredProcedure, "PublishOrders"); |
|
ExecuteNonQuery ( System.Data.OleDb.OleDbTransaction transaction, string spName ) : int |
Execute a stored procedure via an OleDbCommand (that returns no resultset) against the specified OleDbTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: int result = ExecuteNonQuery(conn, trans, "PublishOrders", 24, 36); |
|
ExecuteNonQuery ( string connectionString, CommandType commandType, string commandText ) : int |
Execute an OleDbCommand (that returns no resultset and takes no parameters) against the database specified in the connection string. e.g.: int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders"); |
|
ExecuteNonQuery ( string connectionString, string spName ) : int |
Execute a stored procedure via an OleDbCommand (that returns no resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: int result = ExecuteNonQuery(connString, "PublishOrders", 24, 36); |
|
ExecuteReader ( System.Data.OleDb.OleDbConnection connection, CommandType commandType, string commandText ) : System.Data.OleDb.OleDbDataReader |
Execute an OleDbCommand (that returns a resultset and takes no parameters) against the provided OleDbConnection. e.g.: OleDbDataReader dr = ExecuteReader(conn, CommandType.StoredProcedure, "GetOrders"); |
|
ExecuteReader ( System.Data.OleDb.OleDbConnection connection, string spName ) : System.Data.OleDb.OleDbDataReader |
Execute a stored procedure via an OleDbCommand (that returns a resultset) against the specified OleDbConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: OleDbDataReader dr = ExecuteReader(conn, "GetOrders", 24, 36); |
|
ExecuteReader ( System.Data.OleDb.OleDbTransaction transaction, CommandType commandType, string commandText ) : System.Data.OleDb.OleDbDataReader |
Execute an OleDbCommand (that returns a resultset and takes no parameters) against the provided OleDbTransaction. e.g.: OleDbDataReader dr = ExecuteReader(trans, CommandType.StoredProcedure, "GetOrders"); |
|
ExecuteReader ( System.Data.OleDb.OleDbTransaction transaction, string spName ) : System.Data.OleDb.OleDbDataReader |
Execute a stored procedure via an OleDbCommand (that returns a resultset) against the specified OleDbTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: OleDbDataReader dr = ExecuteReader(trans, "GetOrders", 24, 36); |
|
ExecuteReader ( string connectionString, CommandType commandType, string commandText ) : System.Data.OleDb.OleDbDataReader |
Execute an OleDbCommand (that returns a resultset and takes no parameters) against the database specified in the connection string. e.g.: OleDbDataReader dr = ExecuteReader(connString, CommandType.StoredProcedure, "GetOrders"); |
|
ExecuteReader ( string connectionString, string spName ) : System.Data.OleDb.OleDbDataReader |
Execute a stored procedure via an OleDbCommand (that returns a resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: OleDbDataReader dr = ExecuteReader(connString, "GetOrders", 24, 36); |
|
ExecuteScalar ( System.Data.OleDb.OleDbConnection connection, CommandType commandType, string commandText ) : object |
Execute a OleDbCommand (that returns a 1x1 resultset and takes no parameters) against the provided OleDbConnection. e.g.: int orderCount = (int)ExecuteScalar(conn, CommandType.StoredProcedure, "GetOrderCount"); |
|
ExecuteScalar ( System.Data.OleDb.OleDbConnection connection, string spName ) : object |
Execute a stored procedure via a OleDbCommand (that returns a 1x1 resultset) against the specified OleDbConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: int orderCount = (int)ExecuteScalar(conn, "GetOrderCount", 24, 36); |
|
ExecuteScalar ( System.Data.OleDb.OleDbTransaction transaction, CommandType commandType, string commandText ) : object |
Execute a OleDbCommand (that returns a 1x1 resultset and takes no parameters) against the provided OleDbTransaction. e.g.: int orderCount = (int)ExecuteScalar(trans, CommandType.StoredProcedure, "GetOrderCount"); |
|
ExecuteScalar ( System.Data.OleDb.OleDbTransaction transaction, string spName ) : object |
Execute a stored procedure via a OleDbCommand (that returns a 1x1 resultset) against the specified OleDbTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: int orderCount = (int)ExecuteScalar(trans, "GetOrderCount", 24, 36); |
|
ExecuteScalar ( string connectionString, CommandType commandType, string commandText ) : object |
Execute a OleDbCommand (that returns a 1x1 resultset and takes no parameters) against the database specified in the connection string. e.g.: int orderCount = (int)ExecuteScalar(connString, CommandType.StoredProcedure, "GetOrderCount"); |
|
ExecuteScalar ( string connectionString, string spName ) : object |
Execute a stored procedure via a OleDbCommand (that returns a 1x1 resultset) against the database specified in the conneciton string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order. This method provides no access to output parameters or the stored procedure's return value parameter. e.g.: int orderCount = (int)ExecuteScalar(connString, "GetOrderCount", 24, 36); |
Méthode | Description | |
---|---|---|
AssignParameterValues ( System.Data.OleDb.OleDbParameter commandParameters, object parameterValues ) : void |
This method assigns an array of values to an array of OleDbParameters.
|
|
AttachParameters ( |
This method is used to attach array's of OleDbParameters to an OleDbCommand. This method will assign a value of DbNull to any parameter with a direction of InputOutput and a value of null. This behavior will prevent default values from being used, but this will be the less common case than an intended pure output parameter (derived as InputOutput) where the user provided no input value.
|
|
ExecuteReader ( System.Data.OleDb.OleDbConnection connection, System.Data.OleDb.OleDbTransaction transaction, CommandType commandType, string commandText, System.Data.OleDb.OleDbParameter commandParameters, OleDbConnectionOwnership connectionOwnership ) : System.Data.OleDb.OleDbDataReader |
Create and prepare an OleDbCommand, and call ExecuteReader with the appropriate CommandBehavior. If we created and opened the connection, we want the connection to be closed when the DataReader is closed. If the caller provided the connection, we want to leave it to them to manage. |
|
OleDbHelper ( ) : System | ||
PrepareCommand ( |
This method opens (if necessary) and assigns a connection, transaction, command type and parameters to the provided command.
|
public static ExecuteDataset ( System.Data.OleDb.OleDbConnection connection, CommandType commandType, string commandText ) : |
||
connection | System.Data.OleDb.OleDbConnection | a valid OleDbConnection |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or PL/SQL command |
Résultat |
public static ExecuteDataset ( System.Data.OleDb.OleDbConnection connection, string spName ) : |
||
connection | System.Data.OleDb.OleDbConnection | a valid OleDbConnection |
spName | string | the name of the stored prcedure |
Résultat |
public static ExecuteDataset ( System.Data.OleDb.OleDbTransaction transaction, CommandType commandType, string commandText ) : |
||
transaction | System.Data.OleDb.OleDbTransaction | a valid OleDbTransaction |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or PL/SQL command |
Résultat |
public static ExecuteDataset ( System.Data.OleDb.OleDbTransaction transaction, string spName ) : |
||
transaction | System.Data.OleDb.OleDbTransaction | a valid OleDbTransaction |
spName | string | the name of the stored prcedure |
Résultat |
public static ExecuteDataset ( string connectionString, CommandType commandType, string commandText ) : |
||
connectionString | string | a valid connection string for an OleDbConnection |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or PL/SQL command |
Résultat |
public static ExecuteDataset ( string connectionString, string spName ) : |
||
connectionString | string | a valid connection string for an OleDbConnection |
spName | string | the name of the stored procedure |
Résultat |
public static ExecuteNonQuery ( System.Data.OleDb.OleDbConnection connection, CommandType commandType, string commandText ) : int | ||
connection | System.Data.OleDb.OleDbConnection | a valid OleDbConnection |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or PL/SQL command |
Résultat | int |
public static ExecuteNonQuery ( System.Data.OleDb.OleDbConnection connection, string spName ) : int | ||
connection | System.Data.OleDb.OleDbConnection | a valid OleDbConnection |
spName | string | the name of the stored prcedure |
Résultat | int |
public static ExecuteNonQuery ( System.Data.OleDb.OleDbTransaction transaction, CommandType commandType, string commandText ) : int | ||
transaction | System.Data.OleDb.OleDbTransaction | a valid OleDbTransaction |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or PL/SQL command |
Résultat | int |
public static ExecuteNonQuery ( System.Data.OleDb.OleDbTransaction transaction, string spName ) : int | ||
transaction | System.Data.OleDb.OleDbTransaction | a valid OleDbTransaction |
spName | string | the name of the stored procedure |
Résultat | int |
public static ExecuteNonQuery ( string connectionString, CommandType commandType, string commandText ) : int | ||
connectionString | string | a valid connection string for an OleDbConnection |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or PL/SQL command |
Résultat | int |
public static ExecuteNonQuery ( string connectionString, string spName ) : int | ||
connectionString | string | a valid connection string for a OleDbConnection |
spName | string | the name of the stored prcedure |
Résultat | int |
public static ExecuteReader ( System.Data.OleDb.OleDbConnection connection, CommandType commandType, string commandText ) : System.Data.OleDb.OleDbDataReader | ||
connection | System.Data.OleDb.OleDbConnection | a valid OleDbConnection |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or PL/SQL command |
Résultat | System.Data.OleDb.OleDbDataReader |
public static ExecuteReader ( System.Data.OleDb.OleDbConnection connection, string spName ) : System.Data.OleDb.OleDbDataReader | ||
connection | System.Data.OleDb.OleDbConnection | a valid OleDbConnection |
spName | string | the name of the stored procedure |
Résultat | System.Data.OleDb.OleDbDataReader |
public static ExecuteReader ( System.Data.OleDb.OleDbTransaction transaction, CommandType commandType, string commandText ) : System.Data.OleDb.OleDbDataReader | ||
transaction | System.Data.OleDb.OleDbTransaction | a valid OleDbTransaction |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or PL/SQL command |
Résultat | System.Data.OleDb.OleDbDataReader |
public static ExecuteReader ( System.Data.OleDb.OleDbTransaction transaction, string spName ) : System.Data.OleDb.OleDbDataReader | ||
transaction | System.Data.OleDb.OleDbTransaction | a valid OleDbTransaction |
spName | string | the name of the stored prcedure |
Résultat | System.Data.OleDb.OleDbDataReader |
public static ExecuteReader ( string connectionString, CommandType commandType, string commandText ) : System.Data.OleDb.OleDbDataReader | ||
connectionString | string | a valid connection string for an OleDbConnection |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or PL/SQL command |
Résultat | System.Data.OleDb.OleDbDataReader |
public static ExecuteReader ( string connectionString, string spName ) : System.Data.OleDb.OleDbDataReader | ||
connectionString | string | a valid connection string for an OleDbConnection |
spName | string | the name of the stored prcedure |
Résultat | System.Data.OleDb.OleDbDataReader |
public static ExecuteScalar ( System.Data.OleDb.OleDbConnection connection, CommandType commandType, string commandText ) : object | ||
connection | System.Data.OleDb.OleDbConnection | a valid OleDbConnection |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or T-OleDb command |
Résultat | object |
public static ExecuteScalar ( System.Data.OleDb.OleDbConnection connection, string spName ) : object | ||
connection | System.Data.OleDb.OleDbConnection | a valid OleDbConnection |
spName | string | the name of the stored prcedure |
Résultat | object |
public static ExecuteScalar ( System.Data.OleDb.OleDbTransaction transaction, CommandType commandType, string commandText ) : object | ||
transaction | System.Data.OleDb.OleDbTransaction | a valid OleDbTransaction |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or T-OleDb command |
Résultat | object |
public static ExecuteScalar ( System.Data.OleDb.OleDbTransaction transaction, string spName ) : object | ||
transaction | System.Data.OleDb.OleDbTransaction | a valid OleDbTransaction |
spName | string | the name of the stored prcedure |
Résultat | object |
public static ExecuteScalar ( string connectionString, CommandType commandType, string commandText ) : object | ||
connectionString | string | a valid connection string for a OleDbConnection |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or T-OleDb command |
Résultat | object |
public static ExecuteScalar ( string connectionString, string spName ) : object | ||
connectionString | string | a valid connection string for a OleDbConnection |
spName | string | the name of the stored prcedure |
Résultat | object |