DataTable.Load Method (IDataReader) Failure

[paulgenga]

Dear Friend,
This method of filling data tables worked perfectly until now...

For one particular SQL Statement, it returns only one Row (The last Row) omitting all the others. i.e. 1/10

Sub FillTable(ByVal strSQL As String, ByVal dt As DataTable)
Using reader As System.Data.Common.DbDataReader = SQLReader(strSQL)
   dt.Load(reader)
End Using

Please note --SQLReader(strSQL)-- returns DbDataReader[/color red]

The method below loops thru all the records including the omitted...

Using reader As System.Data.Common.DbDataReader = SQLReader(strSQL)
Do While reader.Read
...
Loop

Please advice me, what is wrong with the Method

Thanks
Paul

:-|Bob