C# 클래스 Goldtect.ASTreeViewDemo.OleDbHelper

The OleDbHelper class is intended to encapsulate high performance, scalable best practices for common uses of OleDbClient.
파일 보기 프로젝트 열기: jinweijie/Goldtect.ASTreeViewSamples

공개 메소드들

메소드 설명
ExecuteDataset ( System.Data.OleDb.OleDbConnection connection, CommandType commandType, string commandText ) : DataSet

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 ) : DataSet

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 ) : DataSet

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 ) : DataSet

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 ) : DataSet

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 ) : DataSet

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);

비공개 메소드들

메소드 설명
AssignParameterValues ( System.Data.OleDb.OleDbParameter commandParameters, object parameterValues ) : void

This method assigns an array of values to an array of OleDbParameters.
AttachParameters ( OleDbCommand command, System.Data.OleDb.OleDbParameter commandParameters ) : void

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 ( OleDbCommand command, System.Data.OleDb.OleDbConnection connection, System.Data.OleDb.OleDbTransaction transaction, CommandType commandType, string commandText, System.Data.OleDb.OleDbParameter commandParameters ) : void

This method opens (if necessary) and assigns a connection, transaction, command type and parameters to the provided command.

메소드 상세

ExecuteDataset() 공개 정적인 메소드

Execute an OleDbCommand (that returns a resultset and takes no parameters) against the provided OleDbConnection.
e.g.: DataSet ds = ExecuteDataset(conn, CommandType.StoredProcedure, "GetOrders");
public static ExecuteDataset ( System.Data.OleDb.OleDbConnection connection, CommandType commandType, string commandText ) : DataSet
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
리턴 System.Data.DataSet

ExecuteDataset() 공개 정적인 메소드

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);
public static ExecuteDataset ( System.Data.OleDb.OleDbConnection connection, string spName ) : DataSet
connection System.Data.OleDb.OleDbConnection a valid OleDbConnection
spName string the name of the stored prcedure
리턴 System.Data.DataSet

ExecuteDataset() 공개 정적인 메소드

Execute an OleDbCommand (that returns a resultset and takes no parameters) against the provided OleDbTransaction.
e.g.: DataSet ds = ExecuteDataset(trans, CommandType.StoredProcedure, "GetOrders");
public static ExecuteDataset ( System.Data.OleDb.OleDbTransaction transaction, CommandType commandType, string commandText ) : DataSet
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
리턴 System.Data.DataSet

ExecuteDataset() 공개 정적인 메소드

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);
public static ExecuteDataset ( System.Data.OleDb.OleDbTransaction transaction, string spName ) : DataSet
transaction System.Data.OleDb.OleDbTransaction a valid OleDbTransaction
spName string the name of the stored prcedure
리턴 System.Data.DataSet

ExecuteDataset() 공개 정적인 메소드

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");
public static ExecuteDataset ( string connectionString, CommandType commandType, string commandText ) : DataSet
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
리턴 System.Data.DataSet

ExecuteDataset() 공개 정적인 메소드

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);
public static ExecuteDataset ( string connectionString, string spName ) : DataSet
connectionString string a valid connection string for an OleDbConnection
spName string the name of the stored procedure
리턴 System.Data.DataSet

ExecuteNonQuery() 공개 정적인 메소드

Execute an OleDbDbCommand (that returns no resultset and takes no parameters) against the provided OleDbConnection.
e.g.: int result = ExecuteNonQuery(conn, CommandType.StoredProcedure, "PublishOrders");
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
리턴 int

ExecuteNonQuery() 공개 정적인 메소드

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);
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
리턴 int

ExecuteNonQuery() 공개 정적인 메소드

Execute an OleDbCommand (that returns no resultset and takes no parameters) against the provided OleDbTransaction.
e.g.: int result = ExecuteNonQuery(trans, CommandType.StoredProcedure, "PublishOrders");
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
리턴 int

ExecuteNonQuery() 공개 정적인 메소드

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);
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
리턴 int

ExecuteNonQuery() 공개 정적인 메소드

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");
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
리턴 int

ExecuteNonQuery() 공개 정적인 메소드

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);
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
리턴 int

ExecuteReader() 공개 정적인 메소드

Execute an OleDbCommand (that returns a resultset and takes no parameters) against the provided OleDbConnection.
e.g.: OleDbDataReader dr = ExecuteReader(conn, CommandType.StoredProcedure, "GetOrders");
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
리턴 System.Data.OleDb.OleDbDataReader

ExecuteReader() 공개 정적인 메소드

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);
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
리턴 System.Data.OleDb.OleDbDataReader

ExecuteReader() 공개 정적인 메소드

Execute an OleDbCommand (that returns a resultset and takes no parameters) against the provided OleDbTransaction.
e.g.: OleDbDataReader dr = ExecuteReader(trans, CommandType.StoredProcedure, "GetOrders");
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
리턴 System.Data.OleDb.OleDbDataReader

ExecuteReader() 공개 정적인 메소드

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);
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
리턴 System.Data.OleDb.OleDbDataReader

ExecuteReader() 공개 정적인 메소드

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");
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
리턴 System.Data.OleDb.OleDbDataReader

ExecuteReader() 공개 정적인 메소드

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);
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
리턴 System.Data.OleDb.OleDbDataReader

ExecuteScalar() 공개 정적인 메소드

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");
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
리턴 object

ExecuteScalar() 공개 정적인 메소드

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);
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
리턴 object

ExecuteScalar() 공개 정적인 메소드

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");
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
리턴 object

ExecuteScalar() 공개 정적인 메소드

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);
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
리턴 object

ExecuteScalar() 공개 정적인 메소드

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");
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
리턴 object

ExecuteScalar() 공개 정적인 메소드

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);
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
리턴 object