aspx 语句错误

来源:百度知道 编辑:UC知道 时间:2024/06/02 13:32:50
System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。
上面那句是单击提交按钮时出现是连接数据库时出错提示的信息
所建数据库的名称为userinfo.mdb表名user
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="VB" runat="server">
Sub Enter_Click(Sender As Object, E As EventArgs)
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("userinfo.mdb"))
Dim strA,strB,strSql As String
strA="Insert Into user(username,password,email,sex,career,love)"
strB="Values('" & username.Text &"','" & password1.Text & "','" & email.Text & "','" & sex.Text & "','" & career.Text & "','" & love.Text & "',#" & Now() & "#)"
strSql=strA & ")" & strB & ")"
Dim cmd As New Ole

strA="Insert Into user(username,password,email,sex,career,love)"
strB="Values('" & username.Text &"','" & password1.Text & "','" & email.Text & "','" & sex.Text & "','" & career.Text & "','" & love.Text & "',#" & Now() & "#)"

strB的问题..

你看你strA只有6个列..而你strB有7个列.

解决方法..
1在love后面加上你的时间列 如 love,time
2把,#" & Now() & "#这个去了也可以
根据你的功能来改