看看这段连接数据库的代码
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: