Vb.net Code To Retrieve Data From Sql Server May 2026

Public Shared Function GetAllEmployees() As List(Of Employee) Dim employees As New List(Of Employee)() Using conn As New SqlConnection(connectionString) Dim sql As String = "SELECT EmployeeID, FirstName, LastName, Department, Salary FROM Employees ORDER BY LastName" Using cmd As New SqlCommand(sql, conn) conn.Open() Using reader As SqlDataReader = cmd.ExecuteReader() While reader.Read() employees.Add(New Employee() With .EmployeeID = reader.GetInt32(0), .FirstName = reader.GetString(1), .LastName = reader.GetString(2), .Department = reader.GetString(3), .Salary = reader.GetDecimal(4) ) End While End Using End Using End Using Return employees End Function End Class

Return dataTable End Function

Imports System.Data.SqlClient Public Function GetEmployeesWithReader() As List(Of Employee) Dim employees As New List(Of Employee)() Dim connectionString As String = "Server=localhost;Database=YourDatabase;Integrated Security=True;" vb.net code to retrieve data from sql server

Imports System.Data.SqlClient Public Async Function GetEmployeesAsync() As Task(Of List(Of Employee)) Dim employees As New List(Of Employee)() Dim connectionString As String = "Server=localhost;Database=YourDatabase;Integrated Security=True;"

Private Async Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click ' Show loading indicator Button1.Enabled = False Label1.Text = "Loading data..." Dim employees As List(Of Employee) = Await GetEmployeesAsync() .FirstName = reader.GetString(1)

Return employees End Function This approach loads all data into memory and works well for data binding.

DataGridView1.DataSource = employees Label1.Text = $"Loaded employees.Count records" Button1.Enabled = True End Sub Here's a complete working example with a helper class: .LastName = reader.GetString(2)

Imports System.Configuration Dim connectionString As String = ConfigurationManager.ConnectionStrings("DefaultConnection").ConnectionString You now have multiple reliable methods to retrieve data from SQL Server using VB.NET. Choose the approach based on your specific needs: SqlDataReader for performance, DataAdapter for flexibility, and async methods for responsive UI applications.