DataTable.select()
代码:
DataTable ta = new DataTable("Suppliers");
ta.Columns.Add("ID", typeof(int));
ta.Columns.Add("UserName", typeof(string));
ta.Columns.Add("PassWord",typeof(string));
DataRow row;
row = ta.NewRow();
row["ID"] = 1;
row["UserName"] = "ztl001";
row["PassWord"] = "ztl1001-123";
ta.Rows.Add(row);
row = ta.NewRow();
row["ID"] = 3;
row["UserName"] = "ztl003";
row["PassWord"] = "ztl1003-123";
ta.Rows.Add(row);
row = ta.NewRow();
row["ID"] = 2;
row["UserName"] = "ztl002";
row["PassWord"] = "ztl1002-123";
ta.Rows.Add(row);
DataRow[] rows = ta.Select("", "ID desc", DataViewRowState.CurrentRows );
for (int i = 0; i < rows.Length; i++)
{
Console.WriteLine(rows[i]["PassWord"]);
}
结果: