how to store sql query value into array
===

    Dim sql As String = "Select ProductID From OrderDetail Order By ProductID Desc"
        Dim command As New SqlCommand(sql, connection)
        Dim reader1 As SqlDataReader = command.ExecuteReader()
    
How do i store all the productid that i have retrieve into an array?