Click here to Skip to main content
11,482,373 members (69,885 online)
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)



Advertise | Privacy | Mobile
Web03 | 2.8.150520.1 | Last Updated 3 Jul 2013
Copyright © CodeProject, 1999-2015
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