Public datatable life cycle

Question

0.00/5 (No votes)

See more:

Good Day

This may be a stupid question but...
If you have a public datatable used for info between programs visual studio

Public Shared DtRptDisc As New DataTable("DtRptDisc")

If the case scenario is that you want to refresh the datatable and you do as follows

DtRptDisc = New Datatable

Is this creating a duplicate instance ? or recreating the same instance?
Meaning that the previous Datable is still resident in memory as was not disposed?
So meaning is this cycle repetitively done will this chew up resources? Does not seem to but unsure.

What I have tried:

Google Search, Have not disposed of the datatable in the App as currently or continuously in use so a global resource been used all the time.

Posted 22-Oct-21 6:34am

Grid-Code

Updated 25-Oct-21 1:30am

Add a Solution

2 solutions

Solution 1

If you want to make sure the DataTable is disposed, you can use a using clause in C# like this:

using (DataTable table = new DataTable())
{
  // your code
}

For the VB.NET syntax see: Using Statement - Visual Basic | Microsoft Docs[^]

Posted 22-Oct-21 7:29am

RickZeeland

Updated 22-Oct-21 7:32am

v2

Comments

Grid-Code 23-Oct-21 2:31am

Hi RickZeeland

Appreciate the c# Snip
So New Datatable disposes the Prior one - Brilliant

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2021-10-25T01:30:00

Quote:
VB.NET
DtRptDisc = New Datatable
Is this creating a duplicate instance ? or recreating the same instance?

It creates a new DataTable instance, and clears the reference to the old one from the field.

If you have used the value of that field anywhere else, there may be a reference to the original instance hanging around. If not, the GC will eventually clean up the memory used by the old instance.

If you want to ensure that only one instance is ever used, and that all references share the same view of the data, you should reload the DataTable rather than creating a new instance.