string strConnection1 = ConfigurationManager.AppSettings["Conn"];
OleDbConnection objConnection1 = new OleDbConnection(strConnection1);
OleDbCommand objCommand1 = new OleDbCommand("INSERT INTO TempUser(UserName,UserPsd,PsdQuestion,PsdAnswer,E-mail,RealName,SID) values ('" + username + "','" + psd + "','" +psdquestion + "','" + psdanswer + "','" + email + "','" + realname + "','" + sid + "')", objConnection1);
上面发现了两个问题
1. E-mail可能是关键字,所有有冲突。
2. 要检验输入里面有没有“'”等特殊字符,否则出错。