I want to arrange numbers from highes to lowest ( you will input the numbers first e.g 1,2,3,4,5 ) and it will be 5,4,3,2,1

Thanks!

Recommended Answers

All 6 Replies

Sounds like homework. What have you got so far?

"Visual Basic 2010"

I do have a similar problem,

I want to display on a listview a "top 10" highest to lowest data using MySQL as database,

my problem is, I dont know the codes for displaying data sorted from highest to lowest.

Anyone?
Please help me.
I am not a super genius type programmer... and sorry for my bad grammar ...

Use the ORDER BY clause with DESC when you do the SELECT.

To short numbers in descending order, you can use the following codes, if you like.

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
        Dim x(9) As Integer

        For i As Integer = 0 To x.GetUpperBound(0)
            x(i) = i + 1
        Next

        Dim y As Integer = 0

        For k As Integer = 0 To (x.GetUpperBound(0) - 1)
            For l As Integer = 0 To (x.GetUpperBound(0) - 1)
                If x(l) < x(l + 1) Then
                    y = x(l)
                    x(l) = x(l + 1)
                    x(l + 1) = y
                End If
            Next
        Next

        For i As Integer = 0 To x.GetUpperBound(0)
            ListBox1.Items.Add(x(i))
        Next
    End Sub

Jim is true. You can use Order By clause with DESC in your Select statement.

Further more, if you do not use this, you can try the above codes, if you like.
For that you can first pick up the numbers from your data table in an array.

thanks to everyone .. yup .. i made it .. sorry for the late response, I owe you all guys a big thanks ^^, .. Thank you !!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.