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

This article mainly explains "what is the use of ADO.NET object". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the use of ADO.NET object".

The main objects I would like to mention in these ten days are:

A connection object that represents an open connection to a data source. A recordset object that represents the full set of records from the base table or the result of the command execution Parameter objects and command objects that are closely related to stored procedures will be discussed in more detail in later tutorials.

Let's start with the methods of the connection object:

1. Open method

Connection.open connectionstring, userid, password, options connectionstring optional, string, contains connection information.

Userid optional, string containing the user name used to establish the connection.

Password optional, string, ADO.NET object contains the password used to establish the connection.

Options optional, connectoptionenum value. Determines whether the method returns after the connection is established (asynchronously) or before the connection is established (synchronous). It can be one of the following constants:

Adconnectunspecified (default) opens the connection synchronously.

Adasyncconnect opens the connection asynchronously.

Execute method

Connection.execute commandtext, recordsaffected commandtext string that contains the text of the sql statement, table name, stored procedure, or specific provider to execute. The ADO.NET object is optional, with long integer variables to which the provider returns the number of records affected by the operation.

3. Close method

Connection.close

Use the close method to close the connection object to release all associated system resources.

It is important to note that:

(1) closing the object does not delete it from memory, the ADO.NET object can change its property settings and open it again later.

(2) to completely delete an object from memory, set the object variable to nothing.

(3) when you use the close method to close the connection object, any active recordset objects associated with the connection are also closed.

(4) after closing the connection object, calling any method that needs to open a connection to the data source will generate an error. We should all be familiar with the above three methods.

Let's talk about the properties of the connection object and briefly mention it.

1. Provider attribute

Use the provider property to specify the ole db provider.

It is important to note that specifying the provider in multiple places when calling the open method can have unintended consequences.

2. Connectionstring attribute

Contains information used to establish a connection to the data source.

3. Connectiontimeout attribute

The long integer value, in seconds, that indicates the time to wait during connection establishment before terminating the attempt and generating an error, and the time the ADO.NET object waits for the connection to open. The default value is 15.

4. Mode attribute

Indicates the available permissions to modify data in connection.

Thank you for your reading, the above is the content of "what is the use of ADO.NET object?" after the study of this article, I believe you have a deeper understanding of what the use of ADO.NET object is, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.