|
|
You're in the
dotnet compact framework
group:Dataview Sort
dotnet compact framework:
It works. Please provide a snippet of code.
For a working sample see http://www.alexfeinman.com/download.asp?doc=CBQuickFind.zip -- Alex Feinman --- Visit http://www.opennetcf.org [quoted text, click to view] "JoelB" <bradjs@rimrockgroup.remove.this.com> wrote in message
news:eE0ATsIFFHA.3888@TK2MSFTNGP12.phx.gbl... > 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 > >
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
Hi, Alex. Here's what I'm working with:
CommandText = "SELECT 1 as SortOrder, DisplayNumber FROM MyTable " _ "UNION SELECT 2 as SortOrder, OtherNumber as DisplayNumber FROM MyOtherTable" Dim Command As New SqlCeCommand(CommandText, ConnectionToLocalDB) Command.CommandType = CommandType.Text Dim Adapter As New SqlServerCe.SqlCeDataAdapter(Command) Adapter.Fill(dsNumbers) dvNumbersSorted = New DataView(dsNumbers.Tables("Table")) dvNumbersSorted.Sort = "SortOrder, DisplayNumber" cmb.DataSource = dvNumbersSorted cmb.DisplayMember = "DisplayNumber" The output from the SQL statement is this: 1 12345 2 1-0284 The combo displays this... 12345 1-0284 ....regardless of whether I use "SortOrder, DisplayNumber DESC" or "SortOrder, DisplayNumber ASC" If I drop either column and flip ASC/DESC (sorting on just one column), the sort flips as expected. Joel [quoted text, click to view] "Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message news:%23HCG4KJFFHA.392@TK2MSFTNGP14.phx.gbl... > It works. Please provide a snippet of code. > For a working sample see > http://www.alexfeinman.com/download.asp?doc=CBQuickFind.zip > > -- > Alex Feinman > --- > Visit http://www.opennetcf.org > "JoelB" <bradjs@rimrockgroup.remove.this.com> wrote in message > news:eE0ATsIFFHA.3888@TK2MSFTNGP12.phx.gbl... >> 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 >> >> >
I must be missing something here. You have these data:
SortOrder DisplayNumber 1 12345 2 1-0284 Why do you expect that the order with "SortOrder, DisplayNumber ASC" will be different from "SortOrder, DisplayNumber DESC" The secondary sort criterium (Displaynumber) is taken into account if the primary one is the same for affected records. If your data were SortOrder DisplayNumber 2 12345 2 1-0284 then having DisplayNumber ASC vs DisplayNumber DESC would have mattered. As it is the records are sorted first on SortOrder field. -- Alex Feinman --- Visit http://www.opennetcf.org [quoted text, click to view] "JoelB" <bradjs@rimrockgroup.remove.this.com> wrote in message
news:u5hrqlqFFHA.2296@TK2MSFTNGP15.phx.gbl... > Hi, Alex. Here's what I'm working with: > > CommandText = "SELECT 1 as SortOrder, DisplayNumber FROM MyTable " _ > "UNION SELECT 2 as SortOrder, OtherNumber as DisplayNumber FROM > MyOtherTable" > > Dim Command As New SqlCeCommand(CommandText, ConnectionToLocalDB) > Command.CommandType = CommandType.Text > Dim Adapter As New SqlServerCe.SqlCeDataAdapter(Command) > Adapter.Fill(dsNumbers) > dvNumbersSorted = New DataView(dsNumbers.Tables("Table")) > dvNumbersSorted.Sort = "SortOrder, DisplayNumber" > cmb.DataSource = dvNumbersSorted > cmb.DisplayMember = "DisplayNumber" > > The output from the SQL statement is this: > > 1 12345 > 2 1-0284 > > The combo displays this... > > 12345 > 1-0284 > > ...regardless of whether I use "SortOrder, DisplayNumber DESC" or > "SortOrder, DisplayNumber ASC" > > If I drop either column and flip ASC/DESC (sorting on just one column), > the sort flips as expected. > > Joel > > "Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message > news:%23HCG4KJFFHA.392@TK2MSFTNGP14.phx.gbl... >> It works. Please provide a snippet of code. >> For a working sample see >> http://www.alexfeinman.com/download.asp?doc=CBQuickFind.zip >> >> -- >> Alex Feinman >> --- >> Visit http://www.opennetcf.org >> "JoelB" <bradjs@rimrockgroup.remove.this.com> wrote in message >> news:eE0ATsIFFHA.3888@TK2MSFTNGP12.phx.gbl... >>> 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 >>> >>> >> > >
Alex,
The problem is that it's not sorting on the SortOrder column either. If it were, the two different sorts would come out like this, yes? 1 12345 2 1-0284 2 1-0284 1 12345 The sort occurs before the dataview is associated with the combo, so the fact that the sort order column is not the diplay field should not affect the sort, should it? In other words, I would expect the combo to diplay as follows: ASC 12345 1-0284 DESC 1-0284 12345 Joel [quoted text, click to view] "Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message news:uT1qQwtFFHA.3504@TK2MSFTNGP12.phx.gbl... >I must be missing something here. You have these data: > SortOrder DisplayNumber > 1 12345 > 2 1-0284 > > Why do you expect that the order with "SortOrder, DisplayNumber ASC" will > be different from "SortOrder, DisplayNumber DESC" > The secondary sort criterium (Displaynumber) is taken into account if the > primary one is the same for affected records. If your data were > SortOrder DisplayNumber > 2 12345 > 2 1-0284 > > then having DisplayNumber ASC vs DisplayNumber DESC would have mattered. > As it is the records are sorted first on SortOrder field. > > -- > Alex Feinman > --- > Visit http://www.opennetcf.org > "JoelB" <bradjs@rimrockgroup.remove.this.com> wrote in message > news:u5hrqlqFFHA.2296@TK2MSFTNGP15.phx.gbl... >> Hi, Alex. Here's what I'm working with: >> >> CommandText = "SELECT 1 as SortOrder, DisplayNumber FROM MyTable " _ >> "UNION SELECT 2 as SortOrder, OtherNumber as DisplayNumber FROM >> MyOtherTable" >> >> Dim Command As New SqlCeCommand(CommandText, ConnectionToLocalDB) >> Command.CommandType = CommandType.Text >> Dim Adapter As New SqlServerCe.SqlCeDataAdapter(Command) >> Adapter.Fill(dsNumbers) >> dvNumbersSorted = New DataView(dsNumbers.Tables("Table")) >> dvNumbersSorted.Sort = "SortOrder, DisplayNumber" >> cmb.DataSource = dvNumbersSorted >> cmb.DisplayMember = "DisplayNumber" >> >> The output from the SQL statement is this: >> >> 1 12345 >> 2 1-0284 >> >> The combo displays this... >> >> 12345 >> 1-0284 >> >> ...regardless of whether I use "SortOrder, DisplayNumber DESC" or >> "SortOrder, DisplayNumber ASC" >> >> If I drop either column and flip ASC/DESC (sorting on just one column), >> the sort flips as expected. >> >> Joel >> >> "Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message >> news:%23HCG4KJFFHA.392@TK2MSFTNGP14.phx.gbl... >>> It works. Please provide a snippet of code. >>> For a working sample see >>> http://www.alexfeinman.com/download.asp?doc=CBQuickFind.zip >>> >>> -- >>> Alex Feinman >>> --- >>> Visit http://www.opennetcf.org >>> "JoelB" <bradjs@rimrockgroup.remove.this.com> wrote in message >>> news:eE0ATsIFFHA.3888@TK2MSFTNGP12.phx.gbl... >>>> 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 >>>> >>>> >>> >> >> >
Actually no. ASC and DESC are modifiers on a specific column, not the whole
set of columns. The default is ASC. So in your case: SortOrder, DisplayNumber ASC and SortOrder, DisplayNumber DESC Both will order by SortOrder in ascending order first. As Alex said, only when there are multiples of the first column does the sort order of the second make any difference. You should modify it to something like this: SortOrder DESC, DisplayNumber DESC -- Chris Tacke Co-founder OpenNETCF.org Has OpenNETCF helped you? Consider donating to support us! http://www.opennetcf.org/donate [quoted text, click to view] "JoelB" <bradjs@rimrockgroup.remove.this.com> wrote in message news:eKZ9%232FGFHA.3824@TK2MSFTNGP10.phx.gbl... > Alex, > > The problem is that it's not sorting on the SortOrder column either. If > it were, the two different sorts would come out like this, yes? > > 1 12345 > 2 1-0284 > > 2 1-0284 > 1 12345 > > The sort occurs before the dataview is associated with the combo, so the > fact that the sort order column is not the diplay field should not affect > the sort, should it? In other words, I would expect the combo to diplay > as follows: > > ASC > 12345 > 1-0284 > > DESC > 1-0284 > 12345 > > Joel > > "Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message > news:uT1qQwtFFHA.3504@TK2MSFTNGP12.phx.gbl... >>I must be missing something here. You have these data: >> SortOrder DisplayNumber >> 1 12345 >> 2 1-0284 >> >> Why do you expect that the order with "SortOrder, DisplayNumber ASC" will >> be different from "SortOrder, DisplayNumber DESC" >> The secondary sort criterium (Displaynumber) is taken into account if the >> primary one is the same for affected records. If your data were >> SortOrder DisplayNumber >> 2 12345 >> 2 1-0284 >> >> then having DisplayNumber ASC vs DisplayNumber DESC would have mattered. >> As it is the records are sorted first on SortOrder field. >> >> -- >> Alex Feinman >> --- >> Visit http://www.opennetcf.org >> "JoelB" <bradjs@rimrockgroup.remove.this.com> wrote in message >> news:u5hrqlqFFHA.2296@TK2MSFTNGP15.phx.gbl... >>> Hi, Alex. Here's what I'm working with: >>> >>> CommandText = "SELECT 1 as SortOrder, DisplayNumber FROM MyTable " _ >>> "UNION SELECT 2 as SortOrder, OtherNumber as DisplayNumber FROM >>> MyOtherTable" >>> >>> Dim Command As New SqlCeCommand(CommandText, ConnectionToLocalDB) >>> Command.CommandType = CommandType.Text >>> Dim Adapter As New SqlServerCe.SqlCeDataAdapter(Command) >>> Adapter.Fill(dsNumbers) >>> dvNumbersSorted = New DataView(dsNumbers.Tables("Table")) >>> dvNumbersSorted.Sort = "SortOrder, DisplayNumber" >>> cmb.DataSource = dvNumbersSorted >>> cmb.DisplayMember = "DisplayNumber" >>> >>> The output from the SQL statement is this: >>> >>> 1 12345 >>> 2 1-0284 >>> >>> The combo displays this... >>> >>> 12345 >>> 1-0284 >>> >>> ...regardless of whether I use "SortOrder, DisplayNumber DESC" or >>> "SortOrder, DisplayNumber ASC" >>> >>> If I drop either column and flip ASC/DESC (sorting on just one column), >>> the sort flips as expected. >>> >>> Joel >>> >>> "Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message >>> news:%23HCG4KJFFHA.392@TK2MSFTNGP14.phx.gbl... >>>> It works. Please provide a snippet of code. >>>> For a working sample see >>>> http://www.alexfeinman.com/download.asp?doc=CBQuickFind.zip >>>> >>>> -- >>>> Alex Feinman >>>> --- >>>> Visit http://www.opennetcf.org >>>> "JoelB" <bradjs@rimrockgroup.remove.this.com> wrote in message >>>> news:eE0ATsIFFHA.3888@TK2MSFTNGP12.phx.gbl... >>>>> 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 >>>>> >>>>> >>>> >>> >>> >> > >
Follow Alex suggestions. Remove SortOrder order criteria and leave only
"DisplayNumber DESC" / "DisplayNumber" then you will get a resulset that you wanted. Best regards, Sergey Bogdanov http://www.sergeybogdanov.com [quoted text, click to view] JoelB wrote:
> Alex, > > The problem is that it's not sorting on the SortOrder column either. If it > were, the two different sorts would come out like this, yes? > > 1 12345 > 2 1-0284 > > 2 1-0284 > 1 12345 > > The sort occurs before the dataview is associated with the combo, so the > fact that the sort order column is not the diplay field should not affect > the sort, should it? In other words, I would expect the combo to diplay as > follows: > > ASC > 12345 > 1-0284 > > DESC > 1-0284 > 12345 > > Joel > > "Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message > news:uT1qQwtFFHA.3504@TK2MSFTNGP12.phx.gbl... > >>I must be missing something here. You have these data: >>SortOrder DisplayNumber >>1 12345 >>2 1-0284 >> >>Why do you expect that the order with "SortOrder, DisplayNumber ASC" will >>be different from "SortOrder, DisplayNumber DESC" >>The secondary sort criterium (Displaynumber) is taken into account if the >>primary one is the same for affected records. If your data were >>SortOrder DisplayNumber >>2 12345 >>2 1-0284 >> >>then having DisplayNumber ASC vs DisplayNumber DESC would have mattered. >>As it is the records are sorted first on SortOrder field. >> >>-- >>Alex Feinman >>--- >>Visit http://www.opennetcf.org >>"JoelB" <bradjs@rimrockgroup.remove.this.com> wrote in message >>news:u5hrqlqFFHA.2296@TK2MSFTNGP15.phx.gbl... >> >>>Hi, Alex. Here's what I'm working with: >>> >>>CommandText = "SELECT 1 as SortOrder, DisplayNumber FROM MyTable " _ >>> "UNION SELECT 2 as SortOrder, OtherNumber as DisplayNumber FROM >>>MyOtherTable" >>> >>>Dim Command As New SqlCeCommand(CommandText, ConnectionToLocalDB) >>>Command.CommandType = CommandType.Text >>>Dim Adapter As New SqlServerCe.SqlCeDataAdapter(Command) >>>Adapter.Fill(dsNumbers) >>>dvNumbersSorted = New DataView(dsNumbers.Tables("Table")) >>>dvNumbersSorted.Sort = "SortOrder, DisplayNumber" >>>cmb.DataSource = dvNumbersSorted >>>cmb.DisplayMember = "DisplayNumber" >>> >>>The output from the SQL statement is this: >>> >>>1 12345 >>>2 1-0284 >>> >>>The combo displays this... >>> >>>12345 >>>1-0284 >>> >>>...regardless of whether I use "SortOrder, DisplayNumber DESC" or >>>"SortOrder, DisplayNumber ASC" >>> >>>If I drop either column and flip ASC/DESC (sorting on just one column), >>>the sort flips as expected. >>> >>>Joel >>> >>>"Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message >>>news:%23HCG4KJFFHA.392@TK2MSFTNGP14.phx.gbl... >>> >>>>It works. Please provide a snippet of code. >>>>For a working sample see >>>>http://www.alexfeinman.com/download.asp?doc=CBQuickFind.zip >>>> >>>>-- >>>>Alex Feinman >>>>--- >>>>Visit http://www.opennetcf.org >>>>"JoelB" <bradjs@rimrockgroup.remove.this.com> wrote in message >>>>news:eE0ATsIFFHA.3888@TK2MSFTNGP12.phx.gbl... >>>> >>>>>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 >>>>> >>>>> >>>> >>> >
Thank you gentlemen. Chris -- I think you nailed it -- I did not understand
that it didn't pertain to all columns, but to each column! I'll give that a shot. Sergey, your suggestion would not have produced the results I was after, but my example was at fault. I just didn't provide enough data to make it clear. Anyway, thanks to both of you. Joel [quoted text, click to view] "Chris Tacke, eMVP" <ctacke@spamfree-opennetcf.org> wrote in message news:%23qHs0iGGFHA.3732@TK2MSFTNGP14.phx.gbl... > Actually no. ASC and DESC are modifiers on a specific column, not the > whole set of columns. The default is ASC. > > So in your case: > SortOrder, DisplayNumber ASC > and > SortOrder, DisplayNumber DESC > > Both will order by SortOrder in ascending order first. As Alex said, only > when there are multiples of the first column does the sort order of the > second make any difference. > > You should modify it to something like this: > SortOrder DESC, DisplayNumber DESC > > -- > Chris Tacke > Co-founder > OpenNETCF.org > Has OpenNETCF helped you? Consider donating to support us! > http://www.opennetcf.org/donate
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |