Export (0) Print
Expand All

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 following tables list the members exposed by the DbCommand type.

  Name Description
Protected method Supported by the .NET Compact Framework Supported by the XNA Framework DbCommand Constructs an instance of the DbCommand object.
Top

(see also Protected Properties )
  Name Description
Public property Supported by the .NET Compact Framework Supported by the XNA Framework CommandText Gets or sets the text command to run against the data source.
Public property Supported by the .NET Compact Framework Supported by the XNA Framework CommandTimeout Gets or sets the wait time before terminating the attempt to execute a command and generating an error.
Public property Supported by the .NET Compact Framework Supported by the XNA Framework CommandType Indicates or specifies how the CommandText property is interpreted.
Public property Supported by the .NET Compact Framework Supported by the XNA Framework Connection Gets or sets the DbConnection used by this DbCommand.
Public property Container  Gets the IContainer that contains the Component.(inherited from Component)
Public property Supported by the .NET Compact Framework Supported by the XNA Framework DesignTimeVisible Gets or sets a value indicating whether the command object should be visible in a customized interface control.
Public property Supported by the .NET Compact Framework Supported by the XNA Framework Parameters Gets the collection of DbParameter objects.
Public property Supported by the .NET Compact Framework Supported by the XNA Framework Site  Gets or sets the ISite of the Component.(inherited from Component)
Public property Supported by the .NET Compact Framework Supported by the XNA Framework Transaction Gets or sets the DbTransaction within which this DbCommand object executes.
Public property Supported by the .NET Compact Framework Supported by the XNA Framework UpdatedRowSource Gets or sets how command results are applied to the DataRow when used by the Update method of a DbDataAdapter.
Top

  Name Description
Protected property CanRaiseEvents  Gets a value indicating whether the component can raise an event.(inherited from Component)
Protected property Supported by the .NET Compact Framework Supported by the XNA Framework DbConnection Gets or sets the DbConnection used by this DbCommand.
Protected property Supported by the .NET Compact Framework Supported by the XNA Framework DbParameterCollection Gets the collection of DbParameter objects.
Protected property Supported by the .NET Compact Framework Supported by the XNA Framework DbTransaction Gets or sets the DbTransaction within which this DbCommand object executes.
Protected property DesignMode  Gets a value that indicates whether the Component is currently in design mode.(inherited from Component)
Protected property Supported by the .NET Compact Framework Supported by the XNA Framework Events  Gets the list of event handlers that are attached to this Component.(inherited from Component)
Top

(see also Protected Methods )
  Name Description
Public method Supported by the .NET Compact Framework Supported by the XNA Framework Cancel Attempts to cancels the execution of a DbCommand.
Public method CreateObjRef  Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (inherited from MarshalByRefObject)
Public method Supported by the .NET Compact Framework Supported by the XNA Framework CreateParameter Creates a new instance of a DbParameter object.
Public method Supported by the .NET Compact Framework Supported by the XNA Framework Dispose  Overloaded. Releases the resources used by the Component. (inherited from Component)
Public method Supported by the .NET Compact Framework Supported by the XNA Framework Equals  Overloaded. Determines whether two Object instances are equal. (inherited from Object)
Public method Supported by the .NET Compact Framework Supported by the XNA Framework ExecuteNonQuery Executes a SQL statement against a connection object.
Public method Supported by the .NET Compact Framework Supported by the XNA Framework ExecuteReader Overloaded. Executes the CommandText against the Connection and returns a DbDataReader.
Public method Supported by the .NET Compact Framework Supported by the XNA Framework ExecuteScalar Executes 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.
Public method Supported by the .NET Compact Framework Supported by the XNA Framework GetHashCode  Serves as a hash function for a particular type. (inherited from Object)
Public method GetLifetimeService  Retrieves the current lifetime service object that controls the lifetime policy for this instance. (inherited from MarshalByRefObject)
Public method Supported by the .NET Compact Framework Supported by the XNA Framework GetType  Gets the Type of the current instance. (inherited from Object)
Public method InitializeLifetimeService  Obtains a lifetime service object to control the lifetime policy for this instance. (inherited from MarshalByRefObject)
Public method Supported by the .NET Compact Framework Supported by the XNA Framework Prepare Creates a prepared (or compiled) version of the command on the data source.
Public method Static Supported by the .NET Compact Framework ReferenceEquals  Determines whether the specified Object instances are the same instance. (inherited from Object)
Public method Supported by the .NET Compact Framework ToString  Returns a String containing the name of the Component, if any. This method should not be overridden. (inherited from Component)
Top

  Name Description
Protected method Supported by the .NET Compact Framework Supported by the XNA Framework CreateDbParameter Creates a new instance of a DbParameter object.
Protected method Supported by the .NET Compact Framework Supported by the XNA Framework Dispose  Overloaded. Releases the resources used by the Component. (inherited from Component)
Protected method Supported by the .NET Compact Framework Supported by the XNA Framework ExecuteDbDataReader Executes the command text against the connection.
Protected method Supported by the .NET Compact Framework Supported by the XNA Framework Finalize  Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (inherited from Component)
Protected method GetService  Returns an object that represents a service provided by the Component or by its Container. (inherited from Component)
Protected method Supported by the .NET Compact Framework MemberwiseClone  Overloaded. (inherited from MarshalByRefObject)
Top

  Name Description
Public event Supported by the .NET Compact Framework Supported by the XNA Framework Disposed  Occurs when the component is disposed by a call to the Dispose method. (inherited from Component)
Top

Community Additions

ADD
Show:
© 2015 Microsoft