Make array from Database

[ad]

I select a single field from a table of database, like:
Select distinct EmployeeID from Employee.

Have there any convenient to throw the result of select items into a static
array?
or I must iterate throw the select result to add selected item into a
dynamic array?

 

[Morten Wennevik]

Hi ad,

I'm afraid you must iterate. You could either use an ArrayList and, if needed, use its ToArray method, or create an array based on row count.