Imports System.Data
Imports System.Data.SqlClient
Public Class frmattendence
Dim con As New SqlConnection("Data Source=Tarun-PC;Initial Catalog=couriermanagementsystem;Integrated Security=True")
Private da As SqlDataAdapter
Private dt As DataTable
Private ds As DataSet
Private cmdselect, cmddelete As String
Private Sub frmattendence_Load(sender As Object, e As EventArgs) Handles MyBase.Load
'Calling this method for execution whrn form loads
LoadRecord()
End Sub
'This method calls values from database put in datagridview
' Actually you have to Focus on this part only
Private Sub LoadRecord()
cmdselect = "select ID,Name,Gender,Position from tblcouriercompany"
da = New SqlDataAdapter(cmdselect, con)
dt = New DataTable()
da.Fill(dt)
DataGridView1.DataSource = dt
End Sub