为什么报错???INSERT INTO 语句中的语法错误 [英] Why error ???? Syntax error in INSERT INTO statement

问题描述

Public Sub register_user()
    Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\User\Documents\login.mdb")
    con.Open()
    Dim reg As New DataTable("loginadmin")
    Dim aaa As New OleDb.OleDbDataAdapter("Select * from loginadmin ", con)
    Dim rs As New OleDb.OleDbCommand("Insert into loginadmin(username,password) values ('" & TextBox1.Text & "', '" & TextBox2.Text & "')", con)



    rs.ExecuteNonQuery()
    MessageBox.Show("user successfully registerd")

    con.Close()

End Sub

'debugger 捕捉到这个错误语法错误插入语句"'大

'debugger caught this error " syntax error insert into statement" 'the da

推荐答案

试试这个 :- Dim rs As New OleDb.OleDbCommand ("Insert into loginadmin([username],[password]) values ('" & TextBox1.Text & "', '" & TextBox2.Text & "')", con)

try this :- Dim rs As New OleDb.OleDbCommand ("Insert into loginadmin([username],[password]) values ('" & TextBox1.Text & "', '" & TextBox2.Text & "')", con)

这篇关于为什么报错???INSERT INTO 语句中的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！