Solved

VB.NET Datatable -> how to sort??

Posted on 2014-02-05
7
451 Views
Last Modified: 2014-02-10
Hi guys....

I currently Display what's in my Datatable like this

 Dim DvTheData As New DataView(scorestable)
		
	   For Each dv As DataRowView In DvTheData
    test.Text += dv.row.Item("Score")
Next

Open in new window


Is it possible to sort the results by the column "Time".

The time is sorted by numbers ranging from 0-90
but it also has two letter values which are HT and FT (These are football time)

So i need to be abl to sort it from 0-45 ~ HT~ 46-90 ~ FT ... end result would look like:

1
5
16
35
45
HT
HT
46
49
67
89
FT
0
Comment
Question by:runnerjp2005
  • 4
  • 3
7 Comments
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 39835933
Yes, with a little work.  Are the numbers stored as numbers (eg. integer) or as strings.  Where do the HT and FT come from IF the others are stored as numbers?

What are the other columns in the underlying table (eg an incrementing primary key) ?
0
 

Author Comment

by:runnerjp2005
ID: 39836016
Hi.... its stored at sting due to having the Numbers AND Letters in it...

Table is setout like so:

scorestable = new datatable
	
	scorestable.Columns.Add("HomeTeam", GetType(String))
	scorestable.Columns.Add("Time", GetType(String))
	scorestable.Columns.Add("Score", GetType(String))
	scorestable.Columns.Add("Lastgoaltime", GetType(String))
	scorestable.Columns.Add("FTtime", GetType(String))

Open in new window


scorestable.Columns.Add("Time", GetType(String)) being the one i would like to order by
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 39836522
>>scorestable.Columns.Add("Time", GetType(String)) being the one i would like to order by

OK but is the Lastgoaltime going to give the same sort order and wouldn't require further processing ?
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

Author Comment

by:runnerjp2005
ID: 39837075
no thats just filled if the score is over 0-0 to let me know when a goal has been scored...

everything will be up in order by Time...

here is the site:http://jarrattperkins.com/football/test.aspx

should show you how it would be orderd
0
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 39838092
OK, no simple way that I see from that info.

If this is in development and you can implement changes I would suggest adding another column to the underlying table as a primary key which increments.  Then you can sort on that column as it will sort in the order the records were added (chronologically I assume).

If that isn't a possibility then I would suggest creating a second datatable with the same structure.
Now loop through the source datatable and find the earliest record (eg. 1 in your example) and add a copy into the second datatable, now delete that record in the source datatable.  Keep repeating until you have transfered all records into the second datatable with the ordering you desire.
0
 

Author Comment

by:runnerjp2005
ID: 39838191
The datatable is created on page load so it will have a bunch of them loaded together with different times and would be mixed up. I suppose I could create four labors 0-45 lable ht-label and 45-90 lable ending on ft label...with doing that how would I pull all ones between 0-45 and order by number
0
 
LVL 44

Accepted Solution

by:
AndyAinscow earned 500 total points
ID: 39838239
Convert the string to a number value and then use a simple '<' to test.

(I'm still a little puzzled about things in the background, unless this is randomly generated it must be coming from something such as a database or a file.  I am surprised there isn't somewhere a piece of information one could use to simply sort that data.)
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
daypilot scheduler 3 26
How can my static class become undefined?? 8 47
List<PaisEntity> - show some 1 22
Problem with SelectList in .NET MVC application 1 11
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

815 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now