public void Select2()
{
DataSet Set = new DataSet();
DataTable Child = new DataTable("Child");
Set.Tables.Add(Child);
DataColumn Col3 = new DataColumn("Name");
DataColumn Col4 = new DataColumn("Age");
Col4.DataType = typeof(short);
Child.Columns.Add(Col3);
Child.Columns.Add(Col4);
DataRow Row = Child.NewRow();
Row[0] = "Nick";
Row[1] = 15;
Child.Rows.Add(Row);
Row = Child.NewRow();
Row[0] = "Dick";
Row[1] = 25;
Child.Rows.Add(Row);
Row = Child.NewRow();
Row[0] = "Mick";
Row[1] = 35;
Child.Rows.Add(Row);
Row = Child.NewRow();
Row[0] = "Jack";
Row[1] = 10;
Child.Rows.Add(Row);
Row = Child.NewRow();
Row[0] = "Mack";
Row[1] = 19;
Child.Rows.Add(Row);
Row = Child.NewRow();
Row[0] = "Mack";
Row[1] = 99;
Child.Rows.Add(Row);
DataRow[] Rows = Child.Select("age >= 20", "age DESC");
Assert.Equal(3, Rows.Length);
Assert.Equal("Mack", Rows[0][0]);
Assert.Equal("Mick", Rows[1][0]);
Assert.Equal("Dick", Rows[2][0]);
Rows = Child.Select("age >= 20", "age asc");
Assert.Equal(3, Rows.Length);
Assert.Equal("Dick", Rows[0][0]);
Assert.Equal("Mick", Rows[1][0]);
Assert.Equal("Mack", Rows[2][0]);
Rows = Child.Select("age >= 20", "name asc");
Assert.Equal(3, Rows.Length);
Assert.Equal("Dick", Rows[0][0]);
Assert.Equal("Mack", Rows[1][0]);
Assert.Equal("Mick", Rows[2][0]);
Rows = Child.Select("age >= 20", "name desc");
Assert.Equal(3, Rows.Length);
Assert.Equal("Mick", Rows[0][0]);
Assert.Equal("Mack", Rows[1][0]);
Assert.Equal("Dick", Rows[2][0]);
}