Public ADO connection

[Rajeeshun]

Hi,
Im very new to VB.NET & Visual studio .NET. But I have been working more than 5 years in Application development using VB/DELPHI/ Oracle

In VB.NET I know how to connect the database (Oracle) by using Connection, Adapter & Dataset. But What im doing in VB.NEt is Im pasting (Draging & Droping) all controls in my form

In VB6 Ive developed several application which has only one public ADO connection (In Module) and Im using that connection for all Database related operation

My projects are not using any bound methods, and all are unbound methods
like...
In module...
dim myCon as ado.connection
set myCon=new ado.connection

I like to follow same kind of approach in VB.NET also
How can I do this....?
How can I have a connection by creating a instance for ADO w(EG (in VB):
set MyCon=new Ado.Connection )

Pls help me and give some idea & Samples

 

[Robby]

You can create a class to handle all the database stuff and then create an instance of that class or inherit it.

 

[Rajeeshun]

Thank you very much
If possible, cud you pls give some sample codes or web site links ???

 

[Robby]

Have you coded in an object oriented style?

 

[Rajeeshun]

Originally posted by Robby
Have you coded in an object oriented style?

Ya I coded in OO style.. and I like to follow pure OO style