代码如下:
<%@ Import Namespace="System.Data.OleDb"%>
<%@ Import NameSpace="System.Data"%>
<Script Language="VB" Runat="Server">
Sub Button1_Click(Sender AS Object,e AS Eventargs)
Dim cnA AS ADOConnection=New ADOConnection
Dim cmA AS ADOCommand=New ADOCommand
cnA.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"& _
"Data Source=DB\Tiky.mdb;" & _
"User ID=Admin"
cnA.Open
cmA.ActiveConnection=cnA
cmA.CommandType=CommandType.Text
cmA.CommandText=Text1.Value
cmA.Execute
End Sub
</Script>错误类型如下:
编译器错误信息: BC30002: 未定义类型“ADOConnection”。源错误:
<Script Language="VB" Runat="Server">
Sub Button1_Click(Sender AS Object,e AS Eventargs)
Dim cnA AS ADOConnection=New ADOConnection
Dim cmA AS ADOCommand=New ADOCommand
cnA.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"& _小弟初学ASP.net。望各位大哥指教,多谢先!!!
<%@ Import Namespace="System.Data.OleDb"%>
<%@ Import NameSpace="System.Data"%>
<Script Language="VB" Runat="Server">
Sub Button1_Click(Sender AS Object,e AS Eventargs)
Dim cnA AS ADOConnection=New ADOConnection
Dim cmA AS ADOCommand=New ADOCommand
cnA.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"& _
"Data Source=DB\Tiky.mdb;" & _
"User ID=Admin"
cnA.Open
cmA.ActiveConnection=cnA
cmA.CommandType=CommandType.Text
cmA.CommandText=Text1.Value
cmA.Execute
End Sub
</Script>错误类型如下:
编译器错误信息: BC30002: 未定义类型“ADOConnection”。源错误:
<Script Language="VB" Runat="Server">
Sub Button1_Click(Sender AS Object,e AS Eventargs)
Dim cnA AS ADOConnection=New ADOConnection
Dim cmA AS ADOCommand=New ADOCommand
cnA.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"& _小弟初学ASP.net。望各位大哥指教,多谢先!!!
解决方案 »
- 服务器端控件和客户端控件的区别:var textbox = document.getElementByID(?)
- 史无前列的错误的..NND
- 請大家幫我看下為什麼事件沒反應
- C#中怎么样调用oracle里function方法。
- 如何在主框架中写代码对子框架进行不同的页面装载
- ASP.net 2.0SQL连接问题
- 连接oracle ORA-12154: TNS:could not resolve the connect identifier specified
- 关于DATASET和DATAGRID的几个问题~~
- DropDownList的问题!送分哦
- 有深度问题:aspx文件中html代码<head></head>中的内容的作用?
- 一时搞不清了:如何在datagrid中直接将数据表中0,1 转换为否,是?在线等
- 如何取得DATALIST中某条记录的一个值??(急问)
你这是老的写法了
Dim cmA AS oledbCommand=New oledbCommand
cnA.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"& _
"Data Source=DB\Tiky.mdb;" & _
"User ID=Admin"
cnA.Open
cmA.Connection=cnA
cmA.CommandType=CommandType.Text
cmA.CommandText=Text1.Value
cmA.Execute
错误类型如下:
编译器错误信息: BC30456: “Execute”不是“System.Data.OleDb.OleDbCommand”的成员。代码如下:
<%@ Import Namespace="System.Data.OleDb"%>
<%@ Import NameSpace="System.Data"%>
<Script Language="VB" Runat="Server">
Sub Button1_Click(Sender AS Object,e AS Eventargs)
Dim cnA AS oledbConnection=New oledbConnection
Dim cmA AS oledbCommand=New oledbCommand
cnA.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"& _
"Data Source=DB\Tiky.mdb;" & _
"User ID=Admin"
cnA.Open
cmA.Connection=cnA
cmA.CommandType=CommandType.Text
cmA.CommandText=Text1.Value
cmA.Execute End Sub
</Script>
执行查询,并返回查询所返回的结果集中第一行的第一列。忽略额外的列或行。ExecuteNonQuery
针对 Connection 执行 SQL 语句并返回受影响的行数。ExecuteReader
将 CommandText 发送到 Connection 并生成一个 OdbcDataReader。