怎么用asp.net 与oracle73连接啊!用VB语法 命名空间都不会,我很菜的
最好给个实例 谢谢各位大虾了!!!
我是这样写的 老抱错啊!
<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data.OracleClient;" %>
<%@ Import Namespace="System.Data" %>
<%
dim cmd,odr,OracleConnection
Dim SQLConnString As String="Data Source=dbcustomb;user=dbocustom;password=pwcustom;"
Dim conn As New OracleConnection(SQLConnString) conn.open()
OracleCommand cmd=conn.CreateCommand(); cmd.CommandText="select name from MyTable";//在这儿写sql语句
OracleDataReader odr=cmd.ExecuteReader();//创建一个OracleDateReader对象 Dim fNextResult As Boolean = True
Do Until Not fNextResult Do While ord.Read()
response.write ( odr.GetOracleString(0).ToString())
Loop
fNextResult = odr.NextResult()
Loop
odr.Close() conn.close()
%>
最好给个实例 谢谢各位大虾了!!!
我是这样写的 老抱错啊!
<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data.OracleClient;" %>
<%@ Import Namespace="System.Data" %>
<%
dim cmd,odr,OracleConnection
Dim SQLConnString As String="Data Source=dbcustomb;user=dbocustom;password=pwcustom;"
Dim conn As New OracleConnection(SQLConnString) conn.open()
OracleCommand cmd=conn.CreateCommand(); cmd.CommandText="select name from MyTable";//在这儿写sql语句
OracleDataReader odr=cmd.ExecuteReader();//创建一个OracleDateReader对象 Dim fNextResult As Boolean = True
Do Until Not fNextResult Do While ord.Read()
response.write ( odr.GetOracleString(0).ToString())
Loop
fNextResult = odr.NextResult()
Loop
odr.Close() conn.close()
%>
Dim myConnString As String = _
"Data Source=Oracle8i;Integrated Security=yes"
Dim myConnection As New OracleConnection(myConnString)
myConnection.Open()
...
myConnection.Close()
End Sub
BC30002: 未定义类型“OracleConnection”