SqlDataReader Example – VB.NET – SqlDataReader Example
| .NET | .NET Programming (C# or VB) (Web or Desktop) | |||
| Key Supporting Languages | HTML | CSS | JavaScript | SQL Server |
| Access | AJAX | ASP | Blogging | ColdFusion |
| Expression Blend | mySQL | Perl | PHP | Ruby |
| SEO | SharePoint | Silverlight | Web Design | Web Dev |
SqlDataReader Example – VB.NET – SqlDataReader Example
Purpose: – Illustrates using SqlDataReader to read sql table.
Prerequistes:
- Install Visual Basic (Express or Standard Edition)
- Install SQL Server Express
- Download Northwind Database
- Attach Northwind Database to Databases in Sql Express
Notes:
- Console Application is used to simplify things, but Windows Forms or Web Forms could also be used
- You can build a library of syntax examples by using same project over and over and just commenting out what you do not want to execute in Module1.vb
Instructions:
- Use VB 2008 (Express or Standard) Edition
- Create new project; select Console Application; name of Project could be VBNET_Syntax.
- Right-click project name in solution explorer; add new folder; name of folder could be DatabaseADONET
- Right-click folder; add class; class name could be clsSqlDataReader.vb
- Copy code into clsSqlDataReader.vb
- Copy code into Module1.vb
- Click green arrow to start with debugging
Step 1: Use View Plain to Cut-n-paste code into clsSqlDataReader.vb
Imports System
Imports System.Data
Imports System.Data.SqlClient
Public Class clsSqlDataReader
Shared WithEvents con As SqlConnection
Public Sub Main()
con = New SqlConnection("Server=(local)\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI")
Dim cmd As New SqlCommand()
cmd.CommandText = "SELECT FirstName, LastName FROM Employees"
cmd.Connection = con
Try
con.Open()
Dim reader As SqlDataReader = cmd.ExecuteReader '(CommandBehavior.SingleRow)
While reader.Read()
Console.WriteLine("{0} - {1}", _
reader.GetString(0), reader.GetString(1))
End While
reader.Close()
Finally
con.Close()
End Try
Console.ReadLine()
End Sub
End Class
Step 2: Use View Plain to Cut-n-paste code into Module1.vb
Module Module1
Sub Main()
'***** DataBaseADONET *************
Dim mySqlDataReader As New clsSqlDataReader
mySqlDataReader.Main()
End Sub
End Module
Related posts:
- SqlDataReader Example – C# – SqlDataReader Example C# Source code example shows how to use SqlDataReader to...
- VB.NET DataTable SqlDataReader Example – SqlDataReader DataTable Example VB.NET VB.NET DataTable SqlDataReader Example - SqlDataReader DataTable Example VB.NET...
- VB.NET: Sql Stored Procedure Source Code Example VB.NET Sql Stored Procedure Source Code Example...
- C# DataTable SqlDataReader Example – SqlDataReader Datatable Example C# C# DataTable SqlDataReader Example - SqlDataReader Datatable Example C#...
- VB.NET: SqlConnection Connection String SqlConnection Connection String VB.NET Source code example....
Related posts brought to you by Yet Another Related Posts Plugin.
