How to I display sqlite table in listview in VB.NET

Question

0.00/5 (No votes)

See more:

hello. I am working on a project using SQlite for the first time. I have been able to load all tables to display in a combobox. Now i need to be able to display the details of any table you selected from the combobox to be displayed in a Listview.
I'll indeed be very grateful thank u.

What I have tried:

Dim conn As New SQLite.SQLiteConnection
Dim cmd As SQLiteCommand
Dim da As SQLite.SQLiteDataAdapter
Dim ds As SQLiteDataReader
Dim itemcoll(100) As String

Me.ListView1.View = View.Details
Me.ListView1.GridLines = True
conn = New SQLiteConnection(db)
Dim strQ As String = String.Empty
strQ = "SELECT * FROM " & ComboBox1.Text & """"
cmd = New SQLiteCommand(strQ, conn)
da = New SQLite.SQLiteDataAdapter(cmd)

Posted 27-Mar-16 16:08pm

SamuelDexter

Updated 9-Mar-21 7:29am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

John Dovey · Answer 1 · 2021-03-09T07:29:00

Try this:

VB

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")
        'Close the connection
        conn.Close()
        'ListView1
        With ListView1
            .View = View.Details
            .HeaderStyle = ColumnHeaderStyle.Nonclickable ' set to whatever you need
            .Columns.Clear() ' make sure columnscollection is empty
            ' Add 3 columns
            .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

Richard MacCutchan · Answer 2 · 2016-03-27T22:53:00

Solution 1

See SQLiteDataAdapter Class[^].

Posted 27-Mar-16 22:53pm

Richard MacCutchan