Vectors and 3D Models
Local Search - Computers
Weather Information
Get the App for Smartphones and Tablets

Go Back

WhmSoft Free Articles Directory
Free Articles for Reprint
Free Articles to Publish
Free Articles for Newsletters
Videos to Watch

Page Generation Date and Time:
08/11/2022 16:53:24

Free the Animation VR / AR
Play to reveal 3D images and 3D models!
Demonstration A-Frame / Multiplayer
Android app on Google Play
vlrPhone / vlrFilter / vlrMemos
Project of very low consumption, radiation and bitrate softphones / Multifunction Audio Filter with Remote Control / App to measure the quality of the voice!

Alexa Data

Go To Articles Directory Home Page

To get the current article, - See Below (at the bottom of the page) -.
For top news titles, see below.
Web sites and videos listed in this page are frequently updated.
If you find that this page is useful (quality of web sites, images and videos, ...), you can add it to your favorites.
Bookmark Page !

Tell a Friend:

With your mobile phone (WAP / I-Mode / iPhone / PDA), for free:
The Top News -
The Daily Files -
All the Directory Files -

Web version of feeds:
Podcast Music -
Daily Files -

You can play the Guitar Drum Revolution game (flash game) by following the link below:
Play Guitar Drum Revolution Game

You can play free online games (flash games) by following the link below:
Free Online Games

Play the samples below:
01249 Classroom Pitfall01723 Spookiz1159 BaseballTribal GamePyramid Runner

You can view the people (celebrities) news and the front page news (with videos, images and constant updates) by following the link below:
View Recent News
or by visiting the WhmSoft Service blog:
News Photos Slideshows

Article Keyword Videos to Watch
Click on the image to start the video.

Related Topics
Images - Links - Articles

Los Angeles

Related Images

Article Category Videos to Watch
Go to the Videos Pages

The ADO.Net Model

ADO.Net is the latest in a series of technologies from Microsoft which focus on the connection of applications to databases of one sort or another. From the DAO which (and is) was the native mode of connection for MSAccess, through the short-lived RDO, and the now comparatively long-in-the-tooth ADO, this is the next generation of technology. And, although it is not likely that there will not be some future add-ons, enhancements, and upgrades, it appears that this structure of database connectivity is a keeper.
It is not a COM technology, so it can be used on other platforms in addition to Windows, and agnostic when it comes to the brand of database it facilitates connection to. In addition, it allows more extensive support to the XML paradigm.
The .Net platform will continue to allow you to use the older ADO connection technology, but technology. However, under most circumstances, this is a poor choice because of the performance penalty, which comes from using the unmanaged code in the COM object.
ADO.Net requires some new methods of accomplishing some of the simple tasks of interacting with data. For example, server-side cursors and are not supported any more because of the increased overhead and the potentially large number of lacks required on the server. Accordingly, the only connection s allowed are forward only, read- read-only result sets, and disconnected result sets. There are rumors of server side cursors being planned for future releases, probably due to the loud complaint from the developer community. However, there are a number of techniques and tools provided which greatly lessen the need for server side cursors, so by the time of the next release, there may be less need for them.

To gain access to the ADO.Net class libraries, you must add the following statements to the top of your source files:
Imports System.Data
Imports System.Data.OleDb* or, if you are connecting to SQLServer
Imports System.Data.SqlClient
There is also support for the ODBC connections through Imports System.Data.ODBC
These commands expose the objects needed to connect to the data source.
Data Retrieval
Like ADO, ADO.Net uses a connection object to point to external data. Under the .Net model, a connection is opened, data is retrieved, and then the connection is closed. The closing of the connection is necessary to free up resources. The connection string (the part of the comment which identifies the source of the data, as well as access to it through username and password) is identical to the connection string grammar under the old model ADO.
The first way to access data is after you have defined and opened the connection; invoke the command object providing it with a SELECT statement, or stored procedure name with parameters. The Data Reader will allow the application to gain access to the returned result set. An Execute Reader method will allow a line by line reading of the data retrieved. However, be aware that this is a forward only dataset – once a line is read, unless you save its contents somewhere, somewhere the data can be lost. The only way to make it available again is to re-establish the connection and read it again.
The second method opens a connection, retrieves a record set, and then stores that record set in an object called a Dataset. The Dataset acts and functions like a local database, storing the data retrieved – even from multiple sources. It can even link and establish relationships between multiple tables. At the conclusion of the data retrieval, the connection is closed, so that in processing the Dataset is completely disconnected from the data source(s).
The mapping of data between the Dataset and the outside data sources is handled by the Data Adapter object. In addition to keeping track of the connections to the data sources, the Data Adapter also facilitates the updating, deleting, and insertion of data back to the source.
XML is the native format for ADO.Net. It is so tightly integrated that you can define and read schemas, and can seamlessly exchange data in the XLM format, both reading and writing with any application on any platform.
• Information on ADO.Net Professional Training
This resource provides an insight to Microsoft’s ADO.Net Professional Training.
• Information on course of .Net programming for wireless device.
This resource discusses a course of
.Net programming for wireless device

About the Author: Chris Kemp is a well knoen author who writes best quality articles on IT, Software, Programming, etc. For further details please visit the site

Recommended Web Site(s):

Easy Articles Home Page - Articles Directory

Recommended WhmSoft Web Sites, Feeds and WAP Address:

WhmSoft Software Home Page - Software
WhmSoft Services Login Page - Music and Images
WhmSoft Moblog Home Page - Blog - Photo Gallery
WhmSoft Free Online Games Home Page - Flash Games
WhmSoft Services RSS Feed - Daily Music, Image and 3D Flash Animation
Classical Music with Drum RSS Feed - MIDI and MP3 Files
Classical Music with Drum Podcast Feed - MP3 and MP3 Files
WAP / I-Mode / PDAs - Daily Music, Image and Flash Animation

Home Pages:

WhmSoft Free Articles for Reprint Home Page
WhmSoft Services Home Page - Music and Images
Copyright (C) 2006-2022 WhmSoft - All Rights Reserved.