Vb.net Code To Retrieve Data From Sql Server -

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;"

Return count End Function Always use parameters when filtering data. 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;" Imports System

Return dataTable End Function For Windows Forms or WPF applications, use async methods to keep the UI responsive. Return dataTable End Function

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

Private Sub LoadDataToGrid() Dim dt As DataTable = GetEmployeesAsDataTable() DataGridView1.DataSource = dt End Sub Use ExecuteScalar when you expect a single value (e.g., COUNT, SUM, or a specific field).

Return dataTable End Function