在listview的vb.net中搜索数据库按钮

Private Sub SearchButton_Click(sender As Object, e As EventArgs) Handles SearchButton.Click
    ' 清空ListView
    ListView1.Items.Clear()

    ' 建立数据库连接
    Dim connString As String = "YourConnectionString"
    Dim conn As New SqlConnection(connString)
    conn.Open()

    ' 构建SQL查询语句
    Dim searchQuery As String = "SELECT * FROM YourTable WHERE YourColumn LIKE '%' + @searchTerm + '%'"
    Dim cmd As New SqlCommand(searchQuery, conn)
    cmd.Parameters.AddWithValue("@searchTerm", SearchTextBox.Text)

    ' 执行查询并读取结果
    Dim reader As SqlDataReader = cmd.ExecuteReader()
    While reader.Read()
        ' 添加ListView行和列
        Dim item As New ListViewItem(reader("Column1").ToString())
        item.SubItems.Add(reader("Column2").ToString())
        item.SubItems.Add(reader("Column3").ToString())
        ListView1.Items.Add(item)
    End While

    ' 关闭数据库连接
    conn.Close()
End Sub