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);
}
}
}
}