DataAdapter.update() and a DataSet in session

[Galen Harris]

Hi.

We want to use a DataAdapter's update method to store changes to a dataset
back to the database. What's the best approach, if that dataset is being
stored in session and passed around the site, effectively disconnecting it
from its original adapter. By the time we get to use the update method, the
original DataAdapter is long gone.

Thanks,
Galen

[Patrik Löwendahl]

You will need to recreate an adapter, reflecting the one that was used to
fill the dataset since the dataset carries no information with it about the
underlying data source.

--
Patrik Löwendahl
cshrp.net - " Elegant code by witty programmers "
cornerstone.se - " IT Training for professionals "
"Galen Harris" <ga****************@ceridianNOSPAM.com> wrote in message
news:Oi**************@TK2MSFTNGP10.phx.gbl...

Hi.

We want to use a DataAdapter's update method to store changes to a dataset
back to the database. What's the best approach, if that dataset is being
stored in session and passed around the site, effectively disconnecting it
from its original adapter. By the time we get to use the update method, the original DataAdapter is long gone.

Thanks,
Galen