array of arrays visual basic

Question

I'm developing a module for capture Attlogs from a ZKSoftware Fingerprint Biometric and send it to MySQL database using the SDK that came with the CD, so far I manage to connect successfully to the clock, display the logs on a listview, but I got stuck pushing the values on a multidimensional array, i'm sure it's a matter of declaration but I better ask for help... the code is as follows:

Dim thisLog(1) As String
Dim allLogs()() As String = New String()() {}

afterwards where the iteration (i) load the Attlogs in the listview I got:

            thisLog = {sdwEnrollNumber, idwYear.ToString() & "-" + idwMonth.ToString() & "-" & idwDay.ToString() & " " & idwHour.ToString() & ":" & idwMinute.ToString() & ":" & idwSecond.ToString()}
            allLogs(i) = {thisLog(0), thisLog(1)}

The error I'm getting is related to the size of the array, so the question can be resumed in how can I create a rectangular array (2)(n) with every row of the captured data. Thanks in advance

From the looks for this, you really want a List(Of String), List(Of String()), or List(Of List(Of String)) instead of String()(). — Joel Coehoorn
– Joel Coehoorn, Commented Mar 25, 2015 at 14:57

the_lotus · Accepted Answer · 2015-03-25 15:20:56Z

I would highly suggest you create a class to store the data in. Have a List(Of LogEntry) afterward. This would make your code a lot easier to read.

Class LogEntry

    Public Property EnrollNumber As String
    Public Property EntryDate As DateTime

    Public Sub New(ByVal enrollNumber As String, ByVal entryDate As DateTime)

        Me.EnrollNumber = enrollNumber
        Me.EntryDate = entryDate

    End Sub

End Class

For adding a new record, you just need to create an instance of that class and add it to the list.

    Dim allLogs As New List(Of LogEntry)

    allLogs.Add(New LogEntry(sdwEnrollNumber, New DateTime(idwYear, idwMonth, idwDay, idwHour, idwMinute, idwSecond)))

Since you'll now have a valid date instead of a concatenation of string, it'll be easy to do manipulation afterward.

    Console.WriteLine(allLogs(0).EnrollNumber)
    Console.WriteLine(allLogs(0).EntryDate.ToString("yyyy-MM-dd HH:mm:ss"))

Joel Coehoorn · Accepted Answer · 2015-03-25 15:06:51Z

1

how can I create a rectangular array (2)(n) with every row of the captured data?

Use a List:

Dim allLogs As New List(Of String())()

allLogs.Add(New String(1) {sdwEnrollNumber, _
     String.Format("{0}-{1}-{2} {3}:{4}:{5}", _
     idwYear, idwMonth, idwDay, idwHour, idwMinute, idwSecond)} )

I might also use the appropriate DateTime constructor and format string to format that 2nd part, depending on how you get those idw variables in the first place.

edited Mar 25, 2015 at 15:06

answered Mar 25, 2015 at 15:01

Joel Coehoorn

418k114 gold badges582 silver badges820 bronze badges

1 Comment

Alvaro Ramirez Over a year ago

thanks, I will format the DateTime this way, the idw variables comes from the SDK function libs, each one is declared as Integer

Collectives™ on Stack Overflow

array of arrays visual basic

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related