Export (0) Print
Expand All

SqlCommand Methods

The methods of the SqlCommand class are listed here. For a complete list of SqlCommand class members, see the SqlCommand Members topic.

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.

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