DataGridView strange

[muharrem]

I have following in my form MySqlDataAdapter da; DataSet ds; private void MyForm_Load(object sender, EventArgs e) { ds = new DataSet(); string strSQL = "SELECT A,B,C,D FROM MyTable"; da = new MySqlDataAdapter(strSQl,myConnection); da.Fill(ds, "Example"); gridForExample.DataSource = ds.Tables["Example"]; } private void btnRefresh_Click(object sender, EventArgs e) { da.Fill(ds, "Example"); } So, MyTable has only six rows in database. Every time da.Fill(ds, "Example"); executes grid view showing 6 more but same rows. I mean 6 then 12 then 18 and so on. But I expect to see only 6 rows, don't I? Or am I mistaken? Please help. Thanks

[paas]

There is no indication in this code sample that you have cleared your dataset from its first or subsequent fills, so you are just adding another 6 rows to the previous number of rows each time you do a refresh. You should do a ds.Clear() prior to the Fill if you do not want to keep appending rows to the dataset.

[muharrem]

Thanks for the answer. I don't know how I miss that point? Anyway thanks again.