高手们帮忙啊！！

[Tikyliu]

代码如下：
<%@ 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。望各位大哥指教，多谢先！！！

[LoveCherry]

替换ado为oledb
你这是老的写法了

[AllenTing]

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

[Tikyliu]

多谢楼上两位，可是这样子写竟然还是报错啊！！
错误类型如下：
编译器错误信息: 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>

[gxboy]

ExecuteScalar
执行查询，并返回查询所返回的结果集中第一行的第一列。忽略额外的列或行。

ExecuteNonQuery
针对 Connection 执行 SQL 语句并返回受影响的行数。

ExecuteReader
将 CommandText 发送到 Connection 并生成一个 OdbcDataReader。

[Tikyliu]

怎么样结账啊？为何总是提示你“输入的不是数字！”

[Tikyliu]

搞定，多谢了！各位大虾！！