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"]);
}

结果：

 

转载于:https://www.cnblogs.com/miku-lai/p/5790080.html