Witam!
Nie mogę dodać nowe rekordu do bazy danych w Access , program który pisze w ramach nauki w VB. Wyskakuje mi błąd składni polecenia UPDATE. co robie źle.
Public Class Form2
Dim c As New System.Data.OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As System.Data.OleDb.OleDbDataAdapter
Dim sql As String
Dim pozycja As Integer
Dim ile As Integer
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
c.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\cinek_000\Desktop\Towary2.mdb"
sql = "SELECT * FROM Tabela1"
da = New OleDb.OleDbDataAdapter(sql, c)
da.Fill(ds, "Tabela1")
End Sub
Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Anuluj.Click
Close()
End Sub
Private Sub Label1_Click(sender As Object, e As EventArgs) Handles Label1.Click
End Sub
Private Sub Dodaj_Click(sender As Object, e As EventArgs) Handles Dodaj.Click
UpdateRecord()
Dim addNewRec As New System.Data.OleDb.OleDbCommand()
addNewRec.Connection = c
addNewRec.CommandText = "INSERT INTO Tabela1 ([Nazwa Towaru], [Ilość], [Cena]) VALUES ('','','')"
c.Open()
addNewRec.ExecuteNonQuery()
c.Close()
pozycja = 0
End Sub
Private Sub TextBox3_TextChanged(sender As Object, e As EventArgs) Handles TextBox3.TextChanged
End Sub
Private Function App() As Object
Throw New NotImplementedException
End Function
Private Sub UpdateRecord()
Dim cb As New OleDb.OleDbCommandBuilder(da)
ds.Tables("Tabela1").Rows(pozycja).Item(1) = NazwaTowaru.Text
ds.Tables("Tabela1").Rows(pozycja).Item(2) = IloscTowaru.Text
ds.Tables("Tabela1").Rows(pozycja).Item(3) = CenaTowaru.Text
da.Update(ds, "Tabela1")
End Sub
End Class