.NET Framework Class Library
DbCommand Members

Represents an SQL statement or stored procedure to execute against a data source. Provides a base class for database-specific classes that represent commands.

The DbCommand type exposes the following members.

Constructors
  NameDescription
Protected methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkDbCommandConstructs an instance of the DbCommand object.
Top
Methods
  NameDescription
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkCancelAttempts to cancels the execution of a DbCommand.
Protected methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkCreateDbParameterCreates a new instance of a DbParameter object.
Public methodCreateObjRefCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkCreateParameterCreates a new instance of a DbParameter object.
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkDisposeOverloaded. Releases the resources used by the Component.
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkEqualsDetermines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkExecuteDbDataReaderExecutes the command text against the connection.
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkExecuteNonQueryExecutes a SQL statement against a connection object.
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkExecuteReaderOverloaded. Executes the CommandText against the Connection and returns a DbDataReader.
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkExecuteScalarExecutes the query and returns the first column of the first row in the result set returned by the query. All other columns and rows are ignored.
Protected methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkFinalizeReleases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (Inherited from Component.)
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkGetHashCodeServes as a hash function for a particular type. (Inherited from Object.)
Public methodGetLifetimeServiceRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected methodGetServiceReturns an object that represents a service provided by the Component or by its Container. (Inherited from Component.)
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodInitializeLifetimeServiceObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkMemberwiseCloneOverloaded.
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkPrepareCreates a prepared (or compiled) version of the command on the data source.
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkToStringOverloaded.
Top
Properties
  NameDescription
Protected propertyCanRaiseEventsGets a value indicating whether the component can raise an event. (Inherited from Component.)
Public propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkCommandTextGets or sets the text command to run against the data source.
Public propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkCommandTimeoutGets or sets the wait time before terminating the attempt to execute a command and generating an error.
Public propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkCommandTypeIndicates or specifies how the CommandText property is interpreted.
Public propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkConnectionGets or sets the DbConnection used by this DbCommand.
Public propertyContainerGets the IContainer that contains the Component. (Inherited from Component.)
Protected propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkDbConnectionGets or sets the DbConnection used by this DbCommand.
Protected propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkDbParameterCollectionGets the collection of DbParameter objects.
Protected propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkDbTransactionGets or sets the DbTransaction within which this DbCommand object executes.
Protected propertyDesignModeGets a value that indicates whether the Component is currently in design mode. (Inherited from Component.)
Public propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkDesignTimeVisibleGets or sets a value indicating whether the command object should be visible in a customized interface control.
Protected propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkEventsGets the list of event handlers that are attached to this Component. (Inherited from Component.)
Public propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkParametersGets the collection of DbParameter objects.
Public propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkSiteGets or sets the ISite of the Component. (Inherited from Component.)
Public propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkTransactionGets or sets the DbTransaction within which this DbCommand object executes.
Public propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkUpdatedRowSourceGets or sets how command results are applied to the DataRow when used by the Update method of a DbDataAdapter.
Top
Events
  NameDescription
Public eventSupported by the .NET Compact FrameworkSupported by the XNA FrameworkDisposedOccurs when the component is disposed by a call to the Dispose method. (Inherited from Component.)
Top
Explicit Interface Implementations
  NameDescription
Explicit interface implemetationPrivate propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkIDbCommand..::.Connection
Explicit interface implemetationPrivate methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkIDbCommand..::.CreateParameter
Public methodSupported by the .NET Compact FrameworkSupported by the XNA FrameworkExecuteReaderOverloaded. For a description of this member, see IDbCommand..::.ExecuteReader.
Explicit interface implemetationPrivate propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkIDbCommand..::.Parameters
Explicit interface implemetationPrivate propertySupported by the .NET Compact FrameworkSupported by the XNA FrameworkIDbCommand..::.Transaction
Top
See Also

Reference

DbCommand Class
System.Data.Common Namespace
Tags :


Page view tracker