Hi All,

In my application I am using the dataset to hold the information from a table. I generate the dataset using the SQLHelper class. But the thing is after using the SQLhelper method, the dataadapter which is used to fill the dataset is lost as its declaration is local. Now when I want to reflect the changes made to the dataset to the datasource, it says that the selectcommand not found. Which is because the dataadapter which was used to populate the dataset is lost.

I want to know if there is any better way to update the original datasource without creating a new dataadapter with the same query.

Please comment.