Torna al Thread

Private Sub SalvaDati() Dim Nome As String = CStr(Me.TextBox1.Text) Dim Ind As String = CStr(Me.TextBox2.Text) Dim Loc As String = CStr(Me.TextBox3.Text) Dim CF As String = CStr(Me.TextBox4.Text) Dim PI As String = CStr(Me.TextBox5.Text) Dim Tel As String = CStr(Me.TextBox10.Text) Dim Fax As String = CStr(Me.TextBox9.Text) Dim mail As String = CStr(Me.TextBox8.Text) Dim Sito As String = CStr(Me.TextBox7.Text) Dim Img As String = CStr(Application.StartupPath & "\dbTemp\Logo.gif") 'Inserimento Dati' Dim strProvider As String = "Provider = Microsoft.Jet.OLEDB.4.0;" Dim strOrigine As String = "Data Source=" & Application.StartupPath & "\dbTemp\dbDP.mdb" Dim strConnessioneB As String = strProvider & strOrigine Dim queryString2 As String Using Conn2 As New OleDb.OleDbConnection(strConnessioneB) Conn2.Open() 'queryString = "INSERT INTO DatiP (Denominazione, Indirizzo, Local, CodFisc, PartIva, Telefono, Fax, Mail, Web) VALUES ('" _ '& Nome & "', '" & Ind & "', '" & Loc & "', '" & CF & "', '" & PI & "', '" & Tel _ '& "', '" & Fax & "', '" & mail & "', '" & Sito & "')" queryString2 = "INSERT INTO DatiP (Denominazione, Indirizzo, Local, CodFisc, PartIva, Telefono, Fax, Mail) VALUES ('" _ & Nome & "', '" & Ind & "', '" & Loc & "', '" & CF & "', '" & PI & "', '" & Tel & "', '" & Fax & "', '" & mail & "')" Dim cmdInsDati As New OleDb.OleDbCommand(queryString2, Conn2) Dim Result As Integer Result = cmdInsDati.ExecuteNonQuery --> qui dà l'errore. Conn2.Close() End Using End Sub
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5