tailieunhanh - Chapter 3: Windows Database Applications

• Microsoft’s latest database object model • Allows VB programmers to use a standard set of objects to refer to data from any source • .NET approach uses disconnected datasets with common data representation (data types) from multiple sources Visual | Chapter 3 Windows Database Applications Advanced Programming Using Visual Universal Data Access iqL j UDA Ẹ Microsoft s strategy for accessing data for multiple providers Goal is to access any type of data from any application on any type of computer Visual Basic and Database Applications 3-2 Giáo Viên Nguyễn Văn Thắng. 1 OLEDB Technology designed to implement the UDA concept Standardized interface that allows reference to data from any source using the same programming tools Visual Basic and Database Applications 3-3 Giáo Viên Nguyễn Văn Thắng. ActiveX Data Objects à ADO Microsoft s latest database object model Allows VB programmers to use a standard set of objects to refer to data from any source .NET approach uses disconnected datasets with common data representation data types from multiple sources Visual Basic and Database Applications 3-4 Giáo Viên Nguyễn Văn Thắng. 2 XML is an industry standard format for storing and transferring data over multiple platforms. .NET framework is integrated with XML Extensible Markup Language Multitier applications that use disconnected datasets provide for - Flexibility à adapt to changes in data or presentation tier - Scalability à handle increases in the number of users and servers Visual Basic and Database Applications 3- 5 Giáo Viên Nguyễn Văn Thắng. Components Data Providers - manipulate the data using SQL statements or stored procedures - SQLClient à for SQL Server - OleDbClient à for all other database formats - An ODBC provider is available for download Visual Basic and Database Applications 3-6 Giáo Viên Nguyễn Văn Thắng.