mysql - WPF vb.net使用Mysql数据库填充Listview

Question

                Try
                    strQuery = "SELECT * FROM thesis_db.std_records WHERE ProfIDNo=" & lstProfID.SelectedItem & " AND SubjectNo=" & SubjNo & " order by Student_LName"
                    MysqlCmd = New MySqlCommand(strQuery, MysqlConn)
                    MysqlDR = MysqlCmd.ExecuteReader
                    Dim arr(3) As String
                    Dim itm As ListViewItem
                    While MysqlDR.Read
                        arr(0) = MysqlDR.Item("Student_LName").ToString
                        arr(1) = MysqlDR.Item("Student_FName").ToString
                        arr(2) = MysqlDR.Item("Student_MI").ToString
                        arr(3) = MysqlDR.Item("Score").ToString
                        itm = New ListViewItem(arr)
                        lstStudent.Items.Add(itm)
                    End While
                    MysqlDR.Close()
                Catch ex As Exception
                    MessageBox.Show(ex.Message)
                End Try

错误位于以下行:lstStudent.Items.Add(itm)。 itm 有下划线，其错误提示:“Public Sub New()”的参数太多。

Answer 1

尝试这样的事情:
改变:

itm = New ListViewItem(arr)
lstStudent.Items.Add(itm)

这样:

For i=0 to 3
 Dim lvi As New ListViewItem(arr.ToString())
 Me.lstStudent.Items.Add(lvi)
Next



 'if you want subItem
    lvi.SubItems.Add(array2(i))