ADO.NET is not very flexible, is it ? I mean to update a datatable or dataset, I always need to keep its dataAdapter somewhere in the memory. There is no other way to directly update these objects in the DB, is there ?

I wrote a standard DLL with some functions. These functions will get you the data from DB in whichever form with any no. of parameters. They return dataTable or dataSet. They just temporarily open a dataAdapter to fill the datatable or dataset and then destroy the dataAdapter.

Now if user makes some changes to dataTable and sends it back to update, how do i update it ? I have already destroyed the dataAdapter .... ?? Is there any way or am I not understanding it very well ...