ASP.NET GridView Sort using DataTable.Select

Question

Is it possible to sort an ASP.NET GridView using DataTable.Select("", sortExpression)?

I have a regular GridView with AllowSorting="true" and OnSorting="grdEmployees_Sorting".

protected void grdEmployees_Sorting(object sender, GridViewSortEventArgs e)
        {
            DataTable dt = getDataTable();

            var sortExprOrder = e.SortDirection == SortDirection.Ascending ? " ASC" : " DESC";

            var rows = dt.Select("", string.Format(e.SortExpression + "{0}", sortExprOrder));

            grdEmployees.DataSource = rows;
            grdEmployees.DataBind();
        }

Not sure why, but this does not work. The grid shows a bunch of rows with three columns, RowError, RowState, and HasErrors (contains rows with all empty checkboxes).

Am I doing something wrong?

Krishna · Accepted Answer · 2017-04-16 01:31:18Z

1

You don't need select for sorting DataTable.Select is for filtering

This how you sort

protected void grdEmployees_Sorting(object sender, GridViewSortEventArgs e)
        {
            DataTable dt = getDataTable();

            var sortExprOrder = e.SortDirection == SortDirection.Ascending ? " ASC" : " DESC";

            DataView dv = new DataView(dt);
            dv.Sort = string.Format("{0} {1}",
                e.SortExpression, sortExprOrder);

            grdEmployees.DataSource = dv;
            grdEmployees.DataBind();
        }

answered Apr 16, 2017 at 1:31

Krishna

1,9831 gold badge14 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Pavel Over a year ago

dt.Select("", sortExpression) returns DataRow[]. Why can't I assign an array of type DataRow to the DataSource of the GridView?

Krishna Over a year ago

DataRow holds data in an ItemArray, so if you want to bind DataRow you need to bind collection of ItemArray like GridView1.DataSource = rows.Select(r => r.ItemArray[0]);

Collectives™ on Stack Overflow

ASP.NET GridView Sort using DataTable.Select

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related