DataGridView数据检索混乱

Question

我试图从数据库中检索数据后，点击查看按钮从windows窗体，但每次我点击查看按钮在数据库中的相同数据复制到DataGridView控件中的多行，而不是检索相同的数据从开始在DataGridView每次我点击查看按钮。

     //For view button 
        private void button2_Click(object sender, EventArgs e)
        {
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = businesslayer.View("Select * from itemmaster"); //passed to business access layer class
                dataGridView1.DataSource = bindingSource;

        } 


//Method in DataAccessLayer class
 public DataTable View(String query)
        {
            //Initialize a connection object
            OpenConn();

            //Initalize a command object with passing string value
            command = new SqlCommand(query, connection);
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = command;

            //Fill dataset with a table
            da.Fill(dataset, thisTable);
            return dataset.Tables[thisTable];
        }

有人能告诉我如何解决这个问题吗？

Answer 1

BindingSource bindingSource = new BindingSource(); 
dataGridView1.Items.Clear();
bindingSource.DataSource = businesslayer.View("Select * from itemmaster"); //passed to business access layer class 
dataGridView1.DataSource = bindingSource;

在将网格视图绑定到数据源之前，请尝试清除网格视图。