Handling a large ADODB record set in data table?

• blasto_max

  SSCertifiable

  Points: 5025

  More actions

  November 11, 2013 at 5:53 pm

  #301083

  I am loading a large result set into a data table. Its taking too long to even load the result set into a data table. I want to find out a way of extracting only part of a result set and then loading it into a DataTable. Is there a way to do this ?

  This is the code I use to fill my DataTable -

  OleDbDataAdapter oleDA = new OleDbDataAdapter();

  DataTable dt = new DataTable();

  oleDA.Fill(dt, myADODBRecordset);