How to show data from sql database to listview vb.net

it is ok if it is vulnerable at the moment.
I am just trying to make a program for personal use. btw i edited some code and still cant make it run.

 Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click


        mysqlconn = New MySqlConnection
        mysqlconn.ConnectionString = "server=localhost;user=root;password=root;database=database"
        Dim Reader As MySqlDataReader

        Dim strQ As String = String.Empty
        Dim conn As MySqlConnection
            Dim cmd As MySqlCommand
            Dim da As MySqlDataAdapter
            Dim ds As DataSet
            Dim itemcoll(100) As String
            strQ = "SELECT * FROM database.benta where customerID = '" & txtnos.Text "'"
            cmd = New SqlCommand(strQ, conn)
        da = New SqlDataAdapter(cmd)
        ds = New DataSet
        da.Fill(ds, "Table")
            Dim i As Integer = 0
            Dim j As Integer = 0
            ' adding the columns in ListView
            For i = 0 To ds.Tables(0).Columns.Count - 1
                Me.lva.Columns.Add(ds.Tables(0).Columns(i).ColumnName.ToString())
            Next
            'Now adding the Items in Listview
            For i = 0 To ds.Tables(0).Rows.Count - 1
                For j = 0 To ds.Tables(0).Columns.Count - 1
                    itemcoll(j) = ds.Tables(0).Rows(i)(j).ToString()
                Next
                Dim lvi As New ListViewItem(itemcoll)
                Me.lva.Items.Add(lvi)
            Next
End Sub

Imports System.Data.SqlClient
Public Class Form1
Dim conn As SqlConnection
Dim cmd As SqlCommand
Dim da As SqlDataAdapter
Dim ds As DataSet
Dim itemcoll(100) As String
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.ListView1.View = View.Details
Me.ListView1.GridLines = True
conn = New SqlConnection("Data Source=SQLEXPRESS;Initial Catalog=Northwind;Persist Security Info=True;User ID=id;Password=pass")
Dim strQ As String = String.Empty
strQ = "SELECT * FROM Northwind.dbo.Products"
cmd = New SqlCommand(strQ, conn)
da = New SqlDataAdapter(cmd)
ds = New DataSet
da.Fill(ds, "Table")
Dim i As Integer = 0
Dim j As Integer = 0
' adding the columns in ListView
For i = 0 To ds.Tables(0).Columns.Count - 1
Me.ListView1.Columns.Add(ds.Tables(0).Columns(i).ColumnName.ToString())
Next
'Now adding the Items in Listview
For i = 0 To ds.Tables(0).Rows.Count - 1
For j = 0 To ds.Tables(0).Columns.Count - 1
itemcoll(j) = ds.Tables(0).Rows(i)(j).ToString()
Next
Dim lvi As New ListViewItem(itemcoll)
Me.ListView1.Items.Add(lvi)
Next
End Sub
End Class

Look at these links:
http://www.fryan0911.com/2009/06/vbnet-listview-tutorial-add-edit-and.html[^]
http://www.codeguru.com/vb/controls/vbnet_controls/listview/article.php/c3979[^]
:thumbsup: