绑定、查看和筛选数据
绑定字符串
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事件
{
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]);