As a developer, you are displaying product data from SQL Server. Product table has Productid and Product Name. You write ADO.NET code that uses a SqlDataAdapter object and a SqlCommand object to retrieve the product data from the database by calling a stored procedure. You set the Command Type property of the SqlCommand object to CommandType.StoredProcedure. You set the Command Text property of the object to procProductList. Your code successfully files a DataTable object with a list of products that is sorted by ProductID in descending order.


The CommandText property on a Command object contains the text of a command that you want to issue against a provider. This property sets or returns a String value containing a provider command, such as an AS/400 Command Language (CL) command for execution by the remote OS/400 DDM target server or an SQL command for execution on a DB2 database server.