Page 111 - DCAP312_WEB_TECHNOLOGIES_II

Unit 5: Database Access

True or False Notes
13. A DataSet is the equivalent for client side cursor, which holds a portion of the database
after execution of a query.
(a) True (b) False

14. The ADO.NET classes are found in System.Data.dll and integrated with XML classes in
System.Xml.dll.
(a) True (b) False

15. In ADO.NET, database connection pooling is enabled by default.
(a) True (b) False

5.8 Summary

• The software support provided by a database vendor to access its own product is known
as a ‘Native driver’.
• A database is a collection of information that is organized so that it can easily be accessed,
managed, and updated.
• A distributed database is one that can be dispersed or replicated among different points
in a network.
• An object-oriented programming database is one that is congruent with the data defined
in object classes and subclasses.
• The ADO.NET provides data access services in the Microsoft .NET Platform.
• The ADO.NET classes are found in System.Data.dll and integrated with XML classes in
System.Xml.dll.
• DataSet is a copy of a extracted data being downloaded and cached in the client system.

• The Windows Forms DataGrid control displays data in a series of rows and columns. The
Windows Forms DataGrid control provides a user interface to ADO.NET datasets.

• A DataSet can be saved to an XML file and then loaded back into memory very easily.
5.9 Keywords

ADO.NET: The ADO.NET is the new database technology of the .NET (DotNet) platform, and
it builds on ADO (ActiveX Data Objects).
DataAdapter: A DataAdapter acts as a bridge between a data source and a data class which is
disconnected from the data source.

Database Connection Pool: A database connection pool is a set of database connections that are
held open with the database and are kept ready to serve.

DataBinding: It is the ability to bind some elements of a data source with some graphical
elements of an application.

DataSet: A DataSet is the equivalent for client side cursor, which holds a portion of the database
after execution of a query.
1. Write a program to connect a database with the frontend.

2. Write a program to select and display the records from the table.

LOVELY PROFESSIONAL UNIVERSITY 105