i have some queries regarding msgboxs

Question

3.00/5 (2 votes)

See more:

wat will i hve to do in order to not erase the record when i select the no option in message box.my codin is as written below

Dim cmd As New SqlCommand("delete from loading where loadingrefno='" & loadingrefno.Text & "'", con)
       Dim res As Integer = cmd.ExecuteNonQuery
       If res = 1 Then
           MsgBox("Are You sure you want to delete", MsgBoxStyle.YesNo, "Are You Sure")
           Exit Sub
           MsgBox("deleted succesfully")
           clear()
           AutoGenerate()
           fill()
       Else
           MsgBox("details not found")
       End If

Posted 10-Dec-11 19:59pm

jus coding

Updated 10-Dec-11 20:02pm

Abhinav S

v2

Add a Solution

2 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)

Abhinav S · Accepted Answer · 2011-12-10T20:05:00

Solution 1

A message box returns the value that the user has chosen.
Try

if (MsgBox("Are You sure you want to delete", MsgBoxStyle.YesNo, "Are You Sure")==DialogResult.Yes Then
            //Delete code here
            MsgBox("deleted succesfully")
            clear()
            AutoGenerate()
            fill()
EndIf

Posted 10-Dec-11 20:05pm

Abhinav S

Comments

[no name] 11-Dec-11 2:18am

5!

Monjurul Habib 11-Dec-11 4:46am

5!

Abhinav S 11-Dec-11 4:49am

Thanks Monjurul.

Abhinav S 11-Dec-11 4:48am

Thanks Pranit.

Rubaba 11-Dec-11 6:20am

5+

Abhinav S 11-Dec-11 6:27am

Thanks Rubaba.

thatraja 11-Dec-11 7:22am

5!

Abhinav S 11-Dec-11 7:24am

Thanks thatraja. Someone gave me a 2 vote.
They could have atleast left a reason so that I could have corrected / updated my answer.

Monjurul Habib 11-Dec-11 7:50am

yes i do agree Abhinav.How someone could do this without proper reason??

Monjurul Habib · Accepted Answer · 2011-12-10T20:08:00

Solution 2

Try the following:
VB.NET MessageBox.Show Examples

Posted 10-Dec-11 20:08pm

Monjurul Habib

Comments

Abhinav S 11-Dec-11 4:49am

Yes should help the OP. 5.

Monjurul Habib 11-Dec-11 4:55am

thank you

Rubaba 11-Dec-11 6:20am

5+

Monjurul Habib 11-Dec-11 7:42am

thank you rubaba

thatraja 11-Dec-11 7:22am

5!

Monjurul Habib 11-Dec-11 7:43am

thank you RAJA