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
 Cancel Supported by the .NET Compact Framework. | Attempts to cancel the execution of a SqlCommand. |
| CreateObjRef (inherited from MarshalByRefObject) | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. |
| CreateParameter Supported by the .NET Compact Framework. | Creates a new instance of a SqlParameter object. |
| Dispose (inherited from Component) | Overloaded. Releases the resources used by the Component. |
| Equals (inherited from Object)
Supported by the .NET Compact Framework. | Overloaded. Determines whether two Object instances are equal. |
| ExecuteNonQuery Supported by the .NET Compact Framework. | Executes a Transact-SQL statement against the connection and returns the number of rows affected. |
| ExecuteReader Supported by the .NET Compact Framework. | Overloaded. Sends the CommandText to the Connection and builds a SqlDataReader. |
| ExecuteScalar 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. |
| ExecuteXmlReader Supported by the .NET Compact Framework. | Sends the CommandText to the Connection and builds an XmlReader object. |
| GetHashCode (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. |
| GetLifetimeService (inherited from MarshalByRefObject) | Retrieves the current lifetime service object that controls the lifetime policy for this instance. |
| GetType (inherited from Object)
Supported by the .NET Compact Framework. | Gets the Type of the current instance. |
| InitializeLifetimeService (inherited from MarshalByRefObject) | Obtains a lifetime service object to control the lifetime policy for this instance. |
| Prepare Supported by the .NET Compact Framework. | Creates a prepared version of the command on an instance of SQL Server. |
| ResetCommandTimeout Supported by the .NET Compact Framework. | Resets the CommandTimeout property to its default value. |
| ToString (inherited from Object)
Supported by the .NET Compact Framework. | Returns a String that represents the current Object. |
Protected Methods
 Dispose (inherited from Component)
Supported by the .NET Compact Framework. | Overloaded. Releases the resources used by the Component. |
| Finalize (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. |
| GetService (inherited from Component) | Returns an object that represents a service provided by the Component or by its Container. |
| MemberwiseClone (inherited from Object)
Supported by the .NET Compact Framework. | Creates a shallow copy of the current Object. |
