Dataview Sort

From: JoelB (bradjs_at_rimrockgroup.remove.this.com)
Date: 02/17/05


Date: Wed, 16 Feb 2005 17:53:17 -0700

Apparently CF doesn't support sorting a dataview on multiple columns. The
following all work:

    MyDV.Sort = "Col1"
    MyDV.Sort = "Col2 DESC"

...but this doesn't:

    MyDV.Sort = "Col1, Col2 DESC"

No error occurs.

I am using the Dataview to sort my data before binding it to a combo. I
need the two column sort because the dataset is built with a UNION query (I
won't get into the details).

Has anyone else encountered this, or does anyone have any comments?

Joel



Relevant Pages

  • DataTable: Sort by multiple columns.
    ... We are on Visual Basic .NET 2003 and i am using DataView to sort the ... dvShiftData is a DataView ... Is there a way we can sort a DataTable based on multiple columns? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Only Bind a Subset of records
    ... select and paging is needed. ... I see not any reason why he would use the dataview (which as you probably ... when/if the user clicks on a grid footer ... > event on the header and then sort on that column's index in the dataview). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Only Bind a Subset of records
    ... > select and paging is needed. ... > I see not any reason why he would use the dataview (which as you probably ... when/if the user clicks on a grid footer ... >> change the sort order of the data and then change it back. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Sorting DataView
    ... I created a dataview on the primary table so that I can sort by first name / ... The related data from the child tables are shown in the respective tabs. ... So the fields on the form is bound to the dataview. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Only Bind a Subset of records
    ... when/if the user clicks on a grid footer item ... where the paging is set up, you can simply specify a range of values in the ... RowFilter property and then rebind the grid to the dataview. ... event on the header and then sort on that column's index in the dataview). ...
    (microsoft.public.dotnet.framework.adonet)