.NET中DataTable类中Select()函数的使用
1.语法
Select()
Select(string filterExpression)
Select(string filterExpression, string sort)
Select(string filterExpression,string sort, DataViewRowState record States)
返回值:
DataRow[] 数组
注意:
Select操作默认是不区分大小写的,如果需要区分大小写,将DataTable的caseSensitive属性设为true,如:dt.CaseSensitive = true;
2.示例
DataTable dt = new DataTable();
dt = new DataTable("StudentInfo");
dt.Columns.Add("Id", Type.GetType("System.Int32"));
dt.Columns.Add("Name", Type.GetType("System.String"));
dt.Columns.Add("Age", Type.GetType("System.Int32"));
dt.Rows.Add(1, "张三", 40);
dt.Rows.Add(2, "李四", 25);
dt.Rows.Add(3, "王五", 22);
dt.Rows.Add(4, "赵六", 30);
DataRow[] rows = dt.Select("","Age desc");
this.Repeater1.DataSource = rows;
this.Repeater1.DataBind();