Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sorting multiple fields in one column
Message
From
24/04/2007 12:30:22
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
01219371
Message ID:
01219406
Views:
8
>Hello,
>We need to sort on an address column in a GridView, but not by street number, street name. We have 3 fields. One for street number, another for street direction and the third is street name. We wish to sort by street name then by street number numerically and then concatenate these fields so that they form the address field as in: street number, street direction, street name. We wish this to form the address field so that we can use it as a hyperlink.
>
>Alternatively we have the original address field from which these fields were derived, but it would still need to be sorted by street number (numerically), street direction, then street name.
>As in:
>254 Patterson Street
>9 East Texas Street
>211 East Texas Street
>
>If there is no possible answer to this, but it would be possible in another control, we would be open to that, but the address, either the original or a concatenation of three fields, must be a hyperlink.
>Thank you.

You can use SortExpression with comma separated list of columns.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform