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.
Design a form using .NET environment and place two TextBox controls on a form.
In this article we will use the FinAccounting database.
-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:
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;
'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)
'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
'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)
MsgBox ("You have reached eof")
- 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
Develop Azure Applications
Azure Cloud is gaining popularity and is competing with Amazon Elastic Cloud and Google Cloud for a spot in the billion dollar Cloud computing space.
With this book learn how to use - Table (an Azure Table is different from a SQL Server Table), Queue, Blob storage services, use your local machine to create an Application and a Service, how Azure splits a Table to achieve Load Balancing, Scalability based on the Partition Key, AppFabric Service Bus, Access Control Service, role of Fabric Controller, features of Azure SQL Database and Content Delivery Network.
Many have mastered Cloud Programming and are enjoying the benefits. Why not you?
Create your Own Accounting Software
A foundation book to Master Accounting Software Development, VB.Net, C# and OOPs programming. Detailed explanation of the Accounting domain for programmers is included. SQL and ADO.Net is also covered in detail.
This book gives you a strong foundation in Application Development.
A thorough understanding of the contents will enable you to grasp the topics covered in the accompanying books quite easily. This is because, the accounting domain is dealt with great detail in this book.
The ideal book to get started with application development in the .Net world.
Create your Own WEB ERP Software using ASP.Net
This book opens you to the Web. Using ASP.Net, C# and SQL Server as the tools, you will learn to build a Multi Tier Web Application as recommended by Microsoft. You will learn implementing inline GridView control, Transaction Management for a layered Web Application, build Data Access component and a Business Layer component.
Opens you to a world of opportunities. You will be able to develop a Web ERP application including all the five modules and learn how to use the TreeView control and GridView control to implement transactions such as Purchase Invoice, Sales Order and Sales Invoice.
ASP.Net MVC 5 Application Development Using Entity Framework 6 and VS 2015
Entity frameworks is the latest buzz in .Net programming and is the data access technology for Microsoft OS based hand held devices and web applications. Learn to integrate EF into an ASP.Net Application and MVC application. Create, explore and query the Entity Data Model. Learn how to use ObjectDataSource control and GridView control in an ASP.Net Application.
Also, learn to build Three-Tier ASP.Net application, create a business-class, implement methods in the class to perform CRUD operations and bind a GridView to the ObjectDataSource control. Learn how to handle concurrency and managing Transactions.