C#读取access数据库问题求助
string strAddString = "INSERT INTO userinfo ( userID ) VALUES ('"+userID.Text+"')";
string strConnection = "Provider=Microsoft.JET.OLEDB.4.0;Data Source="+Server.MapPath("")+"\\user.mdb";
LoginConnection = new OleDbConnection( strConnection) ;
OleDbCommand LoginCmd = new OleDbCommand( strAddString, LoginConnection ) ;
Label12.Text= strConnection ;
LoginCmd.Connection.Open() ;
LoginCmd.ExecuteNonQuery();
LoginConnection.Close() ;
执行错误:
[OleDbException (0x80004005): 操作必须使用一个可更新的查询。]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +154
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +54
WebLogin.DesktopDefault.AddNewUser() +194
WebLogin.DesktopDefault.submit_Click(Object sender, EventArgs e) +645
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1263
--
我的开发平台:winxp,VS.net 9486,已安装asp..net环境