ASP.NET执行OleDbCommand.ExecuteNonQuery时报错：INSERT INTO语法错误

Question

大家好，我是刚开始学习ASP.NET写数据库网站的新手

我用Access新建了一个MDB数据库，数据库里面只有一个表，名为Users

Users表里面包含三个字段：
ID： 自动编号（设为主键）
Username: 文本类型
Password: 文本类型

然后尝试在Visual Studio 2010中以VB.NET程序在表Users中插入一新行

但当程序代码执行到 Command.ExecuteNonQuery时报错
错误描述为： INSERT INTO 语法错误

程序代码如下，烦请各位帮忙分析并解决一下，谢谢！

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim dbName As String
Dim StrConnection As String
Dim Sql As String
Dim Conn As OleDbConnection
Dim Command As OleDbCommand

dbName = ConfigurationManager.AppSettings("dbPath")
StrConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(dbName)
Conn = New OleDbConnection(StrConnection)
Conn.Open()

Sql = "INSERT INTO Users (username,password) VALUES (@username,@password)"
Command = New OleDbCommand(Sql, Conn)

Command.Parameters.AddWithValue("@username", txtUsername.Text)
Command.Parameters.AddWithValue("@password", txtPassword.Text)

Command.ExecuteNonQuery()

Command.Dispose()
Command = Nothing
Conn.Close()
Conn = Nothing
StrConnection = Nothing
Sql = Nothing
End Sub

Answer 1

把@username和@password改为:username,:password