dataview sorting in manual order?

[Jason]

Is it possible to somehow sort a dataview, all on one column, but on
different variables?

That is, I have a 'Title' column in my dataview and I'd like to display
first all "Directors" (sorted), then everyone else (sorted). I've used the
'ItemBound' but can't figure out how to do this with that procedure.

Thanks in advance, any ideas are appreciated.

Jason

eg of what I'm looking for:

Name Title
===== ======
George Director
Yvonne Director
Harry Programmer
Larry Research Officer
Wilbur Secretary

[Matt Hamilton]

Right after you bind the dataview, do the following:

dataview.Sort = "Titles ASC, Directors ASC"

"Jason" wrote:

Is it possible to somehow sort a dataview, all on one column, but on
different variables?

That is, I have a 'Title' column in my dataview and I'd like to display
first all "Directors" (sorted), then everyone else (sorted). I've used the
'ItemBound' but can't figure out how to do this with that procedure.

Thanks in advance, any ideas are appreciated.

Jason

eg of what I'm looking for:

Name Title
===== ======
George Director
Yvonne Director
Harry Programmer
Larry Research Officer
Wilbur Secretary

[Jason]

Unfortunately, I get:

Exception Details: System.IndexOut OfRangeExceptio n: Cannot find column
Director.

Source Error:

Line 197:
Line 198: DGADResults.Dat aSource = dvCustom
Line 199: dvCustom.Sort = "title ASC, Director ASC"
Line 200: DGADResults.Dat aBind()
Line 201: End Sub
thoughts?
"Matt Hamilton" <Ma**********@d iscussions.micr osoft.com> wrote in message
news:76******** *************** ***********@mic rosoft.com...

Right after you bind the dataview, do the following:

dataview.Sort = "Titles ASC, Directors ASC"

"Jason" wrote:

Is it possible to somehow sort a dataview, all on one column, but on
different variables?

That is, I have a 'Title' column in my dataview and I'd like to display
first all "Directors" (sorted), then everyone else (sorted). I've used the 'ItemBound' but can't figure out how to do this with that procedure.

Thanks in advance, any ideas are appreciated.

Jason

eg of what I'm looking for:

Name Title
===== ======
George Director
Yvonne Director
Harry Programmer
Larry Research Officer
Wilbur Secretary

[Scott Allen]

Jason:

You don't have a column named "Director". Change the Sort to only use
columns you do have, like Title and Name.

dataview.Sort = "Title ASC"

--
Scott
http://www.OdeToCode.com

On Wed, 1 Sep 2004 16:50:33 -0600, "Jason" <ja***@grossman s.net>
wrote:

Unfortunatel y, I get:

Exception Details: System.IndexOut OfRangeExceptio n: Cannot find column
Director.

Source Error:

Line 197:
Line 198: DGADResults.Dat aSource = dvCustom
Line 199: dvCustom.Sort = "title ASC, Director ASC"
Line 200: DGADResults.Dat aBind()
Line 201: End Sub
thoughts?
"Matt Hamilton" <Ma**********@d iscussions.micr osoft.com> wrote in message
news:76******* *************** ************@mi crosoft.com...

Right after you bind the dataview, do the following:

dataview.Sort = "Titles ASC, Directors ASC"

"Jason" wrote:

> Is it possible to somehow sort a dataview, all on one column, but on
> different variables?
>
> That is, I have a 'Title' column in my dataview and I'd like to display
> first all "Directors" (sorted), then everyone else (sorted). I've usedthe > 'ItemBound' but can't figure out how to do this with that procedure.
>
> Thanks in advance, any ideas are appreciated.
>
> Jason
>
> eg of what I'm looking for:
>
> Name Title
> ===== ======
> George Director
> Yvonne Director
> Harry Programmer
> Larry Research Officer
> Wilbur Secretary
>
>
>
>
>

[Shailesh Jannu]

I guess it has to be

DGADResults.Dat aSource = dvCustom
dvCustom.Sort = "title ASC, Name ASC"
DGADResults.Dat aBind()
"Jason" wrote:

Unfortunately, I get:

Exception Details: System.IndexOut OfRangeExceptio n: Cannot find column
Director.

Source Error:

Line 197:
Line 198: DGADResults.Dat aSource = dvCustom
Line 199: dvCustom.Sort = "title ASC, Director ASC"
Line 200: DGADResults.Dat aBind()
Line 201: End Sub
thoughts?
"Matt Hamilton" <Ma**********@d iscussions.micr osoft.com> wrote in message
news:76******** *************** ***********@mic rosoft.com...

Right after you bind the dataview, do the following:

dataview.Sort = "Titles ASC, Directors ASC"

"Jason" wrote:

Is it possible to somehow sort a dataview, all on one column, but on
different variables?

That is, I have a 'Title' column in my dataview and I'd like to display
first all "Directors" (sorted), then everyone else (sorted). I've used the 'ItemBound' but can't figure out how to do this with that procedure.

Thanks in advance, any ideas are appreciated.

Jason

eg of what I'm looking for:

Name Title
===== ======
George Director
Yvonne Director
Harry Programmer
Larry Research Officer
Wilbur Secretary

[Jason]

First off, thanks to everyone who's responded, I think we're almost there:

Alright, so I've sorted dataviews before by a column name like this without
a problem. What I'm trying to get however is a sorted list of all rows
whose column 'title' has a value of "Director" -THEN- list the rest of the
rows in normal sorted order.

That is, just as in my example below, although Yvonne and George should not
be at the top of the list because their names fall alphabetically below
'Barry', because they have a title='Director ' value, I would like them to be
on the top of the list first. Following all of these Directors, Barry,
Larry, and Wilbur are sorted normally.

Name Title
===== ======
George Director
Yvonne Director
Barry Programmer
Larry Research Officer
Wilbur Secretary

dataview.Sort = "Title ASC" won't cut it, nor would dvCustom.Sort = "title
ASC, Name ASC" because my data could contain a title='Associat e something'
that would take the top spot instead of any "Director".

"Scott Allen" <bitmask@[nospam].fred.net> wrote in message
news:uh******** *************** *********@4ax.c om...

Jason:

You don't have a column named "Director". Change the Sort to only use
columns you do have, like Title and Name.

dataview.Sort = "Title ASC"

--
Scott
http://www.OdeToCode.com

On Wed, 1 Sep 2004 16:50:33 -0600, "Jason" <ja***@grossman s.net>
wrote:

Unfortunatel y, I get:

Exception Details: System.IndexOut OfRangeExceptio n: Cannot find column
Director.

Source Error:

Line 197:
Line 198: DGADResults.Dat aSource = dvCustom
Line 199: dvCustom.Sort = "title ASC, Director ASC"
Line 200: DGADResults.Dat aBind()
Line 201: End Sub
thoughts?
"Matt Hamilton" <Ma**********@d iscussions.micr osoft.com> wrote in message
news:76******* *************** ************@mi crosoft.com...

Right after you bind the dataview, do the following:

dataview.Sort = "Titles ASC, Directors ASC"

"Jason" wrote:

> Is it possible to somehow sort a dataview, all on one column, but on
> different variables?
>
> That is, I have a 'Title' column in my dataview and I'd like to display > first all "Directors" (sorted), then everyone else (sorted). I've

usedthe

> 'ItemBound' but can't figure out how to do this with that procedure.
>
> Thanks in advance, any ideas are appreciated.
>
> Jason
>
> eg of what I'm looking for:
>
> Name Title
> ===== ======
> George Director
> Yvonne Director
> Harry Programmer
> Larry Research Officer
> Wilbur Secretary
>
>
>
>
>

[Scott Allen]

Ah, thats a bit tricker. There is no built in way to do this easily
but here is something to try...

Add an additional column to the underlying DataTable. When the Title
is Director, set the value of this column to 1, when the Title is not
a director, set the value to 2. Then you could use a Sort expression
like:

dv.Sort = "SortColumn ASC, Name ASC";

The additional column could be a computed column. Add the column
programatically :

dataTable.Colum ns.Add("SortCol umn", typeof(int), expr);

Where expr is an expression like:

"IIF(Title='Dir ector', 1, 2)"
HTH,

--
Scott
http://www.OdeToCode.com

On Thu, 2 Sep 2004 08:04:51 -0600, "Jason" <ja***@grossman s.net>
wrote:

First off, thanks to everyone who's responded, I think we're almost there:

Alright, so I've sorted dataviews before by a column name like this without
a problem. What I'm trying to get however is a sorted list of all rows
whose column 'title' has a value of "Director" -THEN- list the rest of the
rows in normal sorted order.

That is, just as in my example below, although Yvonne and George should not
be at the top of the list because their names fall alphabetically below
'Barry', because they have a title='Director ' value, I would like them to be
on the top of the list first. Following all of these Directors, Barry,
Larry, and Wilbur are sorted normally.

Name Title
===== ======
George Director
Yvonne Director
Barry Programmer
Larry Research Officer
Wilbur Secretary

dataview.Sor t = "Title ASC" won't cut it, nor would dvCustom.Sort = "title
ASC, Name ASC" because my data could contain a title='Associat e something'
that would take the top spot instead of any "Director".

"Scott Allen" <bitmask@[nospam].fred.net> wrote in message
news:uh******* *************** **********@4ax. com...

Jason:

You don't have a column named "Director". Change the Sort to only use
columns you do have, like Title and Name.

dataview.Sort = "Title ASC"

--
Scott
http://www.OdeToCode.com

On Wed, 1 Sep 2004 16:50:33 -0600, "Jason" <ja***@grossman s.net>
wrote:

>Unfortunatel y, I get:
>
>Exception Details: System.IndexOut OfRangeExceptio n: Cannot find column
>Director.
>
>Source Error:
>
>Line 197:
>Line 198: DGADResults.Dat aSource = dvCustom
>Line 199: dvCustom.Sort = "title ASC, Director ASC"
>Line 200: DGADResults.Dat aBind()
>Line 201: End Sub
>
>
>thoughts?
>
>
>"Matt Hamilton" <Ma**********@d iscussions.micr osoft.com> wrote in message
>news:76******* *************** ************@mi crosoft.com...
>> Right after you bind the dataview, do the following:
>>
>> dataview.Sort = "Titles ASC, Directors ASC"
>>
>> "Jason" wrote:
>>
>> > Is it possible to somehow sort a dataview, all on one column, but on
>> > different variables?
>> >
>> > That is, I have a 'Title' column in my dataview and I'd like todisplay >> > first all "Directors" (sorted), then everyone else (sorted). I'veused >the
>> > 'ItemBound' but can't figure out how to do this with that procedure.
>> >
>> > Thanks in advance, any ideas are appreciated.
>> >
>> > Jason
>> >
>> > eg of what I'm looking for:
>> >
>> > Name Title
>> > ===== ======
>> > George Director
>> > Yvonne Director
>> > Harry Programmer
>> > Larry Research Officer
>> > Wilbur Secretary
>> >
>> >
>> >
>> >
>> >
>

[Jason]

Good idea, I'll give that a whirl and it should suit my needs just fine.

Thanks alot!

Jay

"Scott Allen" <bitmask@[nospam].fred.net> wrote in message
news:ai******** *************** *********@4ax.c om...

Ah, thats a bit tricker. There is no built in way to do this easily
but here is something to try...

Add an additional column to the underlying DataTable. When the Title
is Director, set the value of this column to 1, when the Title is not
a director, set the value to 2. Then you could use a Sort expression
like:

dv.Sort = "SortColumn ASC, Name ASC";

The additional column could be a computed column. Add the column
programatically :

dataTable.Colum ns.Add("SortCol umn", typeof(int), expr);

Where expr is an expression like:

"IIF(Title='Dir ector', 1, 2)"
HTH,

--
Scott
http://www.OdeToCode.com

On Thu, 2 Sep 2004 08:04:51 -0600, "Jason" <ja***@grossman s.net>
wrote:

First off, thanks to everyone who's responded, I think we're almost there:
Alright, so I've sorted dataviews before by a column name like this withouta problem. What I'm trying to get however is a sorted list of all rows
whose column 'title' has a value of "Director" -THEN- list the rest of therows in normal sorted order.

That is, just as in my example below, although Yvonne and George should notbe at the top of the list because their names fall alphabetically below
'Barry', because they have a title='Director ' value, I would like them to beon the top of the list first. Following all of these Directors, Barry,
Larry, and Wilbur are sorted normally.

Name Title
===== ======
George Director
Yvonne Director
Barry Programmer
Larry Research Officer
Wilbur Secretary

dataview.Sor t = "Title ASC" won't cut it, nor would dvCustom.Sort = "titleASC, Name ASC" because my data could contain a title='Associat e something'that would take the top spot instead of any "Director".

"Scott Allen" <bitmask@[nospam].fred.net> wrote in message
news:uh******* *************** **********@4ax. com...

Jason:

You don't have a column named "Director". Change the Sort to only use
columns you do have, like Title and Name.

dataview.Sort = "Title ASC"

--
Scott
http://www.OdeToCode.com

On Wed, 1 Sep 2004 16:50:33 -0600, "Jason" <ja***@grossman s.net>
wrote:

>Unfortunatel y, I get:
>
>Exception Details: System.IndexOut OfRangeExceptio n: Cannot find column
>Director.
>
>Source Error:
>
>Line 197:
>Line 198: DGADResults.Dat aSource = dvCustom
>Line 199: dvCustom.Sort = "title ASC, Director ASC"
>Line 200: DGADResults.Dat aBind()
>Line 201: End Sub
>
>
>thoughts?
>
>
>"Matt Hamilton" <Ma**********@d iscussions.micr osoft.com> wrote in message >news:76******* *************** ************@mi crosoft.com...
>> Right after you bind the dataview, do the following:
>>
>> dataview.Sort = "Titles ASC, Directors ASC"
>>
>> "Jason" wrote:
>>
>> > Is it possible to somehow sort a dataview, all on one column, but on >> > different variables?
>> >
>> > That is, I have a 'Title' column in my dataview and I'd like to

display

>> > first all "Directors" (sorted), then everyone else (sorted). I've

used

>the
>> > 'ItemBound' but can't figure out how to do this with that procedure. >> >
>> > Thanks in advance, any ideas are appreciated.
>> >
>> > Jason
>> >
>> > eg of what I'm looking for:
>> >
>> > Name Title
>> > ===== ======
>> > George Director
>> > Yvonne Director
>> > Harry Programmer
>> > Larry Research Officer
>> > Wilbur Secretary
>> >
>> >
>> >
>> >
>> >
>