<div>
try this<br />
<br />
Dim PersonListArray() As Long &nbsp; &nbsp;instead of Dim PersonListArray As Long()
</div>


try this

Dim PersonListArray() As Long    instead of Dim PersonListArray As Long()

<div>
I converted the value being return being returned from the DB from int to bigint and my code works fine now.
</div>


I converted the value being return being returned from the DB from int to bigint and my code works fine now.

<div>
<div class="content wysiwyg-content">
I am trying to put the id returned in a datareader into an array of long<br />
values then put that array in a session. But I am getting this error from my<br />
block. I want to ask if anyone could point out why I might be getting this<br />
error.<br />
<br />
Error<br />
At least one element in the source array could not be cast down to the<br />
destination array type.<br />
<br />
&lt;code&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim PersonList As New ArrayList<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim PersonListArray As Long()<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Do While drPerson.Read()<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PersonList.Add(drPerson(&quot;P<wbr />ersonid&quot;))<wbr /><br />
&nbsp; &nbsp; &nbsp; &nbsp; Loop<br />
&nbsp; &nbsp; &nbsp; &nbsp; PersonListArray = PersonList.ToArray(GetType<wbr />(Long)) &lt;== Error<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; If TypeOf drPerson Is DBNull Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.Item(&quot;lngPersomid&quot;<wbr />) = 0<br />
&nbsp; &nbsp; &nbsp; &nbsp; Else<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.Item(&quot;lngPersomid&quot;<wbr />) = CType(PersonListArray, Long())<br />
&nbsp; &nbsp; &nbsp; &nbsp; End If<br />
&lt;/code&gt;<br />

</div>
</div>


I am trying to put the id returned in a datareader into an array of long
values then put that array in a session. But I am getting this error from my
block. I want to ask if anyone could point out why I might be getting this
error.

Error
At least one element in the source array could not be cast down to the
destination array type.

<code>
        Dim PersonList As New ArrayList
        Dim PersonListArray As Long()

        Do While drPerson.Read()
            PersonList.Add(drPerson("Personid"))
        Loop
        PersonListArray = PersonList.ToArray(GetType(Long)) <== Error

        If TypeOf drPerson Is DBNull Then
            Session.Item("lngPersomid") = 0
        Else
            Session.Item("lngPersomid") = CType(PersonListArray, Long())
        End If
</code>


Array of long values

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.