public function in vb.net

Question

hi everybody
i need help for use the public function in vb.net
in my project i am using this sqlconnection in some places
Dim DBConn As New SqlConnection("Server=192.168.1.2;User ID=user;Password=pass;DataBase=TespaMechanical")

but i want declare it in one place and whenever i need i can use this connection
what shall i do

can anyone give a solution

Kirtan Patel · Answer

you can declare Public funtion in vb.net by Shared Keyword for example Shared Function Add(ByVal a As Integer ByVal b As Integer) As Integer Return a + b End Function

paul daniel · Answer

Refer this link http://www.techtoolblog.com/archives/webconfig-connection-string-settings-in-net-20

Hirendra Sisodiya · Answer

You can declare this in public module class as public. or you can make propery of this