Torna al Thread

Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\DbOggetti.mdb") Dim cmd As OleDbCommand Private Sub btnINSERT_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnINSERT.Click Try conn.Open() cmd = New OleDbCommand("INSERT INTO nome_tabella (Colonna1, Colonna2, Colonna3) VALUES (@Colonna2 , @Colonna3)", conn) 'Nel caso in cui la Colonna1 sia la chiave primaria autoincrementante cmd.Parameters.Add("@Colonna2", OleDbType.Char).Value = Me.TextBox1.Text cmd.Parameters.Add("@Colonna3", OleDbType.Integer).Value = Me.TextBox2.Text cmd.ExecuteNonQuery() conn.Close() Catch ex As Exception MsgBox(ex.Message) End Try End Sub Private Sub btnDELETE_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDELETE.Click Try conn.Open() cmd = New OleDbCommand("DELETE FROM nome_tabella WHERE id = " + key + "", conn) 'dove key è l'identificativo della riga della tabella o se vuoi il Me.cmbCOMUNI.SelectedValue cmd.ExecuteNonQuery() conn.Close() Catch ex As Exception MsgBox(ex.Message) End Try End Sub
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5