The Command Object requires an instance of an ASP.NET Connection Object for executing the SQL statements . The Command Object in ADO.NET executes SQL statements and Stored Procedures against the data source specified in the ASP.NET Connection Object.
The Command Object has a property called CommandText , which contains a String value that represents the command that will be executed against the Data Source. When the CommandType property is set to StoredProcedure, the CommandText property should be set to the name of the stored procedure.
Click the following links to see some important built in methods uses in the Command Object to execute the SQL statements.