DataTable 的排序

 protected void Page_Load(object sender, EventArgs e)
    {
        TRoleBiz biz = new TRoleBiz();
        DataTable table = biz.SelectAll();       

        // 定义筛选条件字符串和排序字符串
        string strExpr = "ListID = '1'";
        string strSort = "RoleOrder DESC";

        // 获得经过筛选和排序后的数据
        DataRow[] resultRows = table.Select(strExpr, strSort);

        // 显示经过筛选和排序后的数据
        DisplayRows(resultRows, Label1);
    }
 
    // 显示DataRow数组中的内容
    public void DisplayRows(DataRow[] rows, Label label)
    {
        // 检查返回数据是否为空
        if (rows.Length <= 0)
        {
            label.Text = "没有数据";
            return;
        }
        label.Text = "";

        // 遍历DataRow数组的行和列，显示数据
        label.Text += "<Table border='1'>";       
        foreach (DataRow row in rows)
        {
            label.Text += "<TR>";
            for (int i = 0; i < row.Table.Columns.Count; i++)
            {
                label.Text += "<TD>";
                label.Text += row[i];
                label.Text += "</TD>";
            }
            label.Text += "</TR>";
        }
        label.Text += "</Table>";
    }

转载于:https://www.cnblogs.com/EasyData/archive/2007/05/26/760363.html