Loading

public function in vb.net

vijay antony

16y4.3k

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel16y ago
Accepted 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
+1
paul daniel16y ago
Refer this link

http://www.techtoolblog.com/archives/webconfig-connection-string-settings-in-net-20
+1
Hirendra Sisodiya16y ago
You can declare this in public module class as public. or you can make propery of this
+1