Export (0) Print
Expand All

SqlCommand Members

Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.

The SqlCommand type exposes the following members.

  NameDescription
Public method Supported by the .NET Compact Framework SqlCommand Overloaded. Initializes a new instance of the SqlCommand class.
Top

  NameDescription
Public method BeginExecuteNonQuery Overloaded. Initiates the asynchronous execution of the Transact-SQL statement or stored procedure that is described by this SqlCommand.
Public method BeginExecuteReader Overloaded. Initiates the asynchronous execution of the Transact-SQL statement or stored procedure that is described by this SqlCommand, and retrieves one or more result sets from the server.
Public method BeginExecuteXmlReader Overloaded. Initiates the asynchronous execution of the Transact-SQL statement or stored procedure that is described by this SqlCommand and returns results as an XmlReader object.
Public method Supported by the .NET Compact Framework Cancel Tries to cancel the execution of a SqlCommand. (Overrides DbCommand.Cancel().)
Public method Clone Creates a new SqlCommand object that is a copy of the current instance.
Protected method CreateDbParameter Creates a new instance of a DbParameter object. (Inherited from 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 CreateParameter Creates a new instance of a SqlParameter object.
Public method Supported by the .NET Compact Framework Dispose Overloaded. Releases the resources used by the Component.
Public method EndExecuteNonQuery Finishes asynchronous execution of a Transact-SQL statement.
Public method EndExecuteReader Finishes asynchronous execution of a Transact-SQL statement, returning the requested SqlDataReader.
Public method EndExecuteXmlReader Finishes asynchronous execution of a Transact-SQL statement, returning the requested data as XML.
Public method Supported by the .NET Compact Framework Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method ExecuteDbDataReader Executes the command text against the connection. (Inherited from DbCommand.)
Public method Supported by the .NET Compact Framework ExecuteNonQuery Executes a Transact-SQL statement against the connection and returns the number of rows affected. (Overrides DbCommand.ExecuteNonQuery().)
Public method Supported by the .NET Compact Framework ExecuteReader Overloaded. Sends the CommandText to the Connection and builds a SqlDataReader.
Public method Supported by the .NET Compact Framework ExecuteScalar Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored. (Overrides DbCommand.ExecuteScalar().)
Public method Supported by the .NET Compact Framework ExecuteXmlReader Sends the CommandText to the Connection and builds an XmlReader object.
Protected method Supported by the .NET Compact Framework Finalize Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (Inherited from Component.)
Public method Supported by the .NET Compact 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.)
Protected method GetService Returns an object that represents a service provided by the Component or by its Container. (Inherited from Component.)
Public method Supported by the .NET Compact 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.)
Protected method Supported by the .NET Compact Framework MemberwiseClone Overloaded.
Public method Supported by the .NET Compact Framework Prepare Creates a prepared version of the command on an instance of SQL Server. (Overrides DbCommand.Prepare().)
Public method Supported by the .NET Compact Framework ResetCommandTimeout Resets the CommandTimeout property to its default value.
Public method ToString Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from Component.)
Top

  NameDescription
Protected property CanRaiseEvents Gets a value indicating whether the component can raise an event. (Inherited from Component.)
Public property Supported by the .NET Compact Framework CommandText Gets or sets the Transact-SQL statement, table name or stored procedure to execute at the data source. (Overrides DbCommand.CommandText.)
Public property Supported by the .NET Compact Framework CommandTimeout Gets or sets the wait time before terminating the attempt to execute a command and generating an error. (Overrides DbCommand.CommandTimeout.)
Public property Supported by the .NET Compact Framework CommandType Gets or sets a value indicating how the CommandText property is to be interpreted. (Overrides DbCommand.CommandType.)
Public property Supported by the .NET Compact Framework Connection Gets or sets the SqlConnection used by this instance of the SqlCommand.
Public property Container Gets the IContainer that contains the Component. (Inherited from Component.)
Protected property DbConnection Gets or sets the DbConnection used by this DbCommand. (Inherited from DbCommand.)
Protected property DbParameterCollection Gets the collection of DbParameter objects. (Inherited from DbCommand.)
Protected property DbTransaction Gets or sets the DbTransaction within which this DbCommand object executes. (Inherited from DbCommand.)
Protected property DesignMode Gets a value that indicates whether the Component is currently in design mode. (Inherited from Component.)
Public property DesignTimeVisible Gets or sets a value indicating whether the command object should be visible in a Windows Form Designer control. (Overrides DbCommand.DesignTimeVisible.)
Protected property Supported by the .NET Compact Framework Events Gets the list of event handlers that are attached to this Component. (Inherited from Component.)
Public property Notification Gets or sets a value that specifies the SqlNotificationRequest object bound to this command.
Public property NotificationAutoEnlist Gets or sets a value indicating whether the application should automatically receive query notifications from a common SqlDependency object.
Public property Supported by the .NET Compact Framework Parameters Gets the SqlParameterCollection.
Public property Supported by the .NET Compact Framework Site Gets or sets the ISite of the Component. (Inherited from Component.)
Public property Supported by the .NET Compact Framework Transaction Gets or sets the SqlTransaction within which the SqlCommand executes.
Public property Supported by the .NET Compact Framework UpdatedRowSource Gets or sets how command results are applied to the DataRow when used by the Update method of the DbDataAdapter. (Overrides DbCommand.UpdatedRowSource.)
Top

  NameDescription
Public event Supported by the .NET Compact Framework Disposed Occurs when the component is disposed by a call to the Dispose method. (Inherited from Component.)
Public event StatementCompleted Occurs when the execution of a Transact-SQL statement completes.
Top

Community Additions

ADD
Show:
© 2015 Microsoft