Dispose Connection inside Class

I am long time vb hacker new to .net

Using vb.net I have the following code.
*******************************
Public Function GetData() As clsData
Dim rs As New ADODB.Recordset()
Dim colTemp As New clsDatas()

Do some work here...

rs.Close()
rs = nothing
***********************************

When I upgrade my project into vb.net I get the following message from .Net

'UPGRADE_NOTE: Object rs may not be destroyed until it is garbage collected. Click for more: 'ms-help://MS.VSCC/commoner/redir/redirect.htm?keyword="vbup1029"'

I understand that GC will take care of itself in its own time.
However, lets say I want to dispose of the recordset within this function.

I dont know the proper way to do this.

I have seen a post that says to do the following;

Implement IDisposable

Public Overridable Overloads Sub Dispose() Implements IDisposable.Dispose
'\\ Do your cleaning up here....
End Sub

how do I call the Dispose method from within the above GetData function.

I can't put the rs = nothing inside the dispose method becuase it is declared inside the GetData, method not the class. I guess one solution would be to declare it in the class??

I saw something like this:

CType(rs, Idisposable).Dispose()

but that does not work.

P.S should I really worry about disposing of this thing or letting GC do it on its own time?

Why don't you set the obj you want to dispose to Nothing then fire GC at the end of the class or as needed as follow :

VB Code:

Dim GarColletor As GC
GarColletor .Collect()

So is this what you are suggesting

**********************
Private Function Something
Dim GarColletor As GC
Dim rs as adodb.recordset
...

rs.close
rs = nothing
GarColletor .Collect()
**********************

I did not know you could do that.

Do you think it is important to worry about it or should I let VB.net worry about it

Yes , something like that .

I don't know but I think it would depends on your proj you're working on . For small projs, don't even bother yourself and let it handled by GC manager . But , if you have a lot of orphan objs (no longer used) , then you should worry . The default for GC is that it fires itself randomly not forced by a user .

Thanks Pirate.

Hey, I crack up every time I see your logo. Got to be the best one yet.

:D ...............:p ..................:D