下面是一个按钮中的代码,目的是将数据绑到textbox中,第一次点这个按钮,正常。再次点就出错:
这将导致集合中的两个绑定绑定到同一个属性。
参数名: binding
private void button4_Click_1(object sender, EventArgs e)
{
string Myconnection = "server=.;database=shui;uid=sa;pwd=;";
//string sql = "select * from yhb"; string sql = "select * from yhb where zcm='" + zcm.Text.Trim() + "'";
SqlConnection Myconn = new SqlConnection(Myconnection);
Myconn.Open();
SqlCommand STcmd = new SqlCommand(sql, Myconn);
SqlDataAdapter da = new SqlDataAdapter(sql, Myconn);
DataSet dt = new DataSet();
da.Fill(dt,"tang");
this.dataGridView1.DataSource = dt.Tables[0];
yhm.DataBindings.Add("Text", dt, "tang.yhm");
}
我也明白是由于绑定了两次Text的缘故,只是想问个解决方案。
这将导致集合中的两个绑定绑定到同一个属性。
参数名: binding
private void button4_Click_1(object sender, EventArgs e)
{
string Myconnection = "server=.;database=shui;uid=sa;pwd=;";
//string sql = "select * from yhb"; string sql = "select * from yhb where zcm='" + zcm.Text.Trim() + "'";
SqlConnection Myconn = new SqlConnection(Myconnection);
Myconn.Open();
SqlCommand STcmd = new SqlCommand(sql, Myconn);
SqlDataAdapter da = new SqlDataAdapter(sql, Myconn);
DataSet dt = new DataSet();
da.Fill(dt,"tang");
this.dataGridView1.DataSource = dt.Tables[0];
yhm.DataBindings.Add("Text", dt, "tang.yhm");
}
我也明白是由于绑定了两次Text的缘故,只是想问个解决方案。
解决方案 »
- 求多个不同方法执行同一逻辑代码问题,求大神
- 新手试帖,问个弱弱的小问题
- 版本转换错误,请高手明示,谢谢!!
- c#如何实现A窗体控制B窗体的属性
- c#问题
- (高手进)C#如何执行其它程序托盘图标右键菜单
- 请问如何锁住注册表的某一项?
- 请说一下大家C#都是看哪本书入门的啊 !
- 关于ref 以及调用方法中的参数问题
- 如何用C#开发一个数字签名程序?(即一个文件添加一个摘要)谢谢。
- 在线等!!! 要combox显示多列,选择后某项后,COMBOX.TEXT只显示第一列的内容,如何做?(不用第三方控件)
- 提问:错误提示--命名空间“System.Web”中不存在类型或命名空间名称“UI”(是缺少程序集引用吗?) 如何解决??
不明白LZ为什要用个按钮控制数据的绑定呢?
可以把绑定数据的代码放进当前表单的Load事件里啊
如果非要用按钮的话,要控制它只能点一次啊
{
string Myconnection = "server=.;database=shui;uid=sa;pwd=;";
//string sql = "select * from yhb";
string sql = "select * from yhb where zcm='" + zcm.Text.Trim() + "'";
SqlConnection Myconn = new SqlConnection(Myconnection);
Myconn.Open();
SqlCommand STcmd = new SqlCommand(sql, Myconn);
SqlDataAdapter da = new SqlDataAdapter(sql, Myconn);
DataSet dt = new DataSet();
da.Fill(dt,"tang");
this.dataGridView1.DataSource = dt.Tables[0];
yhm.DataBindings.Add("Text", dt, "tang.yhm");
Myconn.Close();//这句话很重要,加上这句话,应该就没问题了。
}
_con = new SqlConnection("server=(local);uid=sa;pwd=;database=northwind");
_sqlAda = new SqlDataAdapter("select name,old from zyzhang",_con);
_ds = new DataSet();
_sqlAda.Fill(_ds,"zyzhang");
if(this.textBox1.DataBindings.Count==0)
{
this.textBox1.DataBindings.Add("Text",_ds,"zyzhang.name");
}
Form_load代码如下:
private void Form1_Load(object sender, EventArgs e)
{
zcm.Text = "131313";
Myconnection = "server=.;database=shui;uid=sa;pwd=nevertell;";
//string sql = "select * from yhb"; //string sql = "select * from yhb where zcm='" + zcm.Text.Trim() + "'";
sql = "select a.qm,a.qh,a.bh,a.ph,a.zcm,a.yhm,a.des,a.zs,a.dz,a.sj,b.sl,b.je,a.zt from yhb a,v_qianyubiao b where a.zcm=b.zcm and a.zcm='" + zcm.Text.Trim() + "'"; Myconn = new SqlConnection(Myconnection);
Myconn.Open();
STcmd = new SqlCommand(sql, Myconn);
da = new SqlDataAdapter(sql, Myconn);
dt = new DataSet();
da.Fill(dt, "tang");
this.dataGridView1.DataSource = dt.Tables[0];
yhm.DataBindings.Add("Text", dt, "tang.yhm");
dz.DataBindings.Add("Text", dt, "tang.dz");
qh.DataBindings.Add("Text", dt, "tang.qh");
bh.DataBindings.Add("Text", dt, "tang.bh");
ph.DataBindings.Add("Text", dt, "tang.ph");
sj.DataBindings.Add("Text", dt, "tang.sj");
zs.DataBindings.Add("Text", dt, "tang.zs");
sl.DataBindings.Add("Text", dt, "tang.sl");
je.DataBindings.Add("Text", dt, "tang.je");
zt.DataBindings.Add("Text", dt, "tang.zt");
}
按钮中的代码如下:
private void button4_Click_1(object sender, EventArgs e)
{
sql = "select a.qm,a.qh,a.bh,a.ph,a.zcm,a.yhm,a.des,a.zs,a.dz,a.sj,b.sl,b.je,a.zt from yhb a,v_qianyubiao b where a.zcm=b.zcm and a.zcm='" + zcm.Text.Trim() + "'";
da.Fill(dt,"tang");
yhm.Refresh();
dz.Refresh();
qh.Refresh();
bh.Refresh();
}
private void button4_Click_1(object sender, EventArgs e)
{
string Myconnection = "server=.;database=shui;uid=sa;pwd=nevertell;";
string sql = "select a.qm,a.qh,a.bh,a.ph,a.zcm,a.yhm,a.des,a.zs,a.dz,a.sj,b.sl,b.je,a.zt from yhb a,v_qianyubiao b where a.zcm=b.zcm and a.zcm='" + zcm.Text.Trim() + "'";
SqlConnection Myconn = new SqlConnection(Myconnection);
Myconn.Open();
SqlCommand STcmd = new SqlCommand(sql, Myconn);
SqlDataAdapter da = new SqlDataAdapter(sql, Myconn);
DataSet dt = new DataSet();
da.Fill(dt, "tang");
this.dataGridView1.DataSource = dt.Tables[0];
if (this.yhm.DataBindings.Count == 0)
{ yhm.DataBindings.Add("Text", dt, "tang.yhm"); }
if (this.dz.DataBindings.Count == 0)
{ dz.DataBindings.Add("Text", dt, "tang.dz"); }
if (this.qh.DataBindings.Count == 0)
{ qh.DataBindings.Add("Text", dt, "tang.qh"); }
if (this.bh.DataBindings.Count == 0)
{ bh.DataBindings.Add("Text", dt, "tang.bh"); }
if (this.ph.DataBindings.Count == 0)
{ ph.DataBindings.Add("Text", dt, "tang.ph"); }
if (this.sj.DataBindings.Count == 0)
{ sj.DataBindings.Add("Text", dt, "tang.sj"); }
if (this.zs.DataBindings.Count == 0)
{ zs.DataBindings.Add("Text", dt, "tang.zs"); }
if (this.sl.DataBindings.Count == 0)
{ sl.DataBindings.Add("Text", dt, "tang.sl"); }
if (this.je.DataBindings.Count == 0)
{ je.DataBindings.Add("Text", dt, "tang.je"); }
if (this.zt.DataBindings.Count == 0)
{ zt.DataBindings.Add("Text", dt, "tang.zt"); }
}
yhm.DataBindings.Add("Text", dt, "tang.yhm");