Microsoft ADO .NET Step by Step

Microsoft Corporation

  • 出版商: MicroSoft
  • 出版日期: 2002-02-16
  • 售價: $1,670
  • 貴賓價: 9.5$1,587
  • 語言: 英文
  • 頁數: 528
  • 裝訂: Paperback
  • ISBN: 0735612366
  • ISBN-13: 9780735612365
  • 相關分類: .NET
  • 已過版

買這商品的人也買了...

相關主題

商品描述

Description:

Work in ADO.NET right away with this accessible, modular primer—based on the proven Microsoft STEP BY STEP learning method.

ADO.NET—the data-access component of the Microsoft .NET Framework—works with any component on any platform that understands XML. Get a solid handle on ADO.NET and learn how to exploit the database functionality of Microsoft Visual Basic® .NET and Microsoft Visual C#™ .NET with this step-by-step primer. You’ll be working in ADO.NET right away with easy-to-grasp examples drawn from the real-world challenges developers face every day. Learn about the ADO.NET object model and how to use it to develop data-bound Windows® Forms and Web Forms. See how ADO.NET interacts with XML and how to access older versions of ADO from the .NET environment. Throughout, you’ll find insightful tips and expert explanations for rapid acceleration of development productivity, faster applications, and more powerful results. Topics covered include:

• Getting started with ADO.NET
• Creating connections
• The Data command and DataReader
• Accessing data with the DataAdapter
• Working with DataSets
• Working with DataTables
• Controlling table views with DataViews
• Editing and updating data
• Data-binding in Windows Forms
• Data-binding in Web Forms
• Using the XML Designer to modify data structure
• Reading and writing XML with ADO.NET
• Using ADO from the .NET Framework

CD features:
• Examples of real-world solutions developed with ADO.NET, including sample code in Visual Basic .NET and Visual C# .NET

 

Table of Contents:

Introduction Ix
    Conventions and Features in This Book x / Using the ADO.NET Step by Step CD-ROM x  
PART 1  GETTING STARTED WITH ADO.NET 1
CHAPTER 1  Getting Started with ADO.NET 3
    On the Fundamental Interconnectedness of All Things 4 / The ADO.NET Object Model 4 / Binding Data to a Simple Windows Form 7  
PART 2  DATA PROVIDERS 21
CHAPTER 2  Creating Connections 23
    Understanding Connections 23 / Creating Connections 24 / Using Connection Properties 31 / Connection Methods 38 / Handling Connection Events 41  
CHAPTER 3  Data Commands and the DataReader 45
    Understanding Data Commands and DataReaders 45 / Creating Data Commands 46 / Command Properties 49 / Command Methods 59  
CHAPTER 4  The DataAdapter 71
    Understanding the DataAdapter 71 / Creating DataAdapters 72 / DataAdapter Properties 79 / DataAdapter Methods 86 / Handling DataAdapter Events 97  
CHAPTER 5  Transaction Processing in ADO.NET 109
    Understanding Transactions 109 / Creating Transactions 110 / Using Transactions 119  
PART 3  MANIPULATING DATA 129
CHAPTER 6  The DataSet 131
    Understanding DataSets 132 / Creating DataSets 133 / DataSet Properties 139 / DataSet Methods 153  
CHAPTER 7  The DataTable 161
    Understanding DataTables 161 / Creating DataTables 162 / DataTable Properties 170 / DataTable Methods 190 / DataTable Events 197  
CHAPTER 8  The DataView 199
    Understanding DataViews 199 / Creating DataViews 201 / DataView Properties 206 / DataView Methods 215  
PART 4  USING THE ADO.NET OBJECTS 219
CHAPTER 9  Editing and Updating Data 221
    Understanding Editing and Updating Data 221 / DataRow States and Versions 223 / Editing Data in a DataSet 226 / Updating Data Sources 236 / Accepting and Rejecting DataSet Changes 245  
CHAPTER 10  ADO.NET Data-Binding in Windows Forms 257
    Understanding Data-Binding in Windows Forms 258 / Binding Controls to an ADO.NET Data Source 260 / Using the BindingContext Object 273 / Using the CurrencyManager Object 274  
CHAPTER 11  Using ADO.NET in Windows Forms 289
    Formatting Data 289 / Displaying Data in Windows Controls 299 / Validating Data in Windows Forms 325  
CHAPTER 12  Data-Binding in Web Forms 343
    Understanding Data-Binding in Web Forms 343 / Binding Controls to an ADO.NET Data Source 346 / Maintaining ADO.NET Object State 357 / Updating a Data Source from a Web Form 362  
CHAPTER 13  Using ADO.NET in Web Forms 367
    Using Template-Based Web Controls 367 / Moving Through Data 390  
PART 5  ADO.NET AND XML 407
CHAPTER 14  Using the XML Designer 409
    Understanding the XML Schemas 409 / Creating XML Schema and Typed DataSets 411 / Working with DataTables in the XML Designer 419 / Working with Elements 430 / Working with Types 433 / Working with Attributes 441  
CHAPTER 15  Reading and Writing XML 445
    Understanding ADO.NET and XML 445 / Using the DataSet XML Methods 446 / Controlling How the XML Is Written 472 / The XmlDataDocument Object 479  
CHAPTER 16  Using ADO in the .NET Framework 483
    Understanding COM Interoperablility 483 / Using ADO in the .NET Framework 485 / Using ADOX in the .NET Framework 497  
ABOUT THE AUTHOR 506
INDEX 507