INSERT语法有问题 [英] Having problems with INSERT syntax

问题描述

我试图制作一个程序只是为了在msaccess数据库中添加一条记录，

我发现自己在INSERT IN语法错误方面遇到了问题（INSERT INTO语句中的语法错误。 br />


如果有人帮我使用这段代码，我将不胜感激.Tnn。

我总是在cmd.ExecuteNonQuery（）部分得到错误。

Well im trying to make a program just to add a record into the msaccess db,
and I found myself having problems with the INSERT into syntax error (Syntax error in INSERT INTO statement."

I would greatly appreciate if someone helps me with this code. Thnx.
I always get the error in the cmd.ExecuteNonQuery() part.

Dim cmd As New OleDb.OleDbCommand
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As StringDim ds As New DataSet


        If Not con.State = ConnectionState.Open Then
            con.Open()

        End If
        cmd.Connection = con
        cmd.CommandText = "INSERT INTO bene_records(f_name, m_name, l_name, b_date, add, home_num, cell_num)VALUES(@F_nameTextBox, @M_nameTextBox, @L_nameTextBox, @B_dateDateTimePicker, @AddTextBox, @Home_numTextBox, @Cell_numTextBox)"
        cmd.Parameters.AddWithValue("@f_name", F_nameTextBox.Text)
        cmd.Parameters.AddWithValue("@m_name", M_nameTextBox.Text)
        cmd.Parameters.AddWithValue("@l_name", L_nameTextBox.Text)
        cmd.Parameters.AddWithValue("@b_date", B_dateDateTimePicker)
        cmd.Parameters.AddWithValue("@add", AddTextBox.Text)
        cmd.Parameters.AddWithValue("@home_num", Home_numTextBox.Text)
        cmd.Parameters.AddWithValue("@cell_num", Cell_numTextBox.Text)


        cmd.ExecuteNonQuery()

        

        con.Close()

推荐答案

您需要将参数绑定到CommandText中的参数名称，而不是前面带有@的字段名称！

您的代码：

You need to tie the Parameters to the parameter names in your CommandText, not to the field names with an '@' in front!
Your code:

cmd.CommandText = "INSERT INTO bene_records(f_name, m_name, l_name, b_date, add, home_num, cell_num)VALUES(@F_nameTextBox, @M_nameTextBox, @L_nameTextBox, @B_dateDateTimePicker, @AddTextBox, @Home_numTextBox, @Cell_numTextBox)"
cmd.Parameters.AddWithValue("@f_name", F_nameTextBox.Text)
...

需要：

Needs to be:

cmd.CommandText = "INSERT INTO bene_records(f_name, m_name, l_name, b_date, add, home_num, cell_num)VALUES(@F_nameTextBox, @M_nameTextBox, @L_nameTextBox, @B_dateDateTimePicker, @AddTextBox, @Home_numTextBox, @Cell_numTextBox)"
cmd.Parameters.AddWithValue("@F_nameTextBox", F_nameTextBox.Text)
...

这篇关于INSERT语法有问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！