C# Access Database Remove Rows

Question

Hey, I don't know how to remove a row in Access Database on C# I know how to add a row:

    Database3DataSet.ClientsDataTable Tclients = database3DataSet.Clients;
    Tclients.AddClientsRow(textBox1.Text, textBox2.Text);

But I don't know how to remove... Please help D:

Download link for the Application: http://uploading.com/files/11b69ce6/WindowsFormsApplication4.rar/ I Realy don't know why it's didn't work... Can you tell me what's the problem? Thanks. :)

Database3DataSet.ClientsDataTable doesn't appear to be a public library class. If that is not the case, can you post a link to it's documentation? — Bala R
– Bala R, Commented May 6, 2011 at 12:59
Download link for the Application: uploading.com/files/11b69ce6/WindowsFormsApplication4.rar I Realy don't know why it's didn't work... Can you tell me what's the problem? Thanks. :) — Jonas
– Jonas, Commented May 6, 2011 at 14:17
I still doמ't understand why the row isn't deleted from the database :( — Jonas
– Jonas, Commented May 6, 2011 at 16:31

Ken Pespisa · Accepted Answer · 2011-05-06 13:37:44Z

1

There's a Delete() method on the DataRow object.

Tclients.Rows[0].Delete();
Tclients.AcceptChanges();  // commit the changes

edited May 6, 2011 at 13:37

answered May 6, 2011 at 12:59

Ken Pespisa

22.3k3 gold badges58 silver badges63 bronze badges

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

5 Comments

Jonas Over a year ago

That is what I've done, And nothing happend: ` private void button3_Click(object sender, EventArgs e) { Database3DataSet.ClientsDataTable Tclients = database3DataSet.Clients; Tclients.Rows[listBox1.SelectedIndex].Delete(); } `

Ken Pespisa Over a year ago

You'll need to also call the AcceptChanges() method. See here

Jonas Over a year ago

Download link for the Application: uploading.com/files/11b69ce6/WindowsFormsApplication4.rar I Realy don't know why it's didn't work... Can you tell me what's the problem? Thanks. :)

user153923 Over a year ago

@Jonas: Have you tried reloading your database after accepting the change? Your application typically does not know to reload on it's own.

Jonas Over a year ago

Help? :( It's very important to me

Collectives™ on Stack Overflow

C# Access Database Remove Rows

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related