Hour 23

Quiz Answers

1: For best performance, of the DataAdapter and DataReader objects, which would you use to bind database data to a pageable DataGrid object to display the results of a query on a form?
A1: This is a trick question. Because you would be unable to page through data with a DataReader object, you should use the DataAdapter to return a DataSet.
2: Name one way you can improve the responsiveness of your queries using the Microsoft SQL Query Analyzer.
A2: First, you can use the Query Analyzer to display SQL Server's execution plan for your query. You can use this plan to discover how you could better structure the query. Additionally, you can also use the Query Analyzer to analyze the indexes of your table. Often, the Query Analyzer ...

Get Sams Teach Yourself ADO.NET in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.