Reading data with a SQL Data Reader: sqlDataReader sqlConnection sqlCommand in Visual Basic .Net

This code sample shows you how to use the SQL Data reader to read a list of products from the products table in the Northwind database. The steps you need to remember for any data connection are:

1. Create a connection object
a. Set the connection string for the connection.
b. Open the connection object

2. Create a command object
a. Assign the command to the connection
b. Supply the command text for the SQL command to execute

3. Declare a Data Reader and execute the command object into it.
a. Use the read method of the data reader to read each row of data
b. Read the data from the current row

4. Close the connection

The following code uses a label called Label1 as the output. You can process the data however you want.

Dim ConString as String = _
"Server=LocalHost;Database=Northwind;Integrated Security=True"
Dim Con As New SqlClient.SqlConnection(ConString)
aCon.Open()
Dim aCmd As New SqlClient.SqlCommand("SELECT * FROM Products", aCon)
Dim DR As SqlClient.SqlDataReader = aCmd.ExecuteReader
While DR.Read()
Label1.Text &= DR("ProductName") & "<br>"
End While
aCon.close()

Study and Research resources:

Microsoft Certification Info:

See the list of .Net articles

TOGGIT IN SEARCH OF CERTIFICATION

All information on this site is copyright ToggIT.com unless otherwise specified. Material submitted or posted this site may also contain materials that are copyrights of individual contributors. It is illegal to copy, publish, reproduce, or distribute any materials from this site with the express permission of the owner of this material.

The material on this web site is not sponsored by, endorsed by or affiliated with Microsoft, Inc, CompTIA, or Cisco Systems, Inc. Microsoft, Inc.® ,Windows XP, Windows 2000, Windows 2000 Server, Windows 98, Windows NT, Visual Basic, Visual C++, Visual FoxPro, SQL server and Microsoft logos are trademarks or registered trademarks of Microsoft, Inc. in the United States and certain other countries. A+, Server+, and Network+ are all registered trademarks of CompTIA. CCNA, CCNE, and the Cisco logo are all registered trademarks of Cisco Systems. All other trademarks are trademarks of their respective owners.