I've got the book .Net 2.0 Generics, when I tried the following code from page 97, I receive a casting error message:


Public Function GetItems(Of T)(ByVal sql As String) As Collection(Of T)
        Dim selectCmd As New OleDbCommand(sql, dbConn)
        Dim retVal As New Collection(Of T)
        Dim dataReader As OleDbDataReader = selectCmd.ExecuteReader()
        While (dataReader.Read() = True)
            retVal.Add(DirectCast(dataReader(0), T))
        End While

        Return retVal
    End Function

I keep on getting an error:

Message="Unable to cast object of type 'System.Int32' to type 'Architecture.Employees'." What am i doing wrong?




FREDYCOREA

Hey,

What are you passing into the T parameter? Are you passing Integer, or Employees object? How are you using this method? That will give some insight.

Thanks.

Brian