DataSet Question

[Hinder]

Ok I have a function that can be called that will fill a new dataset with the passed parameters, then return the new dataset to the calling routine. My problem is the Adapter is only in the scope of the function that created the new dataset. I want to know if I can update the database through the dataset since the original adapter is no longer around? Can I late bind a adapter when I need to? Or is there another way? Anyone?

[Iceman5]

You can do almost whatever you want.
But what I know you need a dataadapter for the conection between the database and dataset. The dataadapter chooce which information you want from the database and the dataconnection is the connection to the database that gives you access.

You got the Dataset created from start?
If so why don´t you create a dataadapter and chooce what tables you want to see etc... and generate a dataset which you fill during the code.

Or you can also do: Create a dataapadter and a dataset and copy the dataset you working with to the one who got a connection to the database.

Or. Try dataadapter1.TableMappings. (not sure if it works)