Page 89 - DCAP312_WEB_TECHNOLOGIES_II

Sarabjit Kumar, Lovely Professional University Unit 5: Database Access

Unit 5: Database Access Notes

CONTENTS

Objectives
Introduction
5.1 Database Access Using ADO.NET
5.1.1 ADO.NET
5.1.2 The ADO.NET Object Model
5.1.3 Display Data in a DataGrid
5.1.4 DataBindings for Textboxes
5.2 Database Connection
5.3 Database Command
5.3.1 How to Use Parameters
5.4 DataAdapter
5.4.1 Choosing between the DataAdapter and the DataReader
5.4.2 Getting the Best Performance from the DataAdapter

5.4.3 The Role of the CommandBuilder
5.4.4 Fetching Data with the DataAdapter
5.4.5 The Single-Table Fetch Approach
5.4.6 The Multiple Resultset Approach
5.4.7 The JOIN Product Approach
5.4.8 The Composite Query Approach
5.5 ADO.NET DataSet
5.6 ADO.NET DataReader
5.7 Connection Pooling
5.7.1 Connection Pooling in ADO.NET
5.7.2 Testing Connection Pooling Behavior
5.8 Summary

5.9 Keywords
5.10 Review Questions
5.11 Further Readings

Objectives

After studying this unit, you will be able to:
• Define the database access using ADO.NET

• Explain the connection in ADO .NET
• Describe the command in ADO .NET
• Explain the ADO .NET DataAdapter

LOVELY PROFESSIONAL UNIVERSITY 83