Export (0) Print
Expand All

SqlCommand Members

SqlCommand overview

Public Constructors

public constructorSqlCommand Constructor

Supported by the .NET Compact Framework.

Overloaded. Initializes a new instance of the SqlCommand class.

Public Properties

public propertyCommandText

Supported by the .NET Compact Framework.

Gets or sets the Transact-SQL statement or stored procedure to execute at the data source.
public propertyCommandTimeout

Supported by the .NET Compact Framework.

Gets or sets the wait time before terminating the attempt to execute a command and generating an error.
public propertyCommandType

Supported by the .NET Compact Framework.

Gets or sets a value indicating how the CommandText property is to be interpreted.
public propertyConnection

Supported by the .NET Compact Framework.

Gets or sets the SqlConnection used by this instance of the SqlCommand.
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 Windows Forms Designer control.
public propertyParameters

Supported by the .NET Compact Framework.

Gets the SqlParameterCollection.
public propertySite (inherited from Component) Gets or sets the ISite of the Component.
public propertyTransaction

Supported by the .NET Compact Framework.

Gets or sets the SqlTransaction within which the SqlCommand executes.
public propertyUpdatedRowSource

Supported by the .NET Compact Framework.

Gets or sets how command results are applied to the DataRow when used by the Update method of the DbDataAdapter.

Public Methods

public methodCancel

Supported by the .NET Compact Framework.

Attempts to cancel the execution of a SqlCommand.
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

Supported by the .NET Compact Framework.

Creates a new instance of a SqlParameter object.
public methodDispose (inherited from Component) Overloaded. Releases the resources used by the Component.
public methodEquals (inherited from Object)

Supported by the .NET Compact Framework.

Overloaded. Determines whether two Object instances are equal.
public methodExecuteNonQuery

Supported by the .NET Compact Framework.

Executes a Transact-SQL statement against the connection and returns the number of rows affected.
public methodExecuteReader

Supported by the .NET Compact Framework.

Overloaded. Sends the CommandText to the Connection and builds a SqlDataReader.
public methodExecuteScalar

Supported by the .NET Compact Framework.

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 methodExecuteXmlReader

Supported by the .NET Compact Framework.

Sends the CommandText to the Connection and builds an XmlReader object.
public methodGetHashCode (inherited from Object)

Supported by the .NET Compact Framework.

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)

Supported by the .NET Compact Framework.

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

Supported by the .NET Compact Framework.

Creates a prepared version of the command on an instance of SQL Server.
public methodResetCommandTimeout

Supported by the .NET Compact Framework.

Resets the CommandTimeout property to its default value.
public methodToString (inherited from Object)

Supported by the .NET Compact Framework.

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 (inherited from Component)

Supported by the .NET Compact Framework.

Overloaded. Releases the resources used by the Component.
protected methodFinalize (inherited from Component)

Supported by the .NET Compact Framework.

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)

Supported by the .NET Compact Framework.

Creates a shallow copy of the current Object.

See Also

SqlCommand Class | System.Data.SqlClient Namespace

Show:
© 2014 Microsoft