Torna al Thread

Private Sub DatiDataGridView_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles DatiDataGridView.DoubleClick Dim var1 As String Dim var3 As String var1 = DatiDataGridView.CurrentRow.Cells(1).Value.ToString() var3 = DatiDataGridView.CurrentRow.Cells(3).Value.ToString() Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\DbOggetti.mdb" Dim result As DialogResult result = MessageBox.Show("Vuoi aggiungere questo prodotto al Carrello?", "Aggiungi al Carrello", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) If result = Windows.Forms.DialogResult.Yes Then Dim quantita As New Quantita Dim qta As String quantita.ShowDialog() Debug.Print(quantita.ValoreDigitato) qta = quantita.ValoreDigitato quantita.Dispose() Using ConnEl As New OleDb.OleDbConnection(strConn) ConnEl.Open() Dim strQuery As String = "INSERT INTO Carrello(Descrizione,Quantita) VALUES('" & var1 & " - " & var3 & "','" & qta & "')" Dim cmdModArt As New OleDb.OleDbCommand(strQuery, ConnEl) cmdModArt.ExecuteNonQuery() ConnEl.Close() End Using ElseIf result = Windows.Forms.DialogResult.No Then End If
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5