VB Code:
  1. 'not tested but it should :D work (too lazy to make a mockup of ur MyReader)
  2.  
  3.         Dim colCustomers As Collection
  4.         Dim strArray(9) As String
  5.         'Dim CusArray(0, 9)
  6.  
  7.         While MyReader.Read
  8.  
  9.             strArray(0) = MyReader("CustomerId")
  10.             strArray(1) = MyReader("FullName")
  11.             strArray(2) = MyReader("Company")
  12.             strArray(3) = MyReader("BillingBuilding")
  13.             strArray(4) = MyReader("BillingStreet")
  14.             strArray(5) = MyReader("BillingStreet2")
  15.             strArray(6) = MyReader("BillingTown")
  16.             strArray(7) = MyReader("BillingCounty")
  17.             strArray(8) = MyReader("BillingPostCode")
  18.             strArray(9) = MyReader("BillingCountry")
  19.  
  20.             'Add To Collection
  21.             colCustomers.Add(strArray)
  22.         End While
  23.  
  24.         'Now Im guessing that you really need the data in a
  25.         'multi-dimetimetion array
  26.  
  27.         Dim cusArray(colCustomers.Count - 1, 9)
  28.  
  29.         Dim I As Integer
  30.         Dim X As Integer
  31.  
  32.         For I = 0 To colCustomers.Count - 1
  33.             For X = 0 To 9
  34.                 strArray = colCustomers.Item(I + 1)
  35.                 cusArray(I, X) = strArray(X)
  36.             Next
  37.         Next