62,041
社区成员
发帖
与我相关
我的任务
分享ado.net操作数据库最简单的问题！
一段程序是这样的：
<%@import namespace=system.data%>
<%@import namespace=system.data.ado%>
<html>
<script language="vb" runat="server">
sub page_load(sender as object , e as eventargs)
dim cna as ADOConnection=New ADOConnection
cna.connectionstring= _
"provider=microsoft.jet.oledb.4.0;"& _
"data source=d:\asp.net\myweb.mdb;" & _
"User id=admin"
cna.open
end sub
</script>
</html>
但不能编译通过，出错信息如下：
Line 8: dim cna as ADOConnection=New ADOConnection
Compiler Error Message: BC30002: Type 'ADOConnection' is not defined.
要怎么解决！？
<%@import namespace=system.data%>
<%@import namespace=system.data.ado%>
<html>
<script language="vb" runat="server">
sub page_load(sender as object , e as eventargs)
dim cna as ADOConnection=New ADOConnection
cna.connectionstring= _
"provider=microsoft.jet.oledb.4.0;"& _
"data source=d:\asp.net\myweb.mdb;" & _
"User id=admin"
cna.open
end sub
</script>
</html>
但不能编译通过，出错信息如下：
Line 8: dim cna as ADOConnection=New ADOConnection
Compiler Error Message: BC30002: Type 'ADOConnection' is not defined.
要怎么解决！？
...全文
请发表友善的回复…
发表回复
folek 2003-10-20
- 打赏
- 举报
可能搂主的参考资料老了点
Abac 2003-10-20
- 打赏
- 举报
没有system.data.ado的namespace，用OleDb或者SqlClient吧
guoyan19811021 2003-10-20
- 打赏
- 举报
使用ado.net
dim cna as SqlConnection=New SqlConnection("server=localhost;uid=sa;pwd=sa;database=aaa")
dim conn as oledbconnection=new oledbconnection( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Tax.mdb")
dim cna as SqlConnection=New SqlConnection("server=localhost;uid=sa;pwd=sa;database=aaa")
dim conn as oledbconnection=new oledbconnection( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Tax.mdb")
pairs 2003-10-20
- 打赏
- 举报
<%@ Import Namespace="System.Data.SqlClient"%>
dim cna as SqlConnection=New SqlConnection()
dim cna as SqlConnection=New SqlConnection()
比尔咔咔 2003-10-20
- 打赏
- 举报
<%@import namespace=system.data.oledb%>
yaotiebing 2003-10-20
- 打赏
- 举报
System.Data.SqlClient.SqlConnection 用这个吧！~！！
ADOConnection 需要添加引用的！！
ADOConnection 需要添加引用的！！
lucidaxy 2003-10-20
- 打赏
- 举报
dim cna as System.Data.SqlClient.SqlConnection=New System.Data.SqlClient.SqlConnection()
lucidaxy 2003-10-20
- 打赏
- 举报
dim cna as System.Data.SqlClient.SqlConnection=New System.Data.SqlClient.SqlConnection
