how to view record in ms access using vb.net

try
Dim SqlQuery As String = "SELECT * FROM FullNameTable"
Dim SqlCommand As New OleDbCommand
Dim SqlAdpter As New OleDbDataAdapter
Dim TABLE As New DataTable

With SqlCommand
.CommandText = SqlQuery
.Connection = conn
End With

With SqlAdpter
.SelectCommand = SqlCommand
.Fill(TABLE)
End With

For i = 0 To TABLE.Rows.Count - 1
With ListView1
.Items.Add(TABLE.Rows(i)("ID"))
With .Items(.Items.Count - 1).SubItems
.Add(TABLE.Rows(i)("FirstName"))
.Add(TABLE.Rows(i)("MiddleName"))
.Add(TABLE.Rows(i)("LastName"))
End With
End With
Next
Catch ex As Exception
MsgBox(ex.Message)
End Try

Nice Share TS....

[You must be registered and logged in to see this image.]

can you post the search code ?

fredo2503 wrote:can you post the search code ?

this is also the code for searching record