Torna al Thread

Private Sub Nuovo() Dim CodIva As String = CStr(Me.TextBox1.Text) Dim Aliva As Single = CSng(Me.TextBox2.Text) Dim AlEff As Single = CSng(Me.TextBox4.Text) Dim Detraib As Single = CSng(Me.TextBox3.Text) Dim queryString As String Dim strConnessione As String Dim strProvider As String = "Provider = Microsoft.Jet.OLEDB.4.0;" Dim strOrigine As String = "Data Source=" & Application.StartupPath & "\dbCodici.mdb" strConnessione = strProvider & strOrigine Using Conn As New OleDb.OleDbConnection(strConnessione) Conn.Open() queryString = "INSERT INTO iva (Cod_Iva, AlIva, AlIvaEff, Detraib) VALUES ('" & CodIva & "', '" & Aliva & "', '" & AlEff & "', '" & Detraib & "')" 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.Text) End Sub
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5