Chapter 5: Storing and Retrieving Data with ADO.NET

Chapter 5

Storing and Retrieving Data with ADO.NET

About This Chapter

In this chapter, you ll learn how to use Microsoft ADO.NET to access and modify data stored in SQL and OLE databases from Web forms. You ll learn about the data tools included with Microsoft Visual Studio .NET and how to use them to create connections to, get records from, and perform commands on databases. You ll also learn how to display data on a Web form using either data binding or code. Finally, you ll learn how to use transactions to maintain the integrity of a database.

Before You Begin

To complete the lessons in this chapter, you must:

• Have Microsoft Data Engine (MSDE) or Microsoft SQL Server installed on your computer. The .NET Framework installs MSDE as part of the default setup.

• Install the Contacts SQL database (Contacts.mdf) from this book s companion CD onto your computer. This sample SQL database is used throughout the examples in this chapter. This database can be installed using the Setup program found on this book s companion CD.

• Be familiar with the basic elements of the Transact-SQL language. To find information about the SQL language, see the Transact-SQL Language Reference Help topic in Microsoft SQL Server Books Online.