Should i call dispose on dataset

Push Shared Property value change to object instances Vb. Skip to main content. Find threads, tags, and users Fill Data Me. Dispose Adapter. Dispose Me. Current Visibility: Visible to all users. Tag End Sub.

I read your blog : :- So, if I am using DataTable etc in my code not dropped using the designer , I must dispose it Right? Sort of. IDisposable is a contract that mean call Dispose when done with the instance and you are safe if you do. However, some people might argue that Dispose does nothing on certain classes such as DataTable which might even be true at the present time. Yet the implementation of Dispose might change for such a class in the future - imagine that Dispose actually does something important in.

The bottom line is: if you want to be on the safe side always call Dispose if class implements IDisposable. Kevin Spencer. If you create one programmatically, it doesn't have to be disposed, unless it is bound to some disposable objects.

Net Developer Complex things are made up of Lots of simple things. Dispose will this result in DataTable getting disposed automatically without me writing any explicit code? Is this what you want to say? How does it work unless I write myDataTable. Dispose in myIntsance. Dispose method explicitly? This discussion thread is closed Start new discussion. Similar topics.

NET Framework. Visual Basic. I also suspect this is part of a method in which case dt is method-scoped anyway. Adam Houldsworth Adam Houldsworth Does it good habit to make it null and free up memory??

Rajeev I think it's a good habit to call Dispose on items that you are finished with, however, you have assigned the DataTable to the DataSource , so you don't want to call Dispose as it isn't finished with.

Explicitly nulling items is rarely ever needed. Gridview still doing well in this case and my memory is also get freeup — Rajeev Kumar.

RajeevKumar You have only freed up a single reference 4 or 8 bytes , the underlying 10k rows are still there in the grdView. DataSource property. By all means null if you are finished with it, but I am just saying that I very rarely have to explicitly do that. I am trying to find the solutions because my application crash after some period of time saying system.

Try to use Clear function. It works great for me for disposing. Clear ;. Hasan Savran Hasan Savran 1 1 silver badge 5 5 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Podcast Quality code is the easiest to delete. Upcoming Events. Featured on Meta.

Now live: A fully responsive profile. Candidate changes in Moderator Election — review your ballot. Visit chat.