O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required