The Ado.web Product

ADO.Internet is the most current in a collection of systems from Microsoft which emphasis on the relationship of programs to databases of one kind or one more. From the DAO which (and is) was the native mode of relationship for MSAccess, via the small-lived RDO, and the now comparatively extensive-in-the-tooth ADO, this is the up coming generation of technology. And, though it is not probably that there will not be some potential include-ons, enhancements, and updates, it seems that this structure of databases connectivity is a keeper.

It is not a COM technology, so it can be used on other platforms in addition to Home windows, and agnostic when it comes to the model of databases it facilitates relationship to. In addition, it lets much more considerable help to the XML paradigm.

The .Internet system will carry on to make it possible for you to use the more mature ADO relationship technology, but, below most circumstances, this is a inadequate alternative for the reason that of the general performance penalty , which comes from utilizing the unmanaged code in the COM item.

ADO.Internet needs some new procedures of carrying out some of the easy duties of interacting with data. For instance, server-side cursors and are not supported any much more for the reason that of the enhanced overhead and the perhaps substantial amount of lacks expected on the server. Appropriately, the only relationship s authorized are forward only, read- read-only outcome sets, and disconnected outcome sets. There are rumors of server side cursors getting planned for potential releases, probably because of to the loud grievance from the developer neighborhood. Having said that, there are a amount of strategies and equipment furnished which greatly lessen the will need for server side cursors, so by the time of the up coming launch, there could be much less will need for them.

To achieve accessibility to the ADO.Internet class libraries, you will have to include the following statements to the leading of your resource documents:

Imports Program.Info

Imports Program.Info.OleDb* or, if you are connecting to SQLServer

Imports Program.Info.SqlClient

There is also help for the ODBC connections via Imports Program.Info.ODBC

These commands expose the objects wanted to connect to the data resource.

Info Retreival

Like ADO, ADO.Internet takes advantage of a relationship item to stage to exterior data. Underneath the .Internet product, a relationship is opened, data is retrieved, and then the relationship is closed. The closing of the relationship is essential to cost-free up means. The relationship string (the component of the remark which identifies the resource of the data, as nicely as accessibility to it via username and password) is similar to the relationship string grammar below the previous product ADO.

The initially way to accessibility data is following you have outlined and opened the relationship, invoke the command item offering it with a Pick assertion, or storedprocedure name with parameters. The Info Reader will make it possible for the software to achieve accessibility to the returned resultset. An ExecuteReader method will make it possible for a line by line reading through of the data retrieved. Having said that, be mindful that this is a forward only dataset – once a line is read, unless you save its contents someplace, someplace the data can be missing. The only way to make it available again is to re-create the relationship and read it again.

The 2nd method opens a relationship, retrieves a recordset, then merchants that recordset in an item called a DataSet. The DataSet acts and capabilities like a neighborhood databases, storing the data retrieved – even from numerous sources. It can even connection and create associations concerning numerous tables. At the summary of the data retrieval, the relationship is closed, so that in processing the DataSet is totally disconnected from the data resource(s).

The mapping of data concerning the DataSet and the outside the house data sources is dealt with by the DataAdapter item. In addition to retaining monitor of the connections to the data sources, the DataAdapter also facilitates the updating, deleting, and insertion of data again to the resource.

XML

XML is the native structure for ADO.Internet. It is so tightly integrated that you can define and read schemas, and can seamlessly trade data in the XLM structure, the two reading through and producing with any software on any system.

Source: http://www.paladn.com/posts/ado.dotnet.htm