绑定、查看和筛选数据

绑定字符串
    String[] myStrings = new String[3];
    myStrings[0] = "A";
    myStrings[1] = "String";
    myStrings[2] = "Array";
    TextBox1.DataBindings.Add("Text",myStrings,"");

    删除数据绑定
    Label1.DataBindings.Remove(Label1.DataBindings["Text"]);
    Label1.DataBindings.Clear;

数据导航 CurrencyManager对象
    this.BindingContext[DataSet1.Customers];

    this.BindingContext[DataSet1.Customers].Position = 0;
    this.BindingContext[DataSet1.Customers].Position ++;
    this.BindingContext[DataSet1.Customers].Position --;
    this.BindingContext[DataSet1.Customers].Position = 4;  //第五条
    this.BindingContext[DataSet1.Customers].Position =  DataSet1.Tables["Customers"].Rows.Count - 1;

CurrencyManager的PositionChanged事件

public void OnPositionChanged(object sender,System.EventArgs e)
{
  if (this.BindingContext[DataSet1.Customers].Position == 0)
    BackButton.Enabled = false;
  else
    BackButton.Enabled = true;

  if (this.BindingContext[DataSet1.Customers].Position == DataSet1.Tables["Customers"].Rows.Count -1)
    ForwardButton.Enabled = false;
  else
    ForwardButton.Enabled = true; 
}

this.BindingContext[DataSet1.Customers].PositionChanged += new EventHandler(this.OnPositionChanged);

数据绑定
ComboBox1.DataSource = DataSet1.Customers;
ComboBox1.DisplayMember = "CustomerID";

使用DataView
DataView myDataView = new DataView();
myDataView.Table = myDataTable;

排序
myDataView.Sort = "CustomerID";
myDataView.Sort = "State DESC, City";

筛选
myDataView.RowFilter = "City = 'Seattle'";
myDataView.RowFilter = "City IN ('Seattle','Tacoma','Blaine')";
myDataView.RowFilter = "City LIKE 'Se*t%e'";

RowState属性
   Unchanged
   Modified
   Added
   Deleted
   Detached  //已创建，不属于任何DataRowCollection
DataView.RowState
   Unchanged
   Added
   Deleted
   OriginalRows
   CurrentRows
   ModifiedCurrent
   ModifiedOriginal

用DataView编辑数据
  AllowDelete     AllowEdit     AllowNew

DataViewManager
DataViewManager myDataViewManager = new DataViewManager(myDataSet);
DataViewManager myOtherDataViewManager = new DataViewManager();
myOtherDataViewManager.DataSet = myOtherDataSet;

myDataViewManager.DataViewSettings["Customers"].RowFilter = "State = 'WA'";
//获取
DataView myDataView = myDataViewManager.CreateDataView(DataSet1.Tables[0]);