public void CreatUser()
{ Change_type();//执行函数
if (Judge_1()=="success")
{
conn=new OleDbConnection("Provider= Microsoft.Jet.OleDb.4.0; Data Source=c:/pq.mdb;");
conn.Open();
comm=new OleDbCommand();
comm.Connection=conn;
comm.CommandText="Insert Into EXF_USER ([UserID],[UserName],[Password],Age,Sex,Job,Phone,Email,QQ,[UserType],Memo,logindate,lastdate) Values('"+ID_write+"','"+TextBox_username.Text+"','"+TextBox_password.Text+"',"+TextBox_age.Text+",'"+sex_judge+"','"+TextBox_work.Text+"','"+TextBox_tel.Text+"','"+TextBox_email.Text+"','"+TextBox_qq.Text+"','"+type_judge+"','"+TextBox_memo.Text+"','"+DateTime.Now+"','"+DateTime.Now.AddDays(30)+"')";//OleDb插入语,
comm.ExecuteNonQuery();
Label_info.Text ="注册成功!";//注册成功提示
Response.Write("<script language='javascript'>alert('用户注册成功,请继续');document.location.href='login.aspx';</script>");
//Response.Redirect ("login.aspx");//转入登陆页面
}
else Label_info.Text=Judge_1()+"!";//注册出错警告
Label_info.Visible = true;//设定注册提示标签可见
}
这是一段asp.net的注册页面写入ACCESS数据库的语句,我一运行就给我报错INSERT INTO 语句的语法错误。 就是不知道怎么搞!!!明天要交课程设计了~急急急死我了!!!希望高手们救救我啊!

解决方案 »

  1.   

    源错误: 
    行 233: comm.Connection=conn;
    行 234: comm.CommandText="Insert Into EXF_USER ([UserID],[UserName],[Password],Age,Sex,Job,Phone,Email,QQ,[UserType],Memo,logindate,lastdate) Values('"+ID_write+"','"+TextBox_username.Text+"','"+TextBox_password.Text+"',"+TextBox_age.Text+",'"+sex_judge+"','"+TextBox_work.Text+"','"+TextBox_tel.Text+"','"+TextBox_email.Text+"','"+TextBox_qq.Text+"','"+type_judge+"','"+TextBox_memo.Text+"','"+DateTime.Now+"','"+DateTime.Now.AddDays(30)+"')";//OleDb插入语,
    行 235: comm.ExecuteNonQuery();
    行 236: Label_info.Text ="注册成功!";//注册成功提示
    行 237: Response.Write("<script language='javascript'>alert('用户注册成功,请继续');document.location.href='login.aspx';</script>");
     
      

  2.   

    Insert Into EXF_USER ([UserID],[UserName],[Password],Age,Sex,Job,Phone,Email,QQ,[UserType],Memo,logindate,lastdate) Values("+ID_write+",'"+TextBox_username.Text+"','"+TextBox_password.Text+"',"+TextBox_age.Text+",'"+sex_judge+"','"+TextBox_work.Text+"','"+TextBox_tel.Text+"','"+TextBox_email.Text+"','"+TextBox_qq.Text+"','"+type_judge+"','"+TextBox_memo.Text+"','"+DateTime.Now+"','"+DateTime.Now.AddDays(30)+"')
    检查字段类型,字段组合测试
      

  3.   

          设置断点跟踪调试看看、  运行到的sql语句是什么 ? 
      

  4.   


    //很简单,在此句打个断点,执行到此外,看看sql语句到底是什么
    //实在找不到错误,就将sql语句复制到查询分析器中运行一下
    //ps:ID_write是全局变量?还是一个TextBox
    comm.CommandText="Insert Into EXF_USER ([UserID],[UserName],[Password],Age,Sex,Job,Phone,Email,QQ,[UserType],Memo,logindate,lastdate) Values('"+ID_write+"','"+TextBox_username.Text+"','"+TextBox_password.Text+"',"+TextBox_age.Text+",'"+sex_judge+"','"+TextBox_work.Text+"','"+TextBox_tel.Text+"','"+TextBox_email.Text+"','"+TextBox_qq.Text+"','"+type_judge+"','"+TextBox_memo.Text+"','"+DateTime.Now+"','"+DateTime.Now.AddDays(30)+"')";//OleDb插入语,
      

  5.   

    输出语句到查询分析里执行,很快可以找到BUG所在。