Does vb.net have memory leaks?

[jw970170]

I have some code that looks like there is a memory leak (ie...in C++, there would be a memory leak since I didn't release the memory when I created the second instance of mycommand). The code is below

Dim myCommand As New SqlCommand(myDropTable, Conn)
Try
myCommand.ExecuteNonQuery()
Catch myException As Exception
'MsgBox(myException.ToString())
'Nothing to delete for now
End Try

'Possible memory leak?? VB vs C++
myCommand = New SqlCommand(myCreateTable, Conn)

In VB, do I have to release the memory somehow . Should I do something like

delete myCommand
'Possible memory leak?? VB vs C++
myCommand = New SqlCommand(myCreateTable, Conn)


Thanks in advance

 

[ThatRickGuy]

.Net uses the windows Garbage Collector to manage memory. When a variable goes out of scope, it get's marked for collection, and eventually the GC will collect it.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[jo0ls]

mycommand.Dispose()

If something has a dispose method then you can use it to release the resources faster.

 

[ThatRickGuy]

joOls, even if you set an object = nothing, it still just marks the memory for collection. You can force the GC to run with GC.collect (err GC.Collect2).

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[jo0ls]

I've been reading up on garbage collecton (I'm trying to use IMAPI and imapi.exe stays open after my program closes.)
From what I read it seems that calling dispose on items that implement idisposable won't do any harm, might prevent problems, and should get items cleaned up earlier (the automatic GC may take longer). There's more here:

http://www.bluebytesoftware.com/blog/SearchView.aspx?q=vb.net dispose

My Imapi problem must lie with some unmanaged resource not getting disposed, but there is a lot going on. I'll have to simplify it and try to find one thing that leads to the problem.

 

[ThatRickGuy]

For unmanaged code (COM objects) you might want to look into marshal.release

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[jw970170]

Wow. Ok, thanks everyone for your help. Looks like I don't really have to worry about it...but I can if I so choose