this code runs at my other sample prog. but when I try to use it to my actual prog., it wont work. (variables changed, connection's ok) . . . cant show data at listview

Imports MySql.Data.MySqlClient

Public Class Form1
    Public sconnection As New MySqlConnection
    Private Sub Form1_Load()
        If sconnection.State = ConnectionState.Closed Then
            sconnection.ConnectionString = "server=localhost;User Id=root;database=t11"
        End If
    End Sub
    Public Sub loadfile()
        Dim squery As String = "select * from tbl_list"
        Dim sadapter As New MySqlDataAdapter
        Dim scommand As New MySqlCommand
        Dim sqltable As New DataTable
        Dim i As Integer

        With scommand
            .CommandText = squery
            .Connection = sconnection
        End With

        With sadapter
            .SelectCommand = scommand
        End With

        For i = 0 To stable.Rows.Count - 1
            With ListView1
                With .Items(.Items.Count - 1).SubItems
                End With
            End With
    End Sub
End Class

Is the listview view property set to Details?

If this property is not set to details, no columns can be shown.

Please see here for help

Hope this helps

sconnection.ConnectionString = "server=localhost;User Id=root;password = ;database=t11"

pointless cut and paste from original question - with no attempt to answer... sigh
This article has been dead for over six months. Start a new discussion instead.