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.

128.

Set the command text to “SELECT * FROM procProductList ORDER BY ProductName DESC;” then bind the Data Grid control to the DataTable object.

Create a new Data View object based on the DataTable object.

Set the Sort Property of the Data View object to “ProductName DESC”.

Bind the Data Grid control to the Data View object.

Set the Allow Sorting property of the Data Grid control to True.

View Description

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.