Code:
Private Sub btnADD_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnADD.Click
Dim sqlquery As String = "INSERT INTO tbl_history (huser, hin, hout, hdate) VALUES ('" & t1.Text & "','" & Label1.Text & "','" & " t2.Text " & "','" & Label2.Text & "')"
Dim sqlcommand As New OleDbCommand
With sqlcommand
.CommandText = sqlquery
.Connection = conn
.ExecuteNonQuery()
End With
MsgBox("Successfully Added.")
loadlistview()
End Sub
I can add new data to MS Access
it will also show in my Listview however it is located at the bottom part.
I wish that the new data/record will show on top/first row
Comment