废话不说,直接上代码
List<ListViewItem> lst = new List<ListViewItem>();
DataTable dataTable = null;
// 创建数据表视图
DataView dataView = null;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
// 创建一个仅有一列的空表
dataTable = new DataTable("dataTable");
dataView = new DataView(dataTable);
DataColumn dataColumn = new DataColumn("dataColumn");
dataTable.Columns.Add(dataColumn);
// 添加十行记录item 0,item 1,item 2,...,item 9
DataRow dataRow;
for (int i = 0; i < 10; i++)
{
dataRow = dataTable.NewRow();
dataRow["dataColumn"] = "item " + i;
dataTable.Rows.Add(dataRow);
}
//标记接收数据变化
dataTable.AcceptChanges();
listView1.VirtualMode = true;
DemonstrateRowState();
}
private void DemonstrateRowState()
{
PrintView(dataView, "OriginalRows");
/*
// 改变一个行值
dataTable.Rows[1]["dataColumn"] = "Hello";
// Add one row:
dataRow = dataTable.NewRow();
dataRow["dataColumn"] = "World";
dataTable.Rows.Add(dataRow);
// 设置行过滤,仅显示新增的和当前改变的
dataView.RowStateFilter = DataViewRowState.Added
| DataViewRowState.ModifiedCurrent;
// 输出行为 "Hello" "World"
PrintView(dataView, "ModifiedCurrent and Added");
// 设置过滤显示被修改行的原始值
dataView.RowStateFilter = DataViewRowState.ModifiedOriginal;
PrintView(dataView, "ModifiedOriginal");
// 删除3行
dataTable.Rows[1].Delete();
dataTable.Rows[2].Delete();
dataTable.Rows[3].Delete();
// 设置行过滤显示只显示和修改
dataView.RowStateFilter = DataViewRowState.Deleted;
PrintView(dataView, "Deleted");
//显示当前数据
dataView.RowStateFilter = DataViewRowState.CurrentRows;
PrintView(dataView, "Current");
//显示没有改变的行
dataView.RowStateFilter = DataViewRowState.Unchanged;
PrintView(dataView, "Unchanged");
//显示原始数据.
dataView.RowStateFilter = DataViewRowState.OriginalRows;
PrintView(dataView, "OriginalRows");
*/
}
private void PrintView(DataView dataView, string label)
{
for (int i = 0; i < dataView.Count; i++)
{
Console.WriteLine(dataView[i]["dataColumn"]);
}
listView1.VirtualListSize = dataView.Count;
}
private void listView1_RetrieveVirtualItem(object sender, RetrieveVirtualItemEventArgs e)
{
e.Item = new ListViewItem();
e.Item.Text = dataView[e.ItemIndex][0].ToString();
for(int i=1;i<dataTable.Columns.Count;i++)
{
e.Item.SubItems.Add(dataView[e.ItemIndex][i].ToString());
}
}
private void button1_Click(object sender, EventArgs e)
{//修改
// 改变一个行值
dataTable.Rows[1]["dataColumn"] = "Hello";
dataView.RowStateFilter = DataViewRowState.Added
| DataViewRowState.ModifiedCurrent;
PrintView(dataView, "ModifiedCurrent");
}
private void button2_Click(object sender, EventArgs e)
{//重置
dataView.RowFilter = "";
dataView.RowStateFilter = DataViewRowState.OriginalRows;
PrintView(dataView, "OriginalRows");
}
private void button3_Click(object sender, EventArgs e)
{//筛选
dataView.RowFilter = "dataColumn <> 'item 2'";
//显示当前数据
dataView.RowStateFilter = DataViewRowState.OriginalRows;
PrintView(dataView, "OriginalRows");
}