大家帮我看下这个问题!! 在线等
string db ="data.mdb"; //数据库路径
string connstr,insert;
insert = "Insert Into user(id,password,answer,question,mail) Values(@id,@password,@answer,@question,@mail)";
connstr = "Provider= Microsoft.Jet.OLEDB.4.0;Data Source=" +Server.MapPath(db);
OleDbConnection conn;
OleDbCommand cmd;
conn = new OleDbConnection(connstr);
conn.Open();
cmd = new OleDbCommand(insert,conn);
try
{
cmd.Parameters.Add(new OleDbParameter ("@id",OleDbType.Char));
cmd.Parameters.Add(new OleDbParameter ("@password",OleDbType.Char));
cmd.Parameters.Add(new OleDbParameter ("@answer",OleDbType.Char));
cmd.Parameters.Add(new OleDbParameter ("@question",OleDbType.Char));
cmd.Parameters.Add(new OleDbParameter ("@mail",OleDbType.Char));
cmd.Parameters["@id"].Value = id.Text;
cmd.Parameters["@password"].Value = psw2.Text;
cmd.Parameters["@answer"].Value = answer.Text;
cmd.Parameters["@question"].Value = question.Text;
cmd.Parameters["@mail"].Value = mail.Text;
cmd.ExecuteNonQuery();
conn.Close();
lab.Text="恭喜您!注册成功!";
}
catch
{
lab.Text="此ID已存在!";
}
怎么老提示 INSERT INTO 语句的语法错误。
可是好象都找不到那里错了哦`!!