How Do I sort data coming from database at the time of binding

Question

0.00/5 (No votes)

See more:

ASP.NET

<asp:Label CssClass="block" runat="server" ID="lblSectorFrom" 
Text='<%# DataBinder.Eval(Container.DataItem, "(dep_apt_id)") %>'
ToolTip='<%# DataBinder.Eval(Container.DataItem, "(dep_apt_name)") %>' /
>

   <asp:Repeater ID="repSector" runat="server" DataSource='<%# CType(Container.DataItem,System.Data.DataRowView).Row.GetChildRows("Booking_Part_TO_Sector_FK") %>' >
 <ItemTemplate>
   <asp:Label ID="Label6" CssClass="block" Text='<%# String.Format("{0:dd-MMM-yyyy}", DataBinder.Eval(Container.DataItem, "(dep_datetime)"))%>'
 runat="server" meta:resourcekey="Label6ResourceKey" />
 </ItemTemplate>

Deparure date    from    To 
26june 2015      LHR     LAX
26june 2015      LAX     AKL
03july 2015      LAX     LHR
03july 2015      AKL     LAX

Sorting is happening acc to dep_datetime
It is sorting in incorrect manner because in the database
it is storing values in this format order only but i want to sort it at the time of binding. the correct itineraries should be

LHr-LAX
LAX-AKL

AKL-LAX
LAX-LHR

it will be great help if anyone knows about this.

Posted 23-Jul-15 21:47pm

Member 11491784

Updated 23-Jul-15 22:13pm

v4

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-07-23T21:51:00

Solution 1

I guess the easiest way is to sort the data when fetching it from the database using an ORDER BY clause[^].

Other option is to sort the data already fetched but in order to do that we'd need to know in what kind of structure the data is stored in your program. Is it in data tables, POCO's and so on.

Posted 23-Jul-15 21:51pm

Wendelius

Comments

Member 11491784 24-Jul-15 3:54am

its in the form of data tables

Wendelius 24-Jul-15 3:57am

Then you can use the data view's ability to sort the content of your data table. See DataView.Sort[^]

Sanket Saxena · Answer 2 · 2015-07-23T22:21:00

Solution 2

Simply dataview will work.
see the link:
dataview sort
Hope it helps :)

Posted 23-Jul-15 22:21pm

Sanket Saxena

Comments

Member 11491784 24-Jul-15 5:16am

Is there any way to do it on HTML side only?