DataAdapter Fill method

  • Thread starter Thread starter calvin
  • Start date Start date
C

calvin

I was wondering,
does the dataadapter populates the whole DataSet objects with all the rows
retrieved from the Select Command (eg.SELECT * FROM Customer) . Means, will
this
slow down the process if there is 10,000 records or more.
 
Sure, since a DataSet contains DataTables that are copies of the original
data. More data = more time to make and move the copy. DataAdapters also
have a FillSchema method that just creates an empty table with all the table
mappings in place for those times when you just might be adding data and not
want to get a copy of the original.
 
Hi calvin,

Just a note that there is also an overloaded Fill method that takes first
row and row count as an argument.
 
thanks,

by knowing this issue, i did an empty selection of records in the table,
to INSERT a new row. It works...
 
Back
Top