C# with datagridView

Question

I have a database with MySQL which is connected with C# windows application.
My problem is that I have a form with 2 buttons and datagridview. The one button is exit and the other is clear.
With the button clear I want to clear all the data in the database and I can’t do this.
The only thing I have done is to clear the entries and then when I reopen the entities are there!

THE CODE IS:

private void button3_Click(object sender, EventArgs e)
{ //clear balance
    projectpizzaDataSet ds = new projectpizzaDataSet();
    projectpizzaDataSetTableAdapters.balanceTableAdapter daCust = new projectpizzaDataSetTableAdapters.balanceTableAdapter();

    for (int i = 0; i < dataGridView1.Rows.Count; i++)
    {
        dataGridView1.Rows.RemoveAt(i); //delete error 
    }
}

With this code you are deleting rows from the DataGridView not from database. — chaliasos
– chaliasos, Commented May 19, 2012 at 17:52
It seems your question should be, "How to remove records from a database?" Other than refreshing the grid after deletion, the real problem has nothing to do with that control. — IAbstract
– IAbstract, Commented May 19, 2012 at 18:39
Can you post the code for how you are binding your data to the DataGridView? — nabrond
– nabrond, Commented May 19, 2012 at 18:40
string y = comboBox2.Text; int x = Convert.ToInt32(textBox1.Text); double p = Convert.ToDouble(textBox6.Text); daCust.Insert(x, y, p); — marios
– marios, Commented May 20, 2012 at 16:05

Perception · Accepted Answer · 2012-05-22 02:47:44Z

1

Thank you all but the solution is:

private void button3_Click(object sender, EventArgs e) {
    //clear balance
    projectpizzaDataSet ds = new projectpizzaDataSet();
    projectpizzaDataSetTableAdapters.balanceTableAdapter daCust = new projectpizzaDataSetTableAdapters.balanceTableAdapter();

    while (dataGridView1.Rows.Count > 0 {
        dataGridView1.Rows.RemoveAt(0);
    }

    this.balanceTableAdapter.Update(projectpizzaDataSet.balance);
}

edited May 22, 2012 at 2:47

Perception

80.8k19 gold badges190 silver badges197 bronze badges

answered May 21, 2012 at 23:05

marios

1532 silver badges14 bronze badges

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

Comments

Leandro Battochio · Accepted Answer · 2012-05-19 19:07:53Z

0

To delete records from the database, you need to use the DELETE query. here you can find how to use the DELETE command.

answered May 19, 2012 at 19:07

Leandro Battochio

3646 silver badges22 bronze badges

Comments

chaliasos · Accepted Answer · 2012-05-20 14:18:29Z

0

You have to Delete the rows from the DataSet and then to Update the TableAdapter

private void button3_Click(object sender, EventArgs e)
{     
    foreach(DataRow row in ds.Tables["TableName"].Rows)
    {
        row.Delete();
    }

    daCust.Update(ds);
}

edited May 20, 2012 at 14:18

answered May 19, 2012 at 19:48

chaliasos

9,8137 gold badges54 silver badges90 bronze badges

2 Comments

marios Over a year ago

i try the code but is not working. on the "tablename" i wrote "balance"

chaliasos Over a year ago

Check the links I posted and also this link. I'm sure you will find your answer. Maybe your tableAdatper has a delete method itself. Also post the code on how do you create your dataset

Collectives™ on Stack Overflow

C# with datagridView

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related