sql - Private Sub BtnUpdate_Click(sender As System.Object, e As System.EventArgs) 处理 BtnUpdate.Click

Question

我能够更新我的数据，但是当我单击否或取消时，我仍然会看到数据已更新消息框。我对代码进行了哪些更改以停止更改而不获取更新的消息框？

Private Sub BtnUpdate_Click(sender As System.Object, e As System.EventArgs) Handles BtnUpdate.Click
    Try
        da1.Update(ds1, "Table")

        MessageBox.Show("Do you want to update?", "Table", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question)

        If (DialogResult.Yes) Then
            MessageBox.Show("Data Updated...!")
            End

        ElseIf (DialogResult.No) Then
            End

        ElseIf DialogResult.Cancel Then
            End

        End If

    Catch ex As Exception
        MsgBox(ex.ToString)
    End Try
End Sub

标签： sqlvb.net

Answer 1

您必须获取 MessageBox.Show 的结果，因此您必须定义一个变量来存储您的结果。

尝试这个：

Dim yourResult As DialogResult = MessageBox.Show("Do you want to update?", "Table", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question)

If (yourResult = DialogResult.Yes) Then
        MessageBox.Show("Data Updated...!")

    ElseIf (yourResult = DialogResult.No) Then Console.WriteLine("Press No")

    ElseIf (yourResult = DialogResult.Cancel) Then Console.WriteLine("Press Cancel")

End If