tailieunhanh - Module 2: Connecting to Data Sources

This module contains code examples that are linked to text hyperlinks at the bottom of PowerPoint slides. These examples enable you to teach from code examples that are too long to display on a slide. All the code examples for this module are contained in one .htm file. Students can copy the code directly from the browser or from the source, and paste it into a development environment. | msdn training Module 2 Connecting to Data Sources Contents Overview 1 Lesson Choosing a .NET Data Provider 2 Lesson Defining a Connection 8 Lesson Managing a Connection 16 Lesson Handling Connection Exceptions 25 Lesson Connection Pooling 37 Review Connecting to Data Sources 48 Lab Connecting to Data Sources 50 Microsoft Information in this document including URL and other Internet Web site references is subject to change without notice. Unless otherwise noted the example companies organizations products domain names e-mail addresses logos people places and events depicted herein are fictitious and no association with any real company organization product domain name e-mail address logo person places or events is intended or should be inferred. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright no part of this document may be reproduced stored in or introduced into a retrieval system or transmitted in any form or by any means electronic mechanical photocopying recording or otherwise or for any purpose without the express written permission of Microsoft Corporation. Microsoft may have patents patent applications trademarks copyrights or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft the furnishing of this document does not give you any license to these patents trademarks copyrights or other intellectual property. 2001-2002 Microsoft Corporation. All rights reserved. Microsoft MS-DOS Windows Windows NT Win32 Active Directory ActiveX BizTalk IntelliSense JScript MSDN SQL Server Visual Basic Visual C Visual C Visual J Visual Studio and Windows Media are either registered trademarks or trademarks of Microsoft Corporation in the . and or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners. Module 2 Connecting to