Try this:
Dim conn As New SQLiteConnection("Data Source=myDatabase.sql3;Version=3;")
conn.Open()
dim SQL as string = "SELECT * from lang;"
Dim da As New SQLiteDataAdapter(Sql, conn)
Dim ds As New DataSet
da.Fill(ds, "lang")
conn.Close()
With ListView1
.View = View.Details
.HeaderStyle = ColumnHeaderStyle.Nonclickable
.Columns.Clear()
.Columns.Add(ds.Tables(0).Columns(0).ColumnName)
.Columns.Add(ds.Tables(0).Columns(1).ColumnName)
.Columns.Add(ds.Tables(0).Columns(2).ColumnName)
End With
For i As Integer = 0 To ds.Tables(0).Rows.Count - 1
ListView1.Items.Add(New ListViewItem({ds.Tables(0).Rows(i).Item(0).ToString(), ds.Tables(0).Rows(i).Item(1).ToString(), ds.Tables(0).Rows(i).Item(2).ToString()}))
Next
This shows the whole process.
* Open the database
* Create the DataAdaptor(da) using the connection and SQL statement
* Create the dataset (ds)
* Fill the DataAdaptor with the contents of the lang table
* Add Columns to the Listview
* Add the contents of fields to the ListView