//我把DataGrid ,和TextBox的DataBinding同时绑定到一个表中,在删除的时间,一直出现并发冲突,影响0个记录
//还有当没有用向导时间 ,TextBox的DataBinding只绑定到第一条记录,并不随着EBindingContext对象的Position改变而改变
static void Main()
{
Application.Run(new Form1());
}
private void BindTextBox()
{
this.textBox1编号.DataBindings.Add("Text",this.db2数据集1,"biao1.编号");
this.textBox3手机号码.DataBindings.Add("Text",this.db2数据集1,"biao1.手机号码");
this.textBox4姓名.DataBindings.Add("Text",this.db2数据集1,"biao1.姓名");
}
private void BindGrid()
{
this.dataGrid1.SetDataBinding(this.db2数据集1,"biao1");
}
private void Form1_Load(object sender, System.EventArgs e)
{
try
{
this.oleDbDataAdapter1.Fill(this.db2数据集1);
this.BindTextBox();
this.BindGrid();
}
catch(System.Data.OleDb.OleDbException ex)
{
MessageBox.Show(ex.Message);
}
//
}
private void button1_Click(object sender, System.EventArgs e)
{
this.BindingContext[this.db2数据集1,"biao1"].EndCurrentEdit();
this.BindingContext[this.db2数据集1,"biao1"].AddNew();
}
private void button2_Click(object sender, System.EventArgs e)
{
this.BindingContext[this.db2数据集1,"biao1"].RemoveAt(this.BindingContext[this.db2数据集1,"biao1"].Position);
}
private void baocun()
{
this.BindingContext[this.db2数据集1,"biao1"].EndCurrentEdit();
try
{
this.oleDbDataAdapter1.Update(this.db2数据集1,"biao1");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Button取消_Click(object sender, System.EventArgs e)
{
this.BindingContext[this.db2数据集1,"biao1"].CancelCurrentEdit();
}
private void Button保存_Click(object sender, System.EventArgs e)
{
this.baocun();
}
}