Results 1 to 3 of 3

Thread: Using Fill Method To Load Data In Pages/Chunks

  1. #1

    Thread Starter
    Lively Member
    Join Date
    May 2017
    Posts
    125

    Using Fill Method To Load Data In Pages/Chunks

    Hi Guys

    Is it possible to use the fill method to load data in Pages? In other words break the data up into chucks and page back and forth? I am unable to load all my data at once because it throws an out of memory exception, so I need to find a way to load my data in manageable size chucks but I would still like to be able to move through the data as if it were all loaded at the same time.

  2. #2
    You don't want to know.
    Join Date
    Aug 2010
    Posts
    4,578

    Re: Using Fill Method To Load Data In Pages/Chunks

    Looks like there are two ways, the most efficient being "write your SQL query so it only returns the records you want, and modify it as you change pages".
    This answer is wrong. You should be using TableAdapter and Dictionaries instead.

  3. #3

    Thread Starter
    Lively Member
    Join Date
    May 2017
    Posts
    125

    Re: Using Fill Method To Load Data In Pages/Chunks

    It's not a question of which records I want. I want them all. This is a data import and every record will have to be edited.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width