Shulou(Shulou.com)06/02 Report--

This article mainly introduces the principle of VB.NET how to access the database, the article is very detailed, has a certain reference value, interested friends must read it!

VB.NET access database interface function and meaning:

ADC: advanced data Connector (AdvancedDataConnector): provides binding of ADO data sources to the form's data-bound controls. ADC is mainly a technology to access remote OLEDB objects directly or through ADO. It also supports data-bound controls that are mainly used in Microsoft IE browsers. It is specially designed for browser-based applications on Web.

ADO:Active data objects (ActiveDataObjects): ADO is actually a connection mechanism that provides access to various data types. ADO is designed as a very simple format and interfaces with the database through the ODBC method. You can use any kind of ODBC data source, not only for database applications such as SQLServer, Oracle, Access, but also for Excel tables, text files, graphics files, and unformatted data files. ADO is a technology based on OLE-DB, so ADO provides unified data access interface methods through its internal properties and methods.

DAO: data access object (DataAccessObjects): is an object-oriented interface. The ISAM database can be accessed through the DAO/Jet function, and the remote RDO function can be realized using the DAO/ODBCDirect function. Coding using DAO is very simple. DAO provides rich result sets of Cursor type and non-Cursor-Less type, similar to the function of DDL (data description language).

DAO model is a collection of object classes that design the structure of a relational database system. They provide properties and methods to complete all the operations needed to manage such a system, including tools such as creating databases, defining tables, fields and indexes, establishing relationships between tables, locating and querying databases, and so on.

JET: data Connectivity engine Technology (JointEngineTechnology): a database access mechanism based on workstations through DAO. Although you can access the Jet database through the ODBC drivers provided by Microsoft Access, there are functional limitations in using these drivers. Jet mechanism has its own query and result set processing functions, and can query the same or heterogeneous data sources. Here is a simple introduction about VB.NET access to the database, friends who like to study can collect materials on the Internet.

Principles for VB to access database

Specific analysis should be made according to the actual problems, and appropriate programs should be adopted according to the specific environment, conditions and requirements.

1. Reuse of code and efficiency of running

For example, by connecting to a database using an ODBC data source, you can transform multiple database types without frequently modifying the code. You can't do this through DB-Library with VBSQL. However, the ODBC interface is not a method for VB to access database efficiency. Similarly, ADO, which also uses ODBC interface, is more efficient than RDO

two。 Easy to implement and easy to maintain

If a method is very complex to implement, the development of the project will inevitably lead to a waste of manpower and material resources, and the application designed in this way will only be more complex to support or more difficult to maintain. For example, if you need to access an ISAM or Jet type data source locally, use DAO/Jet instead of using a method through ODBC. RDC is easier to implement than RDO

3. Safety principle

This article shall be decided on the basis of circumstances and conditions. For example, the network security of the local area network is better than that of the wide area network, so we can directly use data controls such as DC, which is convenient and fast to implement, while the wide area network needs a lot of error trapping, such as using RDC is not as easy to control errors as using RDO.

The above is all the contents of the article "how to access the database by VB.NET". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.