代码大概如下:每次单击绑定数据后,总是有上一次数据的影子,试过在绑定下一数据时,删除上一绑定的数据,但还是一样的结果,求高手们解答。
        DataSet ds;
        SqlDataAdapter adapter;        private void pbMale_Click(object sender, EventArgs e)
        {
            string sex = "男";
            
            Fill(sex);
        }
        
        private void pbFemale_Click(object sender, EventArgs e)
        {
            string sex = "女";
            Fill(sex);
        }
        
        private void pbMix_Click(object sender, EventArgs e)
        {
            string sex = "1";
            Fill(sex);
        }
        
        public void Fill(string sex)
        {
            string sqlStr = "";
            if (sex.Equals("男") || sex.Equals("女"))
            {
                sqlStr = "select singerName from singerInfo where singerSex='" + sex + "'";
            }
            else
            {
                sqlStr = "select s.singerName from singerInfo as s " +
                            "inner join songInfo as si on(si.singerId=s.singerId) " +
                            "where si.combox=1";
            }            ds = new DataSet();
            adapter = new SqlDataAdapter(sqlStr, dbHelper.ConnStr);            adapter.Fill(ds, "Name");
            dgvResult.DataSource = ds.Tables["Name"];        }