Question

我在vb.net上没有很多经验,但我试图利用OlegDB在Sting、string、Yes/no(姓名、号码、性别)上添加一个记录。然而,当我加入时,有人提出例外,说我对“插入”的 que子是无效的。我无法发现这一错误。

试验:

txtName.Text = "asdasdasd"
txtPhone.Text = "123456789"
rGender.Checked = True

该法典:

    cmd = New OleDbCommand()
    With cmd
        .Connection = cn
        .CommandText = "INSERT INTO [Student] (StudentName, Number, Gender) VALUES(@Name,@Number,@Gender)"
        .CommandType = CommandType.Text
        .Parameters.AddWithValue("@Name", txtName.Text)
        .Parameters.AddWithValue("@Number", txtPhone.Text)
        .Parameters.AddWithValue("@Gender", rGender.Checked)
    End With

Answer 1

Seems such as the Problem with field name “Number”, its a keyword inMSAccess - 。

Answer 2

页: 1

INSERT INTO [Student] ([StudentName], [Number], [Gender]) VALUES(@Name,@Number,@Gender)

友情链接