有关数据库的问题
Dim conn As OleDbConnection
conn = New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("user.mdb")
'conn.Open()
Dim Cmd As OleDbCommand
Dim strSQL As String
strSQL = "INSERT INTO REG VALUES('" & txtID.Text & "','"
strSQL &= txtPWD.Text & "','" & txtEMail.Text & "','"
strSQL &= txtAddr.Text & "','" & txtPhone.Text & "','"
strSQL &= rbtnlstSex.SelectedItem.Value & "','" & txtBirth.Text & "')"
Cmd = New OleDbCommand(strSQL, conn)
Cmd.Connection.Open()
Try
Cmd.ExecuteNonQuery()
Catch ex As InvalidOperationException
Response.Write("数据库出错!")
conn.Close()
Exit Sub
End Try
Response.Write("恭喜,您已经注册成功了!")
conn.Close()
以上操作,给出下列错误信息,是怎么回事啊?
异常详细信息: System.Data.OleDb.OleDbException: 操作必须使用一个可更新的查询。
源错误:
行 153:
行 154: Try
行 155: Cmd.ExecuteNonQuery()
行 156: Catch ex As InvalidOperationException
行 157: Response.Write("数据库出错!")
源文件: D:\Program\Inetpub\wwwroot\MyWork\Reg.aspx.vb 行: 155
堆栈跟踪:
[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
MyWork.Reg.btnConfirm_Click(Object sender, EventArgs e) in D:\Program\Inetpub\wwwroot\MyWork\Reg.aspx.vb:155
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