Originariamente inviato da M@LKAV
potresti dare in modo che nel costruttore della classe dove fai le tue query prenda in input la stringa di connessione al db e aprla la connessione a patto che appena eseguita la query tu la chiuda...
Classe SqlConn(io in un prg ho fatto cosi)
Public Sub New(ByVal StringDb As String)
If StringDb = "" Then
Else
Dim MyConn As String
MyConn = StringDb
con = New SqlConnection
con.ConnectionString = StringDb
'con.ConnectionString = "server=Autoserver;Trusted_Connection=yes; database= TestLineee"
comand = New SqlCommand
Try
con.Open()
me.ConnectionState =True
Catch ex As Exception
Me.ConnectionState = False
End Try
End If
End Sub
Public Property Query() As String
Get
Return strQuery
End Get
Set(ByVal Value As String)
strQuery = Value
End Set
End Property
Public Sub Close()
con.Close()
End Sub
Public Function ExecuteQuery() As Boolean
comand = New SqlCommand(Query, con)
'comand.CommandText = Query
Try
comand.ExecuteNonQuery()
Return True
Catch ex As Exception
Return False
End Try
End Function
es...
dim sqlconn as new sqlconnection(Driver=(SQL Server);Server=myServerAddress;Database=myDataBase ;Uid=myUsername;Pwd=myPassword;
sqlconn.query = myquery
sqlconn.executequery
sqlconn.close