Deleting data from an MS Access Database with C# via button click

Question

I am trying to delete Data from my database via a button click however I am currently getting the error:

"An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: No value given for one or more required parameters."

This is my code for the delete button:

private void btnDelete_Click(object sender, EventArgs e)
    {
        connect.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\Foundation Degree\Year 2\Chris Ovia\Assignment2\Assignment2\BookSellersDatabase.mdb";
        tempTitle = txtTitle.Text;
        connect.Open();
        OleDbCommand cmd = new OleDbCommand("DELETE FROM Book WHERE Title = tempTitle", connect);
        cmd.ExecuteNonQuery();
        MessageBox.Show("Data Deleted", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information);
        connect.Close();

        //this.Refresh();
        //Application.DoEvents(); 
    }

Praveen Paulose · Accepted Answer · 2015-03-27 17:45:26Z

3

The delete query should be

OleDbCommand cmd = new OleDbCommand("DELETE FROM Book WHERE Title ='" +  tempTitle + "'", connect);

answered Mar 27, 2015 at 17:45

Praveen Paulose

5,7711 gold badge19 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

iiAaronXiX Over a year ago

Thank you that has worked :D While I'm here, do you know how to make it so that it refreshes the form after it has deleted the data?

Praveen Paulose Over a year ago

You will need to clear each textbox then. If you however use binding as a mechanism to bind textboxes to data, you can clear the information with a single line of code.

krobelusmeetsyndra Over a year ago

Using string interpolation (for better visuals), OleDbCommand cmd = new OleDbCommand($"DELETE FROM Book WHERE Title ='"{ tempTitle }"'", connect);.

Collectives™ on Stack Overflow

Deleting data from an MS Access Database with C# via button click

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related