textbox手动绑定后运行两次就出问题,请指教[疑难杂症]
[错误提示]这将导致集合中的两个绑定绑定到同一个属性。
参数名: binding
其他:vs2005,mssql 2000,.net2.0环境
代码:
private void chaxun_Click(object sender, EventArgs e)
{
if (this.keyword.Text.Trim() != "")
{
SqlConnection myconn1 = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["myconn"]);
SqlCommand cmd1 = new SqlCommand();
myconn1.Open();
cmd1.Connection = myconn1;
cmd1.CommandText = "SELECT BigClass,SmallClass, LiaoHao, WuLiaoName, DanWei, DanJia, ChangKu, BeiZhu FROM dbo.WuLiao where liaohao = '" + keyword.Text.Trim() + "'";
SqlDataReader adp1 = cmd1.ExecuteReader();
BindingSource bs1 = new BindingSource();
bs1.DataSource = adp1;
//绑定textbox
if (adp1.HasRows == true)
{
this.LiaoHaoTB.DataBindings.Add("Text", bs1, "LiaoHao");
this.LeiBie.DataBindings.Add("Text", bs1, "BigClass");
this.NameTB.DataBindings.Add("Text", bs1, "WuLiaoName");
this.DanWei.DataBindings.Add("Text", bs1, "DanWei");
this.DanJia.DataBindings.Add("Text", bs1, "DanJia");
this.CangKu.DataBindings.Add("Text", bs1, "ChangKu");
}
adp1.Close();
myconn1.Close();
}
}
单击查询按纽第一次没问题,第2次就报错
我想是不是绑定代码放错位置了,晕忽忽的 谢谢还请各位帮忙了