如何使用CurrencyManagement?

//如何使用CurrencyManagement?

//表结构:

//t1存储了主键pk1、普通列USER_NAME、外键fk1（t2的主键），与TextBox绑定

//t2存储了主键pk2、Creator，与ComboBox绑定

 

CurrencyManager currencyManager;

private void BindingControls()

{

currencyManager= (CurrencyManager)this.BindingContext[dataSet.Tables["t1"]]; 

//绑定TextBox-->txtName

this.txtName.DataBindings.Add("Text", dataSet.Tables["t1"], "USER_NAME");

//绑定ComboBox

this.cbCreator.DataSource = dataSet.Tables["t2"];
this.cbCreator.DisplayMember = "Creator";
this.cbCreator.ValueMember = "pk2";

}

 //很简单就实现了:当某个树的节点被选中时，联动显示所有绑定的控件的值

private void treeView_AfterSelect(object sender, TreeViewEventArgs e)
        {

DataRow row = dataSet.Tables["t1"].Rows.Find(treeView.SelectedNode.Tag.ToString());

//Tag中存储了表的主键

             int iPosition = dataSet.Tables["t1"].Rows.IndexOf(row);

             currencyManager.Position = iPosition;

 

//指定绑定的ComboBox当前需要显示的值
cbCreator.SelectedValue = row["fk1"];

}

 

现在尚没写完，有时间了再改改。大致就是这个意思了