Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
 

            if (dataGridView1.CurrentCell.Value.ToString().Equals("Delete"))
            {
                DialogResult res = MessageBox.Show("Are you sure you want to delete the item?", "Shayona", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (res == DialogResult.Yes)
                {
                    conn.Open();
                    int id = Int32.Parse(dataGridView1.CurrentRow.Cells[6].Value.ToString());
                    str = "delete from branchdetails where BranchID=" + id;
                    cmd = new MySqlCommand(str, conn);
                    cmd.ExecuteNonQuery();
                    conn.Close();
                }
}
Posted 3-Jul-13 1:53am
Comments
piyush_singh at 3-Jul-13 8:24am
   
I am assuming the Column Header that you're clicking has the text "Delete". But what I would like to know is that if you're using a button in gridview to fire the delete query then why not use the Row_Deleting event? In that way your application need not have to check on each cell click whether it's a delete event or not. The delete query will only be fired when the user clicks on the delete button. You can also put your javascript confirmation to that delete button.

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 575
1 Kornfeld Eliyahu Peter 409
2 Maciej Los 369
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,353
1 DamithSL 4,854
2 Maciej Los 4,476
3 Kornfeld Eliyahu Peter 4,058
4 Sergey Alexandrovich Kryukov 3,917


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 3 Jul 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100