Confirmation of Deleteing record

Question

1.00/5 (1 vote)

See more:

I have a combo Box where I can get display record in Access Database and then I can also delete the record !
The button function works fine and the code is like this !

C#

private void btnDelete_Click(object sender, EventArgs e)
{
    Person p = new Person();
    p = cmbPersons.SelectedItem as Person;

    b.Delete(p);

}

Now I want to add a confirmation when button is clicked, " The data containing abc has been deleted"
My question is do I need to add something only in this button part ? or I need to add something in this part also ?

C#

public void Delete(Person p)
       {
           try
           {
               command.CommandText = "DELETE FROM TPersons WHERE ID= "+p.Id;
               command.CommandType = CommandType.Text;
               connection.Open();

               command.ExecuteNonQuery();

           }
           catch (Exception)
           {
               throw;
           }
           finally
           {
               if (connection != null)
               {
                   connection.Close();
               }
           }
       }

Posted 25-Feb-14 22:49pm

Jahangir Khan

Add a Solution

Comments

[no name] 26-Feb-14 7:11am

What do u meant by the question part?
It's not clear and quite contradictory.
Confirmation mean assent.
but... the message 'The data containing abc has been deleted' is status/ack .
confirmation - pre deletion and
ur message text is a status - post deletion,
be clear..

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

darshan.pandya86 · Accepted Answer · 2014-02-26T00:44:00

Solution 3

Add Below code into "btnDelete" button :

OnClientClick = "return confirm('Are you sure you want to delete the selected Item?');"

Posted 26-Feb-14 0:44am

darshan.pandya86

Paddy84 · Accepted Answer · 2014-02-25T23:19:00

Solution 2

ExecuteNonQuery returns an int containing the number of rows affected so you could just put an if statement around your query execution

C#

if(command.ExecuteNonQuery() > 0)
{
     MessageBox.Show("Person deleted");
}
else
{
     MessageBox.show("Person not found");
}

Posted 25-Feb-14 23:19pm

Paddy84

Updated 26-Feb-14 0:32am

v2

Comments

Jahangir Khan 26-Feb-14 6:16am

and still I have add something in the buttoun part also ???

Paddy84 26-Feb-14 6:30am

No. The call to the Delete function, when the button is clicked, will display the message. But only if a Person has been deleted from the database.
So you could add an else statement also to give information to the user. Check the edited solution above.

Jahangir Khan 26-Feb-14 7:40am

Ok I am getting red wavey lines under MessageBox, it say Message Box does not exit in the current context ? any ideas

Paddy84 26-Feb-14 7:54am

Sounds like you don't have the reference. Are you using Visual Studio?
Check if you have this reference at the top of main.

using System.Windows.Forms;

Dinesh.V.Kumar · Accepted Answer · 2014-02-25T23:05:00

Solution 1

You can add it only in the button part.

Posted 25-Feb-14 23:05pm

Dinesh.V.Kumar