• Description:` Microsoft 70-310 Developing XML Web Services and Server Components with Microsoft Visual Basic .NET
• Passing Score:75%
• Practice Test - Number of questions:210 questions
• Simulation Test - Number of questions:210 questions
• Simulation Test Duration:41 minutes
• Has explanations:Yes

You are developing an application that queries a table named Products in a Microsoft SQL Server database. The query will be stored in a string variable named TKQuery. The query includes the following SQL code. SELECT * FROM Products For XML AUTO You 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?

Answer(s)

1. Use a SqlDataAdapter object and set its SelectCommand property to TKQuery. 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.
2. Use a SqlDataAdapter object and set its SelectCommand property to TKQuery. 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.
3. Set the SqlCommand object's Command Text to TKQuery. Use the ExecuteReader method of the SqlCommand object to create a SqlDataReader object. Use the Read method of the SqlDataReader object to read the data.
4. Set the SqlCommand object's Command Text to TKQuery. Use the ExecuteXmlReader method of the SqlCommand object to create a XmlReader object. Use the XmlReader object to read the data.

Set the SqlCommand object's Command Text to TKQuery. Use the ExecuteXmlReader method of the SqlCommand object to create a XmlReader object. Use the XmlReader object to read the data.