Microsoft ADO. NET Step by Step

by Microsoft Corporation

• ISBN13: 9780735612365
• ISBN10: 0735612366
• Edition: 1st
• Format: Paperback
• Copyright: 2002-02-06
• Publisher: Microsoft Press

Summary

This title is ideal for any developer who seeks guidance on how to exploit the database functionality and advanced, integrated development environment in Microsoft Visual Basic .NET. The book covers core Visual Basic database development topics, with details on using Visual Basic .Net with Microsoft ActiveX Data Objects (ADO), ADO+, and Microsoft SQL Server. It's full of insightful explanations and expertly rendered examples for rapid acceleration of development productivity, faster applications, and more powerful results.

Author Biography

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

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	(20)
Getting Started with ADO.NET	3	(18)
On the Fundamental Interconnectedness of All Things	4	(1)
The ADO.NET Object Model	4	(3)
Binding Data to a Simple Windows Form	7	(14)
PART 2 Data Providers	21	(108)
Creating Connections	23	(22)
Understanding Connections	23	(1)
Creating Connections	24	(7)
Using Connection Properties	31	(7)
Connection Methods	38	(3)
Handling Connection Events	41	(4)
Data Commands and the DataReader	45	(26)
Understanding Data Commands and DataReaders	45	(1)
Creating Data Commands	46	(3)
Command Properties	49	(10)
Command Methods	59	(12)
The DataAdapter	71	(38)
Understanding the DataAdapter	71	(1)
Creating DataAdapters	72	(7)
DataAdapter Properties	79	(7)
DataAdapter Methods	86	(11)
Handling DataAdapter Events	97	(12)
Transcation Processing in ADO.NET	109	(20)
Understanding Transactions	109	(1)
Creating Transactions	110	(9)
Using Transactions	119	(10)
PART 3 Manipulating Data	129	(90)
The DataSet	131	(30)
Understanding DataSets	132	(1)
Creating DataSets	133	(6)
DataSet Properties	139	(14)
DataSet Methods	153	(8)
The Data Table	161	(38)
Understanding Data Table	161	(1)
Creating Data Tables	162	(8)
Data Table Properties	170	(20)
Data Table Methods	190	(7)
Data Table Events	197	(2)
The Data View	199	(20)
Understanding Data Views	199	(2)
Creating Data Views	201	(5)
Data View Properties	206	(9)
Data View Methods	215	(4)
PART 4 Using the ADO.NET Objects	219	(188)
Editing and Updating Data	221	(36)
Understanding Editing and Updating Data	221	(2)
DataRow States and Versions	223	(3)
Editing Data in a DataSet	226	(10)
Updating Data Sources	236	(9)
Accepting and Rejecting DataSet Changes	245	(12)
ADO.NET Data-Binding in Windows Forms	257	(32)
Understanding Data-Binding in Windows Forms	258	(2)
Binding Controls to an ADO.NET Data Source	260	(13)
Using the BindingContext Object	273	(1)
Using the CurrencyManager Object	274	(15)
Using ADO.NET in Windows Forms	289	(54)
Formatting Data	289	(10)
Displaying Data in Windows Controls	299	(26)
Validating Data in Windows Forms	325	(18)
Data-Binding in Web Forms	343	(24)
Understanding Data-Binding in Web Forms	343	(3)
Binding Controls to an ADO.NET Data Source	346	(11)
Maintaining ADO.NET Object State	357	(5)
Updating a Data Source from a Web Form	362	(5)
Using ADO.NET in Web Forms	367	(40)
Using Template-Based Web Controls	367	(23)
Moving Through Data	390	(17)
PART 5 ADO.NET and XML	407	(99)
Using the XML Designer	409	(36)
Understanding the XML Schemas	409	(2)
Creating XML Schema and Typed DataSets	411	(8)
Working with Data Tables in the XML Designer	419	(11)
Working with Elements	430	(3)
Working with Types	433	(8)
Working with Attributes	441	(4)
Reading and Writing XML	445	(38)
Understanding ADO.NET and XML	445	(1)
Using the DataSet XML Methods	446	(26)
Controlling How the XML is Written	472	(7)
The XmlDataDocument Object	479	(4)
Using ADO in the .NET Framework	483	(23)
Understanding COM Interoperablility	483	(2)
Using ADO in the .NET Framework	485	(12)
Using ADOX in the .NET Framework	497	(9)
About the Author	506	(1)
Index	507