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

This article mainly explains "connection ADO. NET basic class related problem analysis," interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let Xiaobian take you to learn "Connection ADO. NET basic class related problem analysis" bar!

Connection-based objects: ADO. NET base classes have data providers such as Connection, Command, DataAdapter, and DataReader. They execute SQL statements, connect to databases, or populate DataSets. Connection-based objects are developed for specific data sources.

Content-based objects: These objects are packets. They contain DataSets, DataColumns, DataRows, DataRelationships, and several other objects. They are independent of the type of data source and are defined in the System.Data namespace.

In the rest of this chapter, you will learn about the *** levels of ADO. NET, which are connection-based objects, including Connection, Command, and DataReader. You don't need to know anything about higher-level DataAdapters at all, because DataAdapters are designed to work with DataSets, as discussed in Chapter 8 (essentially, DataAdapters are a set of related generic objects that synchronize DataSets with data sources). NET classes are grouped into several namespaces. Each provider has its own namespace, and generic classes such as DataSet are stored in the System.Data namespace, which is described in Table 7-1:

When you create a Connection object, you need to provide a Connection string. ADO. NET base class connection strings are semicolon-separated sequences of name/value settings. The order and case of these settings is not important. Taken together, these settings form the basic information for creating a connection.

Although the connection string is based on RDBMS (relational database management system) and the provider used, only some of the information is frequently used: ADO. NET base class database server: In the examples in this book, the database server and ASP.NET application are basically on the same computer, and the loopback alias localhost replaces the computer name.

If integrated security is not supported, the connection must specify a valid user and password combination. For newly installed SQL Server databases, the sa(System Administrator) account usually exists and is used in the following connection string:

String connectionString = "Data Source = localhost; Initial Catalog = Northwind;" + "user id = sa; password = opensesame";

If you are using an OLE DB provider and the connection string is similar, the ADO. NET base class simply requires additional provider settings to identify the OLE DB driver. For example, you can use the following connection string to connect to an Oracle database through the MSDAORA OLE DB provider.

At this point, I believe that we have a deeper understanding of the "connection ADO. NET basic class related problem analysis," may wish to actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

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.