Name | Description | |
---|---|---|
SqlCommand Constructor | Overloaded. Initializes a new instance of the SqlCommand class. |
The following tables list the members exposed by SqlCommand.
Name | Description | |
---|---|---|
SqlCommand Constructor | Overloaded. Initializes a new instance of the SqlCommand class. |
Name | Description | |
---|---|---|
CommandText | Gets or sets the SQL statement to execute against SQL Server. | |
CommandTimeout | Overridden. Gets or sets the wait time before terminating an attempt to execute a command and generating an error. Note that it is the time to wait for any server reply since the command was sent to a server, and it doesn't include the time necessary to fetch data if the command selects some data. | |
CommandType | Gets or sets a value indicating how the CommandText property is to be interpreted. (Inherited from Devart.Common.DbCommandBase) | |
Connection | Gets or sets the SqlConnection used by this instance of the SqlCommand. | |
Container | Gets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
Notification | Gets or sets the System.Data.Sql.SqlNotificationRequest object bound to this SqlCommand. | |
NotificationAutoEnlist | Determines whether the application should automatically receive query notifications from a common SqlDependency object. | |
Owner | Gets or sets a form or other container that the Devart.Common.DbCommandBase instance belongs to. (Inherited from Devart.Common.DbCommandBase) | |
ParameterCheck | Gets or sets a value indicating whether the command object regenerates parameter objects if text of the command is changed. (Inherited from Devart.Common.DbCommandBase) | |
Parameters | Gets or sets the SqlParameterCollection. | |
Site | Gets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
Transaction | Gets the SqlTransaction in which the SqlCommand is executed. | |
UpdatedRowSource | Gets or sets how command results are applied to the System.Data.DataRow when used by the System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) method of the System.Data.Common.DbDataAdapter. (Inherited from Devart.Common.DbCommandBase) |
Name | Description | |
---|---|---|
BeginExecuteNonQuery | Overloaded. Starts an asynchronous invocation of an ExecuteNonQuery method. | |
BeginExecuteReader | Overloaded. Starts an asynchronous invocation of an ExecuteReader method. | |
BeginExecuteXmlReader | Overloaded. Starts an asynchronous invocation of an ExecuteXmlReader method. | |
Cancel | Overridden. Tries to cancel the execution of a SqlCommand. | |
Clone | Creates a new object that is a copy of the current SqlCommand instance. | |
CreateObjRef | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject) | |
CreateParameter | Creates a new instance of a SqlParameter object. | |
Dispose() | Releases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
EndExecuteNonQuery | Ends an asynchronous invocation of the ExecuteNonQuery method. | |
EndExecuteReader | Ends an asynchronous invocation of the ExecuteReader method. | |
EndExecuteXmlReader | Ends an asynchronous invocation of the ExecuteXmlReader method. | |
ExecuteNonQuery | Overridden. Executes SQL statement against the SqlConnection and returns the number of rows affected. | |
ExecutePageReader | Returns a specific subset of rows when paging through the results of a query. | |
ExecuteReader | Overloaded. Sends the CommandText to the Connection and builds a SqlDataReader. | |
ExecuteScalar | 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. (Inherited from Devart.Common.DbCommandBase) | |
ExecuteXmlReader | Sends the CommandText to the SqlConnection and builds an XmlReader object. | |
GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) | |
GetRecordCount | Returns count of records in the resultset. (Inherited from Devart.Common.DbCommandBase) | |
InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) | |
Prepare | Creates a prepared (or compiled) version of the command on the server. (Inherited from Devart.Common.DbCommandBase) | |
PrepareCore | (Inherited from Devart.Common.DbCommandBase) | |
ResetCommandTimeout | Resets CommandTimeout to its default value, which is taken from DefaultCommandTimeout. (Inherited from Devart.Common.DbCommandBase) | |
ToString | Returns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.Component) |
Name | Description | |
---|---|---|
Disposed | Occurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component) | |
StatementCompleted | Occurs when the execution of a SQL statement completes. |