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. |