vb.NET 2008: How to use a database connection through multiple forms

Question

I'm testing database programming in vb.NET 2008 at the moment and try to find a way to use a database connection in different forms, so e.g. I put the the database-connection-component into one of the forms.

I know, I could access it by e.g. form1.databaseconnection.xxx, but is this the best way or can I "put" the connection into something more abstract which all forms know about?

Thanks

Jojo Sardez · Accepted Answer · 2010-03-02 12:26:49Z

1

Better if you implement a Data Access Layer on a separate Class Libraray project and add a reference to it on you windows application project.

answered Mar 2, 2010 at 12:26

Jojo Sardez

8,5633 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bobby · Accepted Answer · 2010-03-02 12:28:34Z

0

I had to take a pretty similar design decision, and I decided that it would be the best to share the connection from one major object, and hand it to Forms by calling an overloaded Show()-Method.

Public Overloads Sub Show(ByVal mainController As MyController)
    _handedController = mainController
End Sub

MyController is a class which holds several important things, like the DB-Connection etc. .

answered Mar 2, 2010 at 12:28

Bobby

11.6k5 gold badges48 silver badges70 bronze badges

Collectives™ on Stack Overflow

vb.NET 2008: How to use a database connection through multiple forms

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related