Hello, Im having a problem regarding on Array List.
I need to create an Array that gets information,
What inside the List are EmployeeID, LastName and FirstName
I need to store all EmployeeID,LastName and FirstName.
How can i do that?
Please Help, thanks in advance. :)
Jump to PostYou could create your own class with properties named EmployeeID, LastName and FirstName and create a new list of the new class type or you could use a detached recordset. You could likely also create a database in memory as well using more modern techniques involving datasets/datatables, etc but …
You could create your own class with properties named EmployeeID, LastName and FirstName and create a new list of the new class type or you could use a detached recordset. You could likely also create a database in memory as well using more modern techniques involving datasets/datatables, etc but I am not familiar enough with those to offer suggestions.
You could also create your own type using structure, and create an array of that type
How? i dont know how to create a multiple array. help me.
i know how to create a list of array
here is my existing code.
dim myList as New List(Of String)
selectquery = "SELECT EmployeeID FROM Employees"
cmd = New Oledbcommand(selectquery, con)
dr = cmd.ExecuteReader()
if dr.HasRows Then
While dr.Read
myList.Add(dr(0))
End While
End If
now, i dont know how can i add the First name and Last name in my List
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.