Adoconnectio Metodo Execute






Dim adoConn As ADODB.Connection = New ADODB.Connection()
' adoConn.Open("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source =" & TypeConn.PathDataBase & ";Jet OLEDB:Database PassWord=xxxxxxxxxx;", "", -1)

adoConn.Open((TypeConn.ConnectionString))
'Dim sql As String = "DELETE Scadenzario.Mese, Scadenzario.TipoPagamento, Scadenzario.Anno FROM (Scadenzario) WHERE (((Scadenzario.Mese)='" & ComboBox2.Text & "') AND ((Scadenzario.Anno)=" & TextBox2.Text & "));"

Dim sql As String = "DELETE Fatturazione.Mese, Fatturazione.Gestione FROM Fatturazione WHERE (((Fatturazione.Mese)='" & ComboBox2.Text & "') AND ((Fatturazione.Gestione)=" & TextBox2.Text & "));"
adoConn.Execute(sql)

MsgBox("Tutte le Fatture con mese " & ComboBox2.Text & " anno " & TextBox2.Text & vbCrLf & _
"sono state cancellate", MsgBoxStyle.Information, "OK")





'*****************************************************************************************************





Public Sub EseguiQueryAdoDB(ByVal MyQuery As String)
'************************************************************************

' Esegue qualsiasi query passandogli la stringa

'************************************************************************


Dim Conn As ADODB.Connection = New ADODB.Connection
Conn.CursorLocation = CursorLocationEnum.adUseServer
Conn.ConnectionString = TypeConn.ConnectionString
Try
Conn.Open()


Stringa = MyQuery
Conn.Execute(Stringa)

Conn.Close()
Conn = Nothing

Catch ex As Exception
Debug.Print(ex.Message & " - " & MyQuery)
End Try


End Sub










( adoconnectiometodoexecute.html )- by Paolo Puglisi - Modifica del 17/12/2023