public override void RegisterNew(RegUser user, string userMd5Pwd)
{
string cmdText; #region 构造 SQL 查询语句
cmdText=@"INSERT INTO [RegUser]([UserName], [Password], [EMail]) 
  VALUES(@UserName, @UserPwd, @EMail)";
#endregion OleDbConnection dbConn=DBConnection.CreateInstance();
OleDbCommand dbCmd=new OleDbCommand(cmdText, dbConn); dbCmd.Parameters.Add(new OleDbParameter("@UserName", OleDbType.VarWChar, 20));
dbCmd.Parameters["@UserName"].Value=user.UserName; dbCmd.Parameters.Add(new OleDbParameter("@UserPwd", OleDbType.VarWChar, 128));
dbCmd.Parameters["@UserPwd"].Value=userMd5Pwd; dbCmd.Parameters.Add(new OleDbParameter("@EMail", OleDbType.VarWChar, 50));
dbCmd.Parameters["@EMail"].Value=user.EMail; dbConn.Open(); try
{
dbCmd.ExecuteNonQuery();
}
catch(Exception ex)
{
dbConn.Close();
throw ex;
} dbConn.Close();
}
public static OleDbConnection CreateInstance()
{
string fileName;
string provider="PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA Source="; fileName=ConfigurationSettings.AppSettings["AccessDbConn"];
fileName=HttpContext.Current.Server.MapPath(fileName); return new OleDbConnection(provider+fileName);
}
出现的错误:操作必须使用一个可更新的查询
行 230: {
行 231: dbConn.Close();
行 232: throw ex;
行 233: }
行 234: