.net 连接oracle

ss = "orcl"

Dim myConnection As Data.OleDb.OleDbConnection

Dim myOracleDataAdapter As Data.OleDb.OleDbDataAdapter myConnection = New Data.OleDb.OleDbConnection("Provider=OraOLEDB.Oracle;Data Source=" + ss + ";user id=scott;password=tiger")

myOracleDataAdapter = New Data.OleDb.OleDbDataAdapter("select 'aa' from dual", myConnection)

 Dim myDataSet As Data.DataSet = New Data.DataSet() myOracleDataAdapter.Fill(myDataSet, "dual") Response.Write(txtName.Text + myDataSet.Tables("dual").Rows(0)(0