[help]add number for ranking in listbox [emergency!]

[jmcilhinney]

i mean it is from a array and then i put it in a listbox for sorting.sorry

If it's an array then there's no SQL code but you can just load the data into any control you want. You could load it into a ListView or DataGridView manually or you could load it into another appropriate data structure and bind it to a DataGridView, e.g.

myDataGridView.DataSource = Enumerable.Range(1, myArray.Length).
                                       Select(Function(n) New With {.Rank = n, .Name = myArray(n - 1)}).
                                       ToArray()

That creates an array of objects that each have Rank and Name properties and binds it to a DataGridView, which will then display those properties in two separate columns.