您所在位置：主题：求救
sxczhhw
[专家分：70] 发布于 2006-12-05 18:53:00
我做了一个简单的网页，可是在IE中却显示：
[b]操作必须使用一个可更新的查询[/b]。
（Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: 操作必须使用一个可更新的查询。
Source Error: .......)
也不知道是怎么回事。
我的网页中代码如下：
<%@ import namespace="system.data.sqlclient"%>
<%@ import namespace="system.data.oledb"%>
大家帮我看一下吧！
<%@ import namespace="system.data"%>
<%@ Page Language="VB" debug="true" ContentType="text/html" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<script runat="server">
Sub clickevent(sender As Object, E As EventArgs)
dim strconn as string="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("school.mdb")
dim objconn as new system.data.oledb.oledbconnection(strconn)
dim strsql as string="insert into student(ID,name) values('"& txtID.text &"','"& txtNAME.text &"')"
dim objcomm as new system.data.oledb.oledbcommand(strsql,objconn)
objconn.open
objcomm.executenonquery()
End Sub
</script>
<body>
<form runat="server">
用户号：<asp:TextBox ID="txtID" runat="server" />
用户名：<asp:TextBox ID="txtNAME" runat="server" />
<asp:Button ID="btn" runat="server" Text="提交" OnClick="clickevent" />
</form>
</body>
</html>
[b]操作必须使用一个可更新的查询[/b]。
（Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: 操作必须使用一个可更新的查询。
Source Error: .......)
也不知道是怎么回事。
我的网页中代码如下：
<%@ import namespace="system.data.sqlclient"%>
<%@ import namespace="system.data.oledb"%>
大家帮我看一下吧！
<%@ import namespace="system.data"%>
<%@ Page Language="VB" debug="true" ContentType="text/html" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<script runat="server">
Sub clickevent(sender As Object, E As EventArgs)
dim strconn as string="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("school.mdb")
dim objconn as new system.data.oledb.oledbconnection(strconn)
dim strsql as string="insert into student(ID,name) values('"& txtID.text &"','"& txtNAME.text &"')"
dim objcomm as new system.data.oledb.oledbcommand(strsql,objconn)
objconn.open
objcomm.executenonquery()
End Sub
</script>
<body>
<form runat="server">
用户号：<asp:TextBox ID="txtID" runat="server" />
用户名：<asp:TextBox ID="txtNAME" runat="server" />
<asp:Button ID="btn" runat="server" Text="提交" OnClick="clickevent" />
</form>
</body>
</html>
