Public Function GetEmployeeCount() As Integer Dim count As Integer = 0 Dim connectionString As String = "Server=localhost;Database=YourDatabase;Integrated Security=True;" Using connection As New SqlConnection(connectionString) Dim query As String = "SELECT COUNT(*) FROM Employees" Dim command As New SqlCommand(query, connection) Try connection.Open() count = Convert.ToInt32(command.ExecuteScalar()) Catch ex As SqlException MessageBox.Show("Error: " & ex.Message) End Try End Using
Return dataTable End Function
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;" vb.net code to retrieve data from sql server
Using connection As New SqlConnection(connectionString) Dim query As String = "SELECT EmployeeID, FirstName, LastName, Department, Salary FROM Employees" Dim adapter As New SqlDataAdapter(query, connection) Try adapter.Fill(dataTable) Catch ex As SqlException MessageBox.Show("Error: " & ex.Message) End Try End Using Public Function GetEmployeeCount() As Integer Dim count As