You set the commandtextproperty of the object


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? 

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: You set the commandtextproperty of the object
Reference No:- TGS079165

Expected delivery within 24 Hours