winforms datagridview sorting using LINQ

Question

Hi there!

Im using Linq...more specifically, PLINQO. anyway the following is an example of a query I have bound to a datagridview (winforms):

    public static List<Task> GetUserTasks( Guid userID ) {
        using (myDataContext ctx = new myDataContext()) {
            try {
                return ctx.Manager.Task.GetByUserID( userID ).ToList();
            } catch (Exception) {
                throw;
            }
        }
    }

In my UI, I have the following setup to bind:

        BindingSource bs = new BindingSource();
        bs.DataSource = DUtasks.GetUserTasks( User.Current.UserID );
        dgvTasks.DataSource = bs;

It works, but no sorting is possible. I tried "AsEnumerable()" instead of "ToList()" but that for some reason, throws an "objection reference" error. Any ideas as to how I can proceed on this front?

Many thanks!

Answer 1

Have you tried returning an IOrderedEnumerable? Not sure if it will help but that is designed to handle ordered LINQ results.

Answer 2

OK, problem sorted!!! :)

found the following link: SortableBindingList... (my comment is at the bottom with converted C# working code).

Now all my query methods that return List<(ENTITY)> simply get used like this:

        SortableBindingList<Task> sortedTasks = new SortableBindingList<Task>( DUtasks.GetUserTasks( User.Current.UserID ) );
        dgvTasks.DataSource = sortedTasks;
        dgvTasks.Sort( colTaskDue, ListSortDirection.Ascending );

Hope this helps someone!