高手调试 立马给分 修正一下 ! 高手调试 立马给分 ! 高手调试 立马给分 !
<% @import namespace="system.data" %>
<% @import namespace="system.data.ado" %>
<%
dim str as string
str="provider=sqloledb;data source=(local);initial catalog=pubs;"
dim objconn as ADOConnection
objconn=new ADOConnection
objconn.connectionstring=str
objconn.open()
dim strsql as string="select * from authors"
dim objdscommand as adodatasetcommand
dim objdataset as dataset=new dataset
objdscommand= new adodatasetcommand(strsql,objconn)
objdscommand.filldataset(objdataset,"autnfor")
objconn.close()
objconn=nothing
au.datasource=objdataset.tables("autnfor").defaultview
au.databind()
%>
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<asp:datagrid id="au" runat="server"/>
</body>
</html>
我是初学者 ,用的是sql2000, 文件122.aspx存在桌面上,在IIS中并发布浏览时出现错误:
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC30002: Type 'ADOConnection' is not defined.
Source Error:
Line 4: dim str as string
Line 5: str="provider=sqloledb;data source=(local);initial catalog=pubs;"
Line 6: dim objconn as ADOConnection
Line 7: objconn=new ADOConnection
Line 8: objconn.connectionstring=str
Source File: D:\Documents and Settings\lsz1\桌面\122.aspx Line: 6