SqlDataAdapter are essentially objects running under the web server
thread(s) and they use a relatively small footprint of memory when you
compare them to other objects like DataSets or SqlCommand, so the benefit of
reducing their number is near zero.
It's the same question as asking « I am better creating 20 distinct
variables or creating only 10 variables and reusing some of them for double
usages ? »
Beginners will often choose the second option - in the false hope of saving
memory - while more experienced programmers will go directly for the first.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail:
http://cerbermail.com/?QugbLEWINF
<jj****@hotmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
Hi All,
I am creating a web app and on one form I am using multiple
SqlDataAdapters which I dont think from a design stand point I should
be doing, correct? Can I only use one and change the sqlcommands
associated with the sqldataadapter to point to other sp's that I have
created in Sql server? I guess I would have to have the datasets that
are pointing to certain SqlDataAdapters to point to just the one. How
would I do this?
Thanks,
JJ