This documentation is archived and is not being maintained.

OleDbCommand Members

OleDbCommand overview

Public Constructors

public constructorOleDbCommand Constructor Overloaded. Initializes a new instance of the OleDbCommand class.

Public Properties

public propertyCommandText Gets or sets the SQL statement or stored procedure to execute at the data source.
public propertyCommandTimeout Gets or sets the wait time before terminating an attempt to execute a command and generating an error.
public propertyCommandType Gets or sets a value indicating how the CommandText property is interpreted.
public propertyConnection Gets or sets the OleDbConnection used by this instance of the OleDbCommand.
public propertyContainer (inherited from Component) Gets the IContainer that contains the Component.
public propertyDesignTimeVisible Gets or sets a value indicating whether the command object should be visible in a customized Windows Forms Designer control.
public propertyParameters Gets the OleDbParameterCollection.
public propertySite (inherited from Component) Gets or sets the ISite of the Component.
public propertyTransaction Gets or sets the OleDbTransaction within which the OleDbCommand executes.
public propertyUpdatedRowSource Gets or sets how command results are applied to the DataRow when used by the Update method of the DbDataAdapter.

Public Methods

public methodCancel Attempts to cancel the execution of an OleDbCommand.
public methodCreateObjRef (inherited from MarshalByRefObject) Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
public methodCreateParameter Creates a new instance of an OleDbParameter object.
public methodDispose (inherited from Component) Overloaded. Releases the resources used by the Component.
public methodEquals (inherited from Object) Overloaded. Determines whether two Object instances are equal.
public methodExecuteNonQuery Executes a SQL statement against the Connection and returns the number of rows affected.
public methodExecuteReader Overloaded. Sends the CommandText to the Connection and builds an OleDbDataReader.
public methodExecuteScalar Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.
public methodGetHashCode (inherited from Object) Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table.
public methodGetLifetimeService (inherited from MarshalByRefObject) Retrieves the current lifetime service object that controls the lifetime policy for this instance.
public methodGetType (inherited from Object) Gets the Type of the current instance.
public methodInitializeLifetimeService (inherited from MarshalByRefObject) Obtains a lifetime service object to control the lifetime policy for this instance.
public methodPrepare Creates a prepared (or compiled) version of the command on the data source.
public methodResetCommandTimeout Resets the CommandTimeout property to the default value.
public methodToString (inherited from Object) Returns a String that represents the current Object.

Public Events

public eventDisposed (inherited from Component) Adds an event handler to listen to the Disposed event on the component.

Protected Properties

protected propertyDesignMode (inherited from Component) Gets a value that indicates whether the Component is currently in design mode.
protected propertyEvents (inherited from Component) Gets the list of event handlers that are attached to this Component.

Protected Methods

protected methodDispose Overloaded. Overridden. Releases the resources used by the OleDbCommand.
protected methodFinalize (inherited from Component) Overridden. Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection.

In C# and C++, finalizers are expressed using destructor syntax.

protected methodGetService (inherited from Component) Returns an object that represents a service provided by the Component or by its Container.
protected methodMemberwiseClone (inherited from Object) Creates a shallow copy of the current Object.

See Also

OleDbCommand Class | System.Data.OleDb Namespace