DataAdapter Fill method

[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.

 

[Guest]

Hi

Yes, the performance will be hit.
to find where to use DataSets, please check the following urls
http://objectsharp.com/Blogs/datasetfaq/archive/2004/05/20/468.aspx
http://www.fawcette.com/vsm/2004_03/magazine/columns/databasedesign/

 

[Scott M.]

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.

 

[Miha Markic [MVP C#]]

Hi calvin,

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

 

[calvin]

thanks,

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