Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sorting multiple fields in one column
Message
De
24/04/2007 12:30:22
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Divers
Thread ID:
01219371
Message ID:
01219406
Vues:
9
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform