datagridview button gets focus automatically

Question

0.00/5 (No votes)

See more:

I have created a datagridview at run time. The gridview is populated with data from access database. I have also created a Button Column in the gridview that contains a delete button for each row in the gridview. The event handler is the "DataGridView.CellContentClick"

Now when I click the delete button, message box asks for confirmation. When confirmed for yes question is deleted else it must do nothing.
The code works fine but the problem comes when the code has run for the first time.
Second time it automatically calls the the event handler "DataGridView.CellContentClick" without pressing the delete button.

I can not sort out the problem. Please Help.
Here is the code:

C#

void dataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
   int count = 0;
   var senderGrid = (DataGridView)sender;
   if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn)
   {
      if (e.ColumnIndex == dataGridView.Columns["DeleteButton"].Index)
      {
         if (dataGridView.Rows[e.RowIndex].IsNewRow != true)
         {
            int qno;
            qno = e.RowIndex + 1;

            DialogResult choice = MessageBox.Show("Are you sure want to delete this    Question?\nDeleted question can not be reovered.", "Delet Question", MessageBoxButtons.YesNo);

                 
            //Delete the question from the table.
            if (choice == DialogResult.Yes)
            {
               dataGridView.Rows.RemoveAt(qno - 1);
               queryDelete = "delete from " + subject + " where QueNo=" + qno + "and SetNo=" + setNo;
               try
               {
                  connection.Open();
                  command = new OleDbCommand(queryDelete, connection);
                  command.ExecuteNonQuery();                        
               }
               catch (Exception ex)                            
               {
                  MessageBox.Show(ex.ToString());
               }                         
               connection.Close();
               MessageBox.Show("Question Deleted.", "Deleted");
            }
            else
            {
               /* Do Nothing */
            }
         }
      }
   }
}

Posted 27-Aug-14 1:34am

Member 11040029

Updated 27-Aug-14 3:56am

Nelek

v2

Add a Solution

1 solution

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)

Nathan Minier · Answer 1 · 2014-08-27T03:43:00

Look at the documentation for DialogResult[^].

The DialogResult object is a windows form, which means that it needs to be disposed. The best way to implement this is:

C#

using(DialogResult choice = MessageBox.Show("Are you sure want to delete this Question?\nDeleted question can not be reovered.", "Delet Question", MessageBoxButtons.YesNo))
{
    //Delete the question from the table.
    if (choice == DialogResult.Yes)
    {
        dataGridView.Rows.RemoveAt(qno - 1);
        queryDelete = "delete from " + subject + " where QueNo=" 
        + qno + "and SetNo=" + setNo;
        try
        {
            connection.Open();
            command = new OleDbCommand(queryDelete, connection);
            command.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.ToString());
        }
        connection.Close();
        MessageBox.Show("Question Deleted.", "Deleted");
    }
    else
    {
        /* Do Nothing */
    }
}