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 17:26:21

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:
Mission 2 MarsBomb Jack 2GauntletYahtzeeMahjongg Artifact 2

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


Related Images

Article Category Videos to Watch
Go to the Videos Pages

The ADO.Net Command Object

In a connected mode environment, after a connection is established with the data, the data is manipulated and returned using the command object. The command object is passed a SQL query SELECT statement, which is run by one of the Execute methods. The three Execute methods are ExecuteNonQuery (for updates or deletes or appends), Execute Reader (for returning datasets to the client), and Execute Scalar (returns a single value).

The command objects themselves are either of SqlCommand, OleDbCommand, or ODBCCommand types. And the principal properties are the command text (the sql statement and the connection object previously created.) Other properties are the Command Type, Transaction, Command Timeout, Parameters, and UpdatedRowSource.
Dim cmd as New SqlCommand
cmd.CommandText=”SELECT * FROM tblBooks;”
Dim dr as SqlDataReader = cmd.ExecuteReader()
The preceding code will execute a SQL command and put the results into a DataReader after having made and opened a connection. Had the SQL statement been an INSERT statement, the appropriate method would have been ExecuteNonQuery(), rather than ExecuteReader(). There is an additional Execute XMLReader() method which is new in SQL2000, and is used for processing SELECT queries from an XML dataset. ExecuteScalar() is another method used for returning a single value from a dataset.
In the OleDb model, you can define parameters in the CommandText using question marks.
SELECT * from tblBooklist where YearPublished = ?;
Then you need to create and define the parameter prior to passing them into the command object.
Dim Parm as New OleDBParameter(“YearPublished”, OleDbType.Integer)
You can even have ADO.Net populate the list of parameters for you using the DeriveParameters method.
Dim cmd as New SqlCommand(“up_getshotgun”, conn)
Debug.writeline(cmd.parameters.count & “parameters”)
For i = 0 to cmd.parameters.count-1
Stored Procedures
Stored Procedures are handled using the parameters in the previous section and setting them with the Parameters.Add method. The only difference from the previous code is the calling of the stored procedure itself. This is accomplished using the CommandType property, rather than the CommandText property.
Dim cmd as New SqlCommand(“up_getshotgun”, conn)
Dim dr as SqlDataReader=cmd.ExecuteReader()
• PPT Presentation on .ADO Net
This PPT presentation provides you with the overview of .ADO Net.
• Information on ADO Net resources
This resource provides comprehensive information on .ADO Net resources.

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.