1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Deletimg row from datagridview

Discussion in 'C#' started by kermit2012, Jan 30, 2012.

  1. kermit2012

    kermit2012 New Member

    Joined:
    Jan 29, 2012
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    0
    Hi,

    I have got a delete button on my DataGridView and when I press it, I want it to delete the row selected, I have currently got the code below, but when I press it nothing happens, can anybody tell me why?

    thanks

    Code:
    private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
    {
    string queryString = "SELECT AccountID, Title, FirstName, LastName, AccountType, Username, UserPass FROM AddAccount";
    int currentRow = int.Parse(e.RowIndex.ToString());
    
    {
    string movieIDString = dataGridView1[0, currentRow].Value.ToString();
    movieIDInt = int.Parse(movieIDString);
    }
    if (dataGridView1.Columns[e.ColumnIndex] == deleteButton && currentRow >= 0)
    {
    //delete sql query
    string queryDeleteString = "DELETE FROM Account where AccountID = '"+movieIDInt+"'";
    OleDbCommand sqlDelete = new OleDbCommand();
    sqlDelete.CommandText = queryDeleteString;
    sqlDelete.Connection = database;
    sqlDelete.ExecuteNonQuery();
    loadDataGrid(queryString);
    }
    }
    }
    }
    
     

Share This Page