vb.net - 从 vb.net 中的数据库中删除后，在运行时从组合框中删除 id

Question

Private Sub btn_remove_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_remove.Click
    Dim Query As String
    mysqlconn.Open()
    Query = "delete from table where screen_id='" & cmb_id.Text & "' "
    Dim cmd As MySqlCommand = New MySqlCommand(Query, mysqlconn)
    Dim i As Integer = cmd.ExecuteNonQuery()
    If (i > 0) Then
        MsgBox("Record is Successfully deleted")

    Else
        MsgBox("Record is not deleted")
    End If
    mysqlconn.Close()
End Sub

我从组合框中选择ID。根据我从数据库中删除的所选ID。上面的代码解释相同，但我想在运行时从组合框中删除已删除的ID(从数据库删除后)

谢谢

Answer 1

解决办法很简单。删除 id 后，再次在组合框中加载数据..

Private Sub btn_remove_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_remove.Click
    Dim Query As String
    mysqlconn.Open()
    Query = "delete from table where screen_id='" & cmb_id.Text & "' "
    Dim cmd As MySqlCommand = New MySqlCommand(Query, mysqlconn)
    Dim i As Integer = cmd.ExecuteNonQuery()
    If (i > 0) Then
        MsgBox("Record is Successfully deleted")
**===> load the data here or call the function that load the data in the combo box**
    Else
        MsgBox("Record is not deleted")
    End If
    mysqlconn.Close()
End Sub