WEB技术DataGrid应用之排序

最新推荐文章于 2024-11-06 16:04:23 发布

kennymoni

最新推荐文章于 2024-11-06 16:04:23 发布

阅读量594

点赞数

文章标签： datagrid web string server object html

本文链接：https://blog.csdn.net/kennymoni/article/details/571170

版权

网格中对列进行排序

<%@ Import Namespace="System.Data" %>

<html>
 
<script language="C#" runat="server">

    string SortField;

    ICollection CreateDataSource() {
        DataTable dt = new DataTable();
        DataRow dr;

        dt.Columns.Add(new DataColumn("整数值", typeof(Int32)));
        dt.Columns.Add(new DataColumn("字符串值", typeof(string)));
        dt.Columns.Add(new DataColumn("日期时间值", typeof(DateTime)));
        dt.Columns.Add(new DataColumn("布尔值", typeof(bool)));
        dt.Columns.Add(new DataColumn("货币值", typeof(double)));

        for (int i = 0; i < 9; i++) {
            dr = dt.NewRow();

            dr[0] = 9-i;
            dr[1] = "项 " + i.ToString();
            dr[2] = DateTime.Now;
            dr[3] = (i % 2 != 0) ? true : false;
            dr[4] = 1.23 * (i+1);

            dt.Rows.Add(dr);
        }

        DataView dv = new DataView(dt);
        dv.Sort = SortField;
        return dv;
    }

    void Page_Load(Object sender, EventArgs e) {
        if (!IsPostBack) {
            if (SortField == "") {
                SortField = "IntegerValue";
            }    
            BindGrid();
        }    
    }

    void MyDataGrid_Sort(Object sender, DataGridSortCommandEventArgs e) {
        SortField = (string)e.SortExpression;
        BindGrid();
    }

    void BindGrid() {
        MyDataGrid.DataSource = CreateDataSource();
        MyDataGrid.DataBind();
    }


</script>

<body>

    <h3><font face="宋体">DataGrid 中的基本排序</font></h3>

    <form runat=server>

      <ASP:DataGrid id="MyDataGrid" runat="server"
        AllowSorting="true"//关键：“true”
        OnSortCommand="MyDataGrid_Sort"
        BorderColor="black"
        BorderWidth="1"
        CellPadding="3"
        Font-Name="宋体"
        Font-Size="8pt"
        HeaderStyle-BackColor="#ccccff"
        HeaderStyle-ForeColor="black"
      />

  </form>

</body>
</html>