Disposing a Dataset
-
Hi All, I am generating a set of datasets from few DataAdapters, and those generated datasets are referred in another project space as referenced dataset. When i say
DataAdapter.Fill(datasetX, "tbl");it does the task for me. The Memory size of the Exe in the runtime grows from 10mb to 20mb,but once i close the form the size never comes down. Even if i saydatasetX.Dispose(); System.GC.Collect();And i was thinking of using 20 to 30 such datasets but will it not increase the size of my application ? How can I bring down the runtime memory consumption ? How can I Dispose the Dataset ? Please help with this. Thanks in advanceKSS
-
Hi All, I am generating a set of datasets from few DataAdapters, and those generated datasets are referred in another project space as referenced dataset. When i say
DataAdapter.Fill(datasetX, "tbl");it does the task for me. The Memory size of the Exe in the runtime grows from 10mb to 20mb,but once i close the form the size never comes down. Even if i saydatasetX.Dispose(); System.GC.Collect();And i was thinking of using 20 to 30 such datasets but will it not increase the size of my application ? How can I bring down the runtime memory consumption ? How can I Dispose the Dataset ? Please help with this. Thanks in advanceKSS
Are you disposing the connection object and DataAdapter object as well? What happens when you open and dispose a bunch of datasets, does the memory size of the exe keep going up? System.GC.Collect(); is probably unnecessary.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things --thedailywtf 3/21/06
-
Are you disposing the connection object and DataAdapter object as well? What happens when you open and dispose a bunch of datasets, does the memory size of the exe keep going up? System.GC.Collect(); is probably unnecessary.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things --thedailywtf 3/21/06
Are you disposing the connection object and DataAdapter object as well?
No i am not disposing them , as they are dragged on to a component. and from that Adapter ->Right Click ->Generate Dataset.then i refer that dataset from my UI project.
What happens when you open and dispose a bunch of datasets, does the memory size of the exe keep going up?
No the size of the Exe remains the same.
how vital enterprise application are for proactive organizations
leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that
focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the
bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06This really is cool but High Level also... :-D Thanks for the answer.
KSS