[wilsons]

Hi there, I am new to vb.net programming. I am developing a point of sale application and am having trouble writing data to access 2007 database. Am getting an error "Syntax error in INSERT INTO statement,"

my code for the form load is:



[Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

dbProvider = "PROVIDER=Microsoft.ACE.OLEDB.12.0;"
dbSource = "Data Source= C:\users\newton\Documents\wilson.accdb"

con.ConnectionString = dbProvider & dbSource

con.Open()
sql = "SELECT tblLogin.Username, tblLogin.Password FROM tblLogin"
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "Login")

con.Close()

MaxRows = ds.Tables("Login").Rows.Count
inc = -1


End Sub][/code]


and the code for the save button is


[Private Sub btnCommit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
If inc <> -1 Then
Dim cb As New OleDb.OleDbCommandBuilder(da)
Dim dsNewRow As DataRow

dsNewRow = ds.Tables("Login").NewRow()

dsNewRow.Item("Username") = txtUsername.Text
dsNewRow.Item("Password") = txtPassword.Text



ds.Tables("Login").Rows.Add(dsNewRow)
da.Update(ds, "Login")



End If
End Sub
][/code]

[tlhIn`toq]

Please fix your code tags



sql = "SELECT tblLogin.Username, tblLogin.Password FROM tblLogin"

This almost looks like you are trying to parameterize the query, but not doing it right. You can't just shove in a GUI control.property withing a pair of quotes and expect it to work. How would your code know you want the text from tblLogin.Username and not literally "tblLogin.Usernam"?

from my FAQ list:


Q:... how to do x,y,z with a database {probably for the first time}...
A: Read this tutorial
Entire section of tutorials
Parameterizing Your SQL Queries: The RIGHT Way To Query A Database.
Using SqlDependency to monitor SQL database changes