I'd like to learn how to take data returned from a sql statement and put it into an array.  I've used an array before, but I knew the values and they were hard coded like in the sample below.  Any pointers on how to take data from a sql reader and dump to an arrary when you don't know the hard coded values? 
 
Dim arrangExceptions() As Integer = {6, 16, 17, 18, 19, 20, 21} For x = 0 To arrangExceptions.GetUpperBound(0) If ArrangementID.SelectedValue = arrangExceptions(x) Then Details.Enabled = True Exit For End If Next
...

Go to the complete details ...