How to access SQL Server database using DataReader in a visual basic.Net application
This simple program shows how to retrieve data from the FinAccounting database using DataReader and Data Commands. When the code in the program is executed, the data in the FinAccounting database is displayed in two textbox controls.

Steps you should know to use the DataReader object in a database application.
Preparation:
Design a form using .NET environment and place two TextBox controls on a form.
In this article we will use the FinAccounting database.
Tasks:
-Establish the connection with the Database using Connection object.
-Execute the command.
-The contents of the first record are displayed in the textboxes.
Program Code :
We use the SqlDataReader class to read data. The SqlDataReader class is defined in the System.Data.SqlClient namespace. So at the beginning of the program we need to use this class and we do so by adding the namespace. The Imports statement does this task.
Steps in the above program:
More on Retrieving data using a datareader - data-reader sqlserver example

Steps you should know to use the DataReader object in a database application.
Preparation:
Design a form using .NET environment and place two TextBox controls on a form.
In this article we will use the FinAccounting database.
Tasks:
-Establish the connection with the Database using Connection object.
-Execute the command.
-The contents of the first record are displayed in the textboxes.
Program Code :
We use the SqlDataReader class to read data. The SqlDataReader class is defined in the System.Data.SqlClient namespace. So at the beginning of the program we need to use this class and we do so by adding the namespace. The Imports statement does this task.
Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form 'Declare and setup the Connection string Dim str_connection As String = "Data Source=SYS1;Integrated Security=SSPI; Initial Catalog=FinAccounting" 'Declare and build a query string Dim str_sql_user_select As String = "SELECT * FROM Accounts" Dim mycon As SqlConnection Dim comUserSelect As SqlCommand 'Declaring the DataReader object Dim myreader As SqlDataReader Private Sub Form1_Load(ByVal sender As Object,ByVal e As System.EventArgs) Handles MyBase.Load 'Instantiate the connection object mycon = New SqlConnection(str_connection) 'Instantiate the command object comUserSelect = New SqlCommand(str_sql_user_select, mycon) TextBox1.Text = " " TextBox2.Text = " " 'Opening a Connection with the Open() method mycon.Open() 'Creating a DataReader object by using the ExecuteReader() method of the Command object. myreader = comUserSelect.ExecuteReader If (myreader.Read = True) Then TextBox1.Text = myreader(0) TextBox2.Text = myreader(1) Else MsgBox ("You have reached eof") End If End Sub End Class
Steps in the above program:
- Declare and setup the Connection string
- Declare and build a query string
- Declare the DataReader object
- Instantiate the Connection object
- Instantiate the Command object
- Open a Connection with the Open() method
- Create a DataReader object by using the ExecuteReader() method of the Command object
ExecuteReader method of the Command Object
ExecuteReader is used in the above program to execute a row-returning command, such as a SELECT statement. The rows are returned in a SqlDataReader. The DataReader class is a read-only, forward-only data class, which means that it should only be used for retrieving data to display it. We cannot update data in a DataReader.More on Retrieving data using a datareader - data-reader sqlserver example
Visual Basic.Net Articles
- Implementing Structure in visual basic.Net
- access database in visual basic.net
- user custom controls in C# visual basic 2005, asp.net, application
- Using assemblies in .net applications
- How to create and sign a shared assembly
- Data access using ado .net in Visual Basic .Net
- Middle tier component for accessing sql server using visual basic .net
- Databinding | binding data to a datagrid control
- Data binding | CurrencyManager and BindingContext
- Dataset in Visual basic .net
- Ado.net data access
- Creating, Using Namespaces in visual basic.Net
- Business, Presentation and Data layers
People also viewed:
Create your own ERP Software using ASP Core>>
Create your own Azure SOM Software>>
Create your own ERP Software using ASP .Net and SQL>>
Create your own Accounting Software using C# >>
Create your own SOM using Entity Framework MVC >>





Most Viewed
Azure Q & A
Azure Platform
Grid-View
GridView CommandField example
Details-View
GridView and DetailsView Master/Detail page using SqlDataSource control
POCO
POCO overview and advantages - POCO class, Entity Framework in Enterprise Applications
Entity Framework
Query entity data model using linq to entities
Array List
Difference between arraylist and list collection
Web Services
How to create a Web service using Visual Studio.net
Form-View
FormView DataBound Event
Object Oriented Programming
Calling base class constructor in C#
Linq
Convert a sequence to a generic list using ToList()method
Project Ideas
Project ideas for students
AccountingSoftware
Accounting Software
MVC
Creating an ASP.Net MVC 3 application
.Net
Using assemblies in .net applications
ASP .Net
How to implement form validation using ASP.Net 2.0 Validation Controls