Hi Folks,
I am having a problem reading an existing typed datatable. I am sure that I 
have over looked something simple but I am not seeing the forest for the 
trees. I am using the below code and the reader does not pickup any rows.

    Private MyDataSet As SomeDataSet
    Private MyDataTable As SomeDataSet.SomeDataTable
    
'The WhereClause is just date range SomeColumnDateValue >= #9/9/1999# AND 
SomeColumnDateValue <= #9/10/1999#
Private Function MyGetData(ByVal MyWhereClaus As String) As ArrayList
        
        'Configure and execute datareader
        Dim MyDataTable As New DataTable

        MyDataSet = New SomeDataSet
        MyDataTable = New SomeDataSet.SomeDataTable
        
        Dim MyArrayList As New ArrayList
        'Dim MyDataTable As New DataTable
        
        'I have tried both the table linkages
         MyDataTable = New SomeDataSet.SomeDataTable
        'or
         MyDataTable = MyDataSet.Tables("DataTableName")
        
        Dim MyExpression As String = MyWhereClaus
        Dim MySortOrder As String = Me.OptionSelection & " DESC"
        'The OptionSelection is SomeColumnName

       MyDataTable.Select(MyExpression, MySortOrder)
       Dim MyDataTableReader As New DataTableReader(MyDataTable)

I get a null result (0 rows) with the correct schema, it does not matter 
wether
I use the filter assignment or not.

Any help is appreciated