Upgraded VB6 to .NET . . a few problems

Upgraded VB6 to .NET . . a few problems.
I need the correct code where there is "'UPGRADE_NOTE:":

1.
'UPGRADE_ISSUE: Load statement is not supported.
Load(frmSupp)

2.
If rsNewType.State = ADODB.ObjectStateEnum.adStateOpen Then
  rsNewType.Close()
  'UPGRADE_NOTE: Object rsNewType may not be destroyed until it is garbage collected.
  rsNewType = Nothing
End If

thanks
LVL 16
MikeMCSDAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Arthur_WoodCommented:
1) forms in VB.NET are classes that you do not LOAD, but rather create an instance of:

Dim frm as New frmSupp

and then show the form as a Dialog (modal form):

frm.ShowDialog()

tghere is no underlying Forms collection as there was in VB 6.

2) is simply advising you that .NET does NOT have DETERMINISTIC object release.  In vb 6, when you set an object reference to Nothing, the object was removed from memory.  In .net, the object is not removeds from memory until Garbage Collection takes place, and you have no direct control over when that happens - but the refenercve is gone, so whether the object is still in memory or not is irrelevant - you cannot access the object once it is set to Nothing.  The memory will be released when the application needs to make use of the memory for other purposes (that is what GC -Garbage Collection- is all about).

#2 is not a error, just advising you about how .NET is different from VB 6.

#1 IS an ERROR - the method does not exist any longer.

AW
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MikeMCSDAuthor Commented:
Thank you Mr. Wood!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.