代码大概如下:每次单击绑定数据后,总是有上一次数据的影子,试过在绑定下一数据时,删除上一绑定的数据,但还是一样的结果,求高手们解答。
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"]; }
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"]; }
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货