SqlCommand Members
Public Constructors
 SqlCommand Constructor Supported by the .NET Compact Framework. | Overloaded. Initializes a new instance of the SqlCommand class. |
Public Properties
 CommandText Supported by the .NET Compact Framework. | Gets or sets the Transact-SQL statement or stored procedure to execute at the data source. |
| CommandTimeout Supported by the .NET Compact Framework. | Gets or sets the wait time before terminating the attempt to execute a command and generating an error. |
| CommandType Supported by the .NET Compact Framework. | Gets or sets a value indicating how the CommandText property is to be interpreted. |
| Connection Supported by the .NET Compact Framework. | Gets or sets the SqlConnection used by this instance of the SqlCommand. |
| Container (inherited from Component) | Gets the IContainer that contains the Component. |
| DesignTimeVisible | Gets or sets a value indicating whether the command object should be visible in a Windows Forms Designer control. |
| Parameters Supported by the .NET Compact Framework. | Gets the SqlParameterCollection. |
| Site (inherited from Component) | Gets or sets the ISite of the Component. |
| Transaction Supported by the .NET Compact Framework. | Gets or sets the SqlTransaction within which the SqlCommand executes. |
| UpdatedRowSource 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
| 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. |
Public Events
 Disposed (inherited from Component) | Adds an event handler to listen to the Disposed event on the component. |
Protected Properties
 DesignMode (inherited from Component) | Gets a value that indicates whether the Component is currently in design mode. |
| Events (inherited from Component) | Gets the list of event handlers that are attached to this Component. |
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. |
