Copy large data from one dataset to another dataset

  • Thread starter Thread starter mina
  • Start date Start date
M

mina

hello,

Problem 1
Suppose i have dataset named as dsLoad which contains rows greater
than 10 lacs. now i want to copy dsload to dsBeforeFilter. For that i
have use command dsBeforeFilter=dsload.copy.
when i am trying to copy such large data i got error
system.outofmemoryexception.
Problem 2
For copy same dataset if i am using command use like
dsBeforeFilter=dsload
and then if i am using filter on dsBeforeFilter.Tables
(0).DefaultView.RowFilter="name='ABC'" then i works but it also filter
data from my orginal dataset i.e.dsload


Can Any one help me.....
 
Well it seems you are clearly running out of memory. Why are you doing the
copy? Why not just use a DataView off of the DataSet or DataTable if you just
need to filter?

David

======================================
David McCarter [Microsoft MVP]
www.dotNetTips.com
David McCarter''''s .NET Coding Standards available at:
http://codingstandards.notlong.com
 
Back
Top