更新ListViewItem

Question

在我插入另一个项目后，我找不到关于如何更新ListView的正确答案。

当我在Button1中添加ListView1.Clear()和DatabaseSelect()时，没有什么可查看的。

如何在每次插入新项目时刷新ListView？

下面是填写ListView的代码：

Function DatabaseSelect()
    Try

        myDA.SelectCommand = conn.CreateCommand()
        myDA.SelectCommand.CommandText = ("SELECT * FROM FullName")
        myDA.SelectCommand.CommandType = CommandType.Text
        myDA.Fill(myDS)

        For Each myDR As DataRow In myDS.Tables(0).Rows
            Dim myListview As New ListViewItem()
            myListview.SubItems.Add(myDR(0))
            myListview.SubItems.Add(myDR(1))
            myListview.SubItems.Add(myDR(2))
            myListview.SubItems.Add(myDR(3))
            ListView1.Items.Add(myListview)
        Next
        conn.Open()
        myDA.SelectCommand.ExecuteNonQuery()
        conn.Close()

    Catch ex As Exception
        MessageBox.Show(ex.Message)
    End Try

End Function

以下是将项目插入到ListView的代码：

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Try
        myDA.InsertCommand = conn.CreateCommand()
        myDA.InsertCommand.CommandText = ("INSERT INTO FullName (FirstName,MiddleName,LastName) VALUES(@firstname,@middlename,@lastname)")
        myDA.InsertCommand.CommandType = CommandType.Text
        myDA.InsertCommand.Parameters.Add("@firstname", SqlDbType.NVarChar, 50, "FirstName").Value = TextBox1.Text
        myDA.InsertCommand.Parameters.Add("@middlename", SqlDbType.NVarChar, 50, "MiddleName").Value = TextBox2.Text
        myDA.InsertCommand.Parameters.Add("@lastname", SqlDbType.NVarChar, 50, "LastName").Value = TextBox3.Text
        conn.Open()
        myDA.InsertCommand.ExecuteNonQuery()
        conn.Close()

    Catch ex As Exception
        MessageBox.Show(ex.Message)
    End Try
End Sub

Answer 1

我认为您必须在Button Click事件中调用函数DatabaseSelect()。

在conn.Close()之后添加DatabaseSelect()

也许这会对你有所帮助。