Chapter 19. Using ADO and ADOX in the .NET Framework

After completing this chapter, you will be able to:

  • Establish a reference to the ADO and ADOX COM libraries.

  • Create an ADO Connection.

  • Retrieve data from an ADO Recordset.

  • Update an ADO Recordset.

  • Create a database by using ADOX.

  • Add a table to a database by using ADOX.

In the previous two chapters, we examined using XML data with Microsoft ADO.NET objects. In this chapter, we'll look at the interface to another type of data: data objects created using previous versions of ADO.

We'll also examine the Microsoft ADO Extensions for DDL and Security (ADOX) library, which provides the ability to create database objects under programmatic control. This functionality is not available in ADO.NET, although you ...

Get Microsoft® ADO.NET 2.0 Step by Step, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.