G
Guest
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
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