You create an ASP.NET application to display a sorted list of products in a DataGrid control. The product data is stored in a Microsoft SQL Server database. Each product is identified by a numerical value named ProductID, and each product has an alphabetic named ProductName. 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 CommandType property of the SqlCommand object to Commandtype.StoredProcedure.
You set the CommandTextproperty of the object to procProductList. Your code successfully fills a DataTable object with a list of products that is sorted by productID in descending order. You want the data to be displayed in reverse alphabetic order by ProductName. What should you do?