Solved

Dataview sort

Posted on 2014-02-09
3
449 Views
Last Modified: 2014-02-09
Hi all,

I am currently sorting my dataview but     DvTheData.Sort = "Time DESC"

But i need to sort it so it runs up in number format but with adding HT and FT like so...

1,2,3,4,5,6,7,8,9,10,11......43,44,45,HT,46,47....,87,88,89,90,FT

anyone able to shine any light on how this could be done>
0
Comment
Question by:runnerjp2005
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
ID: 39845660
Add a String column to your table, and copy the value from the Time column into that new column, with the following rules:

- If the value is less than 10, copy "0" & value
- If the value is HT, copy as 45A
- If the value is FT, copy as 99
- Otherwise, copy the value as is

If you prefer, add a Single column and do the copy with the following rules:

- If the value is numeric, copy it has is
- If the value is HT, copy as 45.5
- If the value is FT, copy as 99

Sort your DataView on that column and the Time will show in the order you want it.
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 39845693
0
 

Author Closing Comment

by:runnerjp2005
ID: 39845914
works treat thanks
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question