VS. NET (C #) Database Interface: common attributes and methods of SqlCommand objects, vs.net

VS. NET (C #) Database Interface: common attributes and methods of SqlCommand objects, vs.net

Common attributes

Attribute	Description
CommandText	The return type is string. Obtain or set the SQL statement, stored procedure, or table to be executed on the data source.
CommandTimeOut	The return type is int, which gets or sets the waiting time before the Command Execution Attempt is terminated and an error is generated.
CommandType	The return type is CommandType. Reading or setting indicates how the CommandText attribute is interpreted. The valid value can be CommandType. text, CommandType. storedProcedur and CommandType. tableDirect, indicating SQL statements, stored procedure calls, or tables to be read. The default value is Text.
Connection	The return type is string. Obtain or set the SqlConnection used by this instance of SqlCommand.
Parameters	The return type is SqlParameterCollection. Obtain the parameters provided to the command and bind the parameters of the SQL statement or stored procedure. An indispensable object in parametric query.
Tranction	Gets or sets the transaction where the Command object of the. NET Framework data provider is executed.

Common Methods

 

Method	Description
Cancle ()	Its return type is void, canceling Command Execution
CreateParameter ()	The return type is SqlParameter, which is used to create a new instance of the SqlParameter object.
ExecuteNonQuery ()	Execute the operations specified by the CommandText attribute. Generally, they are update, insert, delete, and other SQL commands without return values (such as DDL statements and stored procedures). The number of affected rows is returned, and the type is int. For all other types of statements, the return value is-1.
ExecuteReader ()	Perform the operations specified by the CommandText attribute, create a DataReader object, and return the result set in the SqlDataReader object.
ExecuteScalar ()	The return type of the operation specified by the CommandText attribute is object. The result of this command is returned as an object. Returns the first column of the First row in the execution result set. If no data exists, NULL is returned. It is generally used to execute results such as max, min, Count, and sun.
ExecuteXmlReader ()	The return type is XmlReader. Execute the SELECT statement that returns XML data and use the XmlReader object to return the result set. It is only applicable to the SqlCommand class.
Execute ()	Execute the query, SQL statement, or stored procedure specified in the CommandText attribute of the Command object. If the CommandText attribute specifies the query returned in rows, any results produced by execution will be stored in the new Recordset object. Otherwise, the provider will return the closed Recordset object.