Microsoft ADO.NET step by step

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

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Author Notes

Rebecca M. Riordan has worked as a consultant, systems analyst, and senior technical support engineer for Microsoft Australia, and has presented at Microsoft TechEd conferences on topics ranging from reusable system components to searching data stores. Rebecca studied database design and analysis at the University of California, Irvine

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

Mevcut:*

Bound With These Titles

On Order

Özet

Özet

Author Notes

Table of Contents