日期:2014-05-19  浏览次数:20539 次

急呀,为什么插入不到ACCESS数据库
OleDbConnection   con=DB.CreateCon   ();
OleDbCommand   cmd=new   OleDbCommand   ( "Insert   into   [User]([UserName],[Password])values(@UserName,@Password) ",con);
OleDbParameter   PUserName=new   OleDbParameter   ( "@UserName ",OleDbType.VarChar   ,10);
PUserName.Direction=ParameterDirection   .Input   ;
PUserName.Value     =this.UserName.Text   ;
cmd.Parameters.Add   (PUserName);

OleDbParameter   PPassword=new   OleDbParameter   ( "@Password ",OleDbType.VarChar   ,50);
PPassword.Direction   =ParameterDirection   .Input   ;
                                PPassword.Value     =this.Password.Text;
cmd.Parameters.Add   (PPassword);
con.Open   ();
cmd.ExecuteNonQuery();
                                con.Close   ();

Response.Write   ( "注册成功,您已经成为我们的会员了. ");


------解决方案--------------------
有错误信息吗?
------解决方案--------------------
ACCESS数据库 文件的属性为只读,或则文件是打开状态?
------解决方案--------------------
报什么错?
------解决方案--------------------
可以肯定这段代码是没有问题的:

OleDbCommand cmd=new OleDbCommand ( "Insert into [User]([UserName],[Password])values(@UserName,@Password) ",con);
OleDbParameter PUserName=new OleDbParameter ( "@UserName ",OleDbType.VarChar ,10);
PUserName.Direction=ParameterDirection .Input ;
PUserName.Value = this.UserName.Text ;
cmd.Parameters.Add (PUserName);

OleDbParameter PPassword=new OleDbParameter ( "@Password ",OleDbType.VarChar ,50);
PPassword.Direction =ParameterDirection .Input ;
PPassword.Value = this.Password.Text;
cmd.Parameters.Add (PPassword);
con.Open ();
cmd.ExecuteNonQuery();
con.Close ();

Response.Write ( "注册成功,您已经成为我们的会员了. ");
------解决方案--------------------
注意access不要只读. 另外要有写入access文件的权限.
------解决方案--------------------
你先在web.config中使用身份模拟试试? <identity impersonate= "true " userName= "administrator " password= "233333333 "/> </system.web>