MsgBox w/ Yes & No (VB.net)

Question

1.00/5 (1 vote)

See more:

Hello!
I am using Microsoft Visual Studio 2005.

How can I make a message box that can confirm action?
This is my code:

VB

Private Sub BTNunlock_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BTNunlock.Click
        Try
            sqlsa = "UPDATE MAS_Users set islocked='0' WHERE empno='" & TBempno.Text & "'"
            con.NoReturnQuery(sqlsa)
        Catch ex As Exception
            MsgBox("Error!", MsgBoxStyle.Critical)
        End Try
    End Sub

When I click the button, i want to show a message box that says: Confirm update? with the buttons: Yes or No

if picked yes, my data will update, if not, then no.
How can i make one?

Thanks in advance! :)

Posted 14-May-14 20:44pm

charliedev

Updated 1-Dec-22 17:02pm

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SRS(The Coder) · Answer 1 · 2014-05-14T21:20:00

Solution 2

Hope the below code example will help -

VB

Dim result As DialogResult = MessageBox.Show("Confirm update?", _
                              "Title", _
                              MessageBoxButtons.YesNo)

If(result == DialogResult.OK)
    Update data here
Else
    Nothing
End If

Posted 14-May-14 21:20pm

SRS(The Coder)

Updated 14-May-14 21:21pm

Member 10065933 · Answer 2 · 2018-01-30T21:49:00

Solution 3

Dim ask As MsgBoxResult = MsgBox("What you Want", MsgBoxStyle.YesNo)
       If ask = MsgBoxResult.Yes Then

       End If

Posted 30-Jan-18 21:49pm

Member 10065933

Comments

Richard MacCutchan 31-Jan-18 3:54am

Nearly FOUR years too late.

CHill60 1-Feb-18 8:56am

See the comments to Solution 1 - you haven't really added anything to the solutions from four years ago.
Stick to answering new posts where the OP still needs help - and be sure that your response is not just repeating earlier solutions or comments, and that it is accurate.

Karen Mitchelle · Answer 3 · 2014-05-14T21:04:00

Solution 1

this one... (simple one)

VB

Dim ans as string
ans= Msgbox "Confirm Update", vbYesNo
if ans= vbYes then
 'code to update
end if

Posted 14-May-14 21:04pm

Karen Mitchelle

Comments

F. Xaver 15-May-14 3:19am

y not using the newer and comfortable MessageBox.Show()
Msgbox is vb6 compatibility

Karen Mitchelle 15-May-14 3:28am

either way, that is, I think, okay. OP even tag VB on his/her question.

PS. I really often use MessageBox.Show(), it's just that, Msgbox is what came first in my mind. :)

Member 15851041 · Answer 4 · 2022-12-01T17:02:00

Solution 5

Dont declare variable.

If MsgBox("What you Want", MsgBoxStyle.YesNo) = MsgBoxResult.Yes Then

End If

Posted 1-Dec-22 17:02pm

Member 15851041

Comments

Richard Deeming 2-Dec-22 5:25am

Eight years late, and you've added nothing to the discussion. Declaring a variable to store the result is not the problem!