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

Editor to share with you what you need to pay attention to when using ADO.NET, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

When using ADO.NET, there is a serious problem. ADO.NET unifies the data container class programming interface. Therefore, no matter what type of program it is: Windows Form, Web Form, or Web Service, you have to centralize the data in the same set of classes.

Insert into target MDB table name (field list) in'C:\ db2.mdb' select field list from current MDB table name or insert into [; database=C:\ db2.mdb]. Table name of the target MDB (field list) select field list from current MDB table name

If you access MDB on another machine, you can use linked tables, pass queries, or directly use SQL:

(1) when using linked tables, it is recommended to use file data sources to create linked tables, which have nothing to do with the machine, and can be copied to other machines for direct use. Using ADO.NET, there is no need to create ODBC manually or with code.

Comparison of different data sources:

File DSN

The ODBC file data source allows users to connect to the data provider. The file DSN can be shared by users who have the same driver installed.

User DSN

The ODBC user data source stores information about how to connect to the specified data provider. Using the ADO.NET user data source is visible only to the current user and can only be used on the current machine.

System DSN

The ODBC system data source village is in addition to information on how to connect with the specified data provider. The system data source is visible to all users on the current machine, including NT services.

(2) to pass the query, using ADO.NET needs to save the connection string to the pass-through query, but it is more efficient than the linked table.

(3) use Jet-SQL statement to access:

Can be accessed directly with the machine name, such as: SELECT * FROM [; DATABASE=\\ Server\ shared document\ Test.MDB]. Table name

You can also map the shared directory on another machine to the cost local disk first, using ADO.NET is the same as accessing the local MDB. Suppose another machine IP is 192.168.0.1, the machine name is Server, and the shared folder name is "shared directory". After you create a disk that maps to a local disk (such as Z).

The above is all the contents of the article "what do you need to pay attention to when using ADO.NET"? thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more 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.