由于刚刚涉入C#,所以一些基本的问题还不是很清楚,发贴向论坛上的高手们请教请教:
WINFORM放了几个textbox;1个dataGridView控件。
想实现的功能是:鼠标点击dataGridView的1条记录,会把数据传到textbox里,bindingNavigator也会跟着显示是第几条记录;或者点击bindingNavigator上的“上1个”、“下一个”之类的按忸,textbox里面的数据会跟着变,而且dataGridView上的相应记录是被选中的!
这是我自己写的代码中的一段,可老是提示“无法绑定到目标控件的属性“Text ”,也不知哪错了。
private void frmBInfoManager_Load(object sender, EventArgs e)
{
DataSet myds = boperate.getds(M_str_sql, M_str_table);
dgvCInfo.DataSource = myds.Tables[0];
bindingSource1.DataSource = myds;
bindingSource1.DataMember = M_str_table.ToString();
this.bindingNavigator1.BindingSource = this.bindingSource1;
this.dgvCInfo.DataSource = this.bindingSource1;
this.textBox1.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CName", true));
this.textBox2.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CManager", true));
this.textBox3.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CPhone", true));
this.textBox4.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CPostCode", true));
this.textBox5.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CFax", true));
this.textBox6.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CEmail", true));
this.textBox7.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CNAddress", true));
this.textBox8.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CAddress", true));
this.textBox9.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CRe", true));
}
WINFORM放了几个textbox;1个dataGridView控件。
想实现的功能是:鼠标点击dataGridView的1条记录,会把数据传到textbox里,bindingNavigator也会跟着显示是第几条记录;或者点击bindingNavigator上的“上1个”、“下一个”之类的按忸,textbox里面的数据会跟着变,而且dataGridView上的相应记录是被选中的!
这是我自己写的代码中的一段,可老是提示“无法绑定到目标控件的属性“Text ”,也不知哪错了。
private void frmBInfoManager_Load(object sender, EventArgs e)
{
DataSet myds = boperate.getds(M_str_sql, M_str_table);
dgvCInfo.DataSource = myds.Tables[0];
bindingSource1.DataSource = myds;
bindingSource1.DataMember = M_str_table.ToString();
this.bindingNavigator1.BindingSource = this.bindingSource1;
this.dgvCInfo.DataSource = this.bindingSource1;
this.textBox1.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CName", true));
this.textBox2.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CManager", true));
this.textBox3.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CPhone", true));
this.textBox4.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CPostCode", true));
this.textBox5.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CFax", true));
this.textBox6.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CEmail", true));
this.textBox7.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CNAddress", true));
this.textBox8.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CAddress", true));
this.textBox9.DataBindings.Add(new Binding("Text ", this.bindingSource1, "CRe", true));
}
TextBox.DataBindings["Text"].WriteValue();
我想实现保存功能,这是我写的代码段,调试没问题,可就是没有实现保存功能,还请各位帮我看一下。
private void tsbtnEdit_Click_1(object sender, EventArgs e)
{
SqlConnection sqlcon = boperate.getcon();
SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sql, sqlcon);
DataSet myds = new DataSet();
sqlda.Fill(myds, M_str_table);
SqlCommandBuilder myBuilder = new SqlCommandBuilder(sqlda);
sqlda.Update(myds, M_str_table);
myds.AcceptChanges();
}
一来, 这些数据都是 unmodified 状态的,
二来即使有修改的记录, 你也没定义 增/删/改 命令的.