What is the use of command objects?

Posted By: Avi

Date: 15 October 2009 05:03:07 AM

Answer:

This object represents an SQL statement that is executed while connected to the database. Following are the main methods provided by command object: 1) ExecuteNonQuery: Executes the SQL query or Stored Procedure that does not return any row (an UPDATE, DELETE, or INSERT). Returns an Integer indicating the number of rows affected by the query. 2) ExecuteReader: Executes the SQL query or Stored Procedure and returns a DataReader object that is connected to the resulting row set within the database, allowing the rows to be retrieved. 3) ExecuteScalar: Executes the SQL query or Stored Procedure and returns only single value (effectively the first column of the first row of the resulting row set any other returned columns and rows are discarded).
Posted By: eTechPlanet	Date: 15 October 2009 05:03:07 AM
Use of a Command object to query a database and return to records in a Recordset object, to execute a bulk operation, or to manipulate the structure of a database. Depending on the functionality of the provider, some Command collections, methods, or properties may generate an error when they are referenced.
Posted By: Daniel	Date: 16 February 2010 03:21:49 AM