none
How to paging for dataset RRS feed

  • Question

  • Hi, Guys,

    I am using Oledbconnection, OleDataAdapter and dataset to access the data of Oracle database.

    And I am facing a very big table (for example, more than 10 mill records, when I use the 

    dataset.fill method, I got the error message outofmemory.

    If I used dataset.fill(startRecord, maxrecords, datatable) method, I got the error as:

    [System.Data.OleDb.OleDbException] = {"ORA-00936: miss \r\nORA-00936: miss"}

    Does somebody have any ideas on it?

    Thanks.

    Jeffers

    Monday, November 27, 2017 10:55 AM

All replies