ADO in .NET

[NatHunter]

I am a reasonable VB6 programmer - I'm upgrading a VB6 project to .NET. The project uses ADO.

When running the migration utility, the resulting project includes a reference to ADODB.DLL, but I'm sure I've seen somewhere (in my dreams, perhaps) a reference to a .NET ADO namespace for 'old' ADO. Can anyone tell me if there is a namespace and how to implement it, please?

If there is a namespace, it's a pity the migration utility didn't recognise the fact.

Incidentally, before the obvious comments, I intend to use ADO.NET eventually, but phase I of the migration is going to be as-is!!

Paul

 

[huel]

One way to get to the ADODB namespace is to go to the Project menu, select Add Reference, and then click on the COM tab. Scroll down to the "Microsoft Active X DataObject vX.X Library" and add the reference to your project. After that, you should be able to access the ADODB namespace just fine.

Jay

 

[NatHunter]

Apologies for not getting back to you, but I've been busy!Thanks for the tip. This seems to be the same DLL that the migration wizard used - is it a .NET DLL?

Paul

 

[ThatRickGuy]

no, ADO.Net is in the System.Data name space. after adding the reference to the com dll for ADO you should have access to the ADODB namespace.

-Rick

----------------------

http://www.ringdev.com

 

[NatHunter]

Thanks for the reply. Excuse my .NET ignorance, but this could be fundamentally important to me (!):

The reference to ADODB shows its path property as .....\ADODB.DLL, and likewise the windows forms reference has its path property as .....\System.Windows.Forms.DLL. Are these .NET namespace files? Also, will there be an 'inherits ....ADODB.' statement somewhere?

As I say, this could be fundamental in my understanding, and thanks for any response in advance!

Paul

 

[chrissie1]

no inherits when you use an exeternal dll like adodb only a reference and perhaps an imports depends on how much you like typing.



Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting