This class represents a SQL command that can be executed against a data source through the .NET OLE DB provider. For information about the basic OleDbCommand methods and properties, refer to the reference for the System.Data.IDbCommand interface, which OleDbCommand implements. OleDbCommand errors result in a OleDbException being thrown. When CommandType is set to System.Data.CommandType.Text , named parameters aren't supported. This differs from the SQL Server provider. In this case, you must use a question mark (?) placeholder for parameters in the SQL statement. For example, you can set the CommandType to System.Data.CommandType.Text , and set the CommandText to: SELECT * FROM Customers WHERE CustomerID = ? to specify that a CustomerID value will be supplied as a parameter. If there is more than one parameter, the order in which you insert the OleDbParameter to the Parameters collection must match the order of the placeholders. public sealed class OleDbCommand : System.ComponentModel.Component , ICloneable, System.Data.IDbCommand { // Public Constructors public OleDbCommand ( ); public OleDbCommand ( string cmdText ); public OleDbCommand (string cmdText , OleDbConnection connection ); public OleDbCommand (string cmdText , OleDbConnection connection , OleDbTransaction transaction ); // Public Instance Properties public string CommandText {set; get; } // implements System.Data.IDbCommand public int CommandTimeout {set; get; } // implements System.Data.IDbCommand public CommandType CommandType {set; get; } // implements System.Data.IDbCommand public OleDbConnection Connection {set; get; } public bool DesignTimeVisible {set; get; } public OleDbParameterCollection Parameters {get; } public OleDbTransaction Transaction {set; get; } public UpdateRowSource UpdatedRowSource {set; get; } // implements System.Data.IDbCommand // Public Instance Methods public void Cancel ( ); // implements System.Data.IDbCommand public OleDbParameter CreateParameter ( ); public int ExecuteNonQuery ( ); // implements System.Data.IDbCommand public OleDbDataReader ExecuteReader ( ); public OleDbDataReader ExecuteReader (System.Data.CommandBehavior behavior ); public object ExecuteScalar ( ); // implements System.Data.IDbCommand public void Prepare ( ); // implements System.Data.IDbCommand public void ResetCommandTimeout ( ); // Protected Instance Methods protected override void Dispose ( bool disposing ); // overrides System.ComponentModel.Component } HierarchySystem.Object System.MarshalByRefObject System.ComponentModel.Component(System.ComponentModel.IComponent, System.IDisposable) OleDbCommand(System.ICloneable, System.Data.IDbCommand) Returned ByOleDbCommandBuilder.{GetDeleteCommand( ) , GetInsertCommand( ) , GetUpdateCommand( )} , OleDbConnection.CreateCommand( ) , OleDbDataAdapter.{DeleteCommand , InsertCommand , SelectCommand , UpdateCommand} , OleDbRowUpdatedEventArgs.Command , OleDbRowUpdatingEventArgs.Command Passed ToOleDbCommandBuilder.DeriveParameters( ) , OleDbDataAdapter.{DeleteCommand , InsertCommand , OleDbDataAdapter( ) , SelectCommand , UpdateCommand} , OleDbRowUpdatingEventArgs.Command |