Torna al Thread

'DICHIARAZIONE DELLE VARIABILI ED ASSEGNAZIONE DEI VALORI Dim Nome_cli As String = CStr(Me.TextBox1.Text) Dim ind_cli As String = CStr(Me.TextBox2.Text) Dim cap_cli As String = CStr(Me.TextBox3.Text) Dim comune As String = CStr(Me.TextBox4.Text) Dim prov As String = CStr(Me.TextBox5.Text) Dim CF As String = UCase(CStr(Me.TextBox6.Text)) Dim PI As String = CStr(Me.TextBox7.Text) Dim Tel As String = CStr(Me.TextBox8.Text) Dim Fax As String = CStr(Me.TextBox9.Text) Dim Cell As String = CStr(Me.TextBox10.Text) Dim Mail As String = CStr(Me.TextBox11.Text) Dim Web As String = CStr(Me.TextBox12.Text) Dim Note As String = CStr(Me.TextBox13.Text) Dim queryString As String Dim NomePercorso As String = CStr(Me.txtNomePerc.Text) Dim strConnessione As String Dim strProvider As String = "Provider = Microsoft.Jet.OLEDB.4.0;" Dim strOrigine As String = "Data Source=" & Application.StartupPath & "\dbRCF.mdb" strConnessione = strProvider & strOrigine Using Conn As New OleDb.OleDbConnection(strConnessione) Conn.Open() queryString = "INSERT INTO Clienti (Denominazione, Indirizzo, Cap, Comune, Provincia, Cod_Fisc, Part_Iva, Telefono, Fax, Cellulare) VALUES °_ ('" & Nome_cli & "', '" & ind_cli & "', '" & cap_cli & "', '" & comune & "', '" & prov & "', '" & CF & "', '" & PI & "', '" & Tel & "', '" & Fax & "', '" & Cell & "')" Me.TextBox14.Text = queryString Dim InsCli As New OleDb.OleDbCommand(queryString, Conn) Dim Result As Integer Result = InsCli.ExecuteNonQuery End Using MsgBox("Inserimento Dati Completato.", MsgBoxStyle.Information, "EasY Net") Me.Close()
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5