I am trouble in sorting 2 dimensions array in vb.net. One row has 5 columns. Original array have 3000 rows. How can I get the effective sorting with pdtId. I tried to find googling, cannot get the right answer to me.
(0, 0) = pdtId "string"
(0, 1) = brand name
(0, 2) = category Id
(0, 3) = url
(0, 4) = date
(1, 0) = pdtId "string"
(1, 1) = brand name
(1, 2) = category Id
(1, 3) = url
(1, 4) = date
. . 3000 rows anyone could you able to help me, big trouble, :(
Don't use a twodimensional array, or an array of arrays. Better create a class for your five fields and put objects of that class into a onedimensional array:
Public Class MyData
Implements IComparable(Of MyData)
Public pdtId As String
Public brand_name As String
Public category_Id As String
Public url As String
Public theDate As Date
Public Overloads Function CompareTo(ByVal obj As MyData) As Integer _
Implements IComparable(Of MyData).CompareTo
Return pdtId.CompareTo(obj.pdtId)
End Function
End Class
Sub Main()
Dim myArray(3000) As MyData
' Code to fill the array
' ...
Array.Sort(myArray)
End Sub
You should really be using an array of arrays here - multidimensional arrays are only intended for when the number 'columns' (2nd index) is different between rows (1st index).
If you make this instead an array or arrays, using Array.Sort to solve the problem become really easy.
