微软MCAD 70-310 实战百题
题目内容

You are developing an application that queries a table named Products in a Microsoft SQL Server database named Datal. The query will be stored in a string variable named sqlQuery. The query includes the following SQL code:SELECT * FROM Products FOR XML AUTOYou must iterate the query results and populate an HTML table with product information.You must ensure that your application processes the results as quickly as possible.What should you do?

2021-12-25

A.Use a SqlDataAdapter object and set its SelectComir:and property to sqlQuery. Use the Fill method of the SqlDataAdapter object to read the data into a Dataset object. Loop through the associated rows to read the data

B.Use a SqlDataAdapter object and set its SelectCommand property to sqlQuery. Use the Fill method of the SqlDataAdapter object to read the data into a Dataset object. Use the ReadXml method of the DataSet object to read the data

C.Set the SqlCommand object's CommandText to sqlQuery. Use the ExecuteReader method of the SqlCommand object to create aSqlDataReader object. Use the Read method of the SqlDataReader object to read the data

D.Set the SqlCommand object's CommandText to sqlQuery. Use the ExecuteXmlReader method of the SqlCommand object to create an XmlReader object. Use the XmlReader object to read the data

题目答案

试卷相关题目

最新试卷
热门试卷

长理培训客户端 资讯,试题,视频一手掌握

去 App Store 免费下载 iOS 客户端