Question

asp.net c# access，为什么我提示insert into 语句错误！

protected void Button1_Click(object sender, EventArgs e)
{
string yhm = TextBox1.Text;
string mm1 = TextBox2.Text;
string mm2 = TextBox3.Text;
if (mm1 != mm2)
{
Response.Write("<script> alert('密码不一致!');</script>");
}
if (mm1 == mm2)
{
string sq2 = "insert into sss (user,pass) values('" + yhm + "','" + mm1 + "')";
string connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\hhh\\ddd.mdb;";
OleDbConnection conn = new OleDbConnection(connstring);
conn.Open();
OleDbCommand cmd = new OleDbCommand(sq2, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Write("<script> alert('注册成功!');</script>");
}
}

Answer 1

string sq2 = "insert into sss (user,pass) values('" + yhm + "','" + mm1 + "')";
改成
string sq2 = "insert into sss ([user],pass) values('" + yhm + "','" + mm1 + "')";
试试

Answer 2

把sql语句放在conn.open()下面

如果还是错的，就把你的sql语句拿到ACCESS里执行一遍就知道哪里错了~~

追问

已经解决了，谢谢！