August 15th, 2011
Geek ASP #01 – Oracle .NET Data Provider

Oracle .NET Data Provider merupakan satu komponen di dalam .NET Framework yang menyediakan akses kepada Oracle Database menggunakan Oracle Call Interface (OCI) yang tersediaa pada perisian Oracle Client.
VB.NET SAMPLE #01 – Basic configuration (Konfigurasi Asas)
Imports System.Data.OracleClient Dim oOracleConn as OracleConnection = New OracleConnection() oOracleConn.ConnectionString = "Data Source=localhost; " & _ "Persist Security Info=True; " & _ "User ID=yourid;Password=yourpass;Unicode=True" oOracleConn.Open()
VB.NET SAMPLE #02 – Configure a connection string for oracle in the Web.config file
Di Web.config, tambahkan ConnectionStrings element di dalam Configuration element
<connectionStrings> <add name="MyOracleConnectionString" connectionString="Data Source=localhost; Persist Security Info=True; User ID=yourid; Password=yourpass; Unicode=True" providerName="System.Data.OracleClient" /> </connectionStrings>
Kemudian untuk menerima connectionStrings tersebut di form anda…
Imports System.Web.Configuration
Imports System.Data.OracleClient
Dim oOracleConn as OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = & _
ConfigurationManager.ConnectionStrings("MyOracleConnectionString").ConnectionString
Itu sahaja untuk kali ini.. Semoga ia dapat membantu anda.. Terima kasih. :)





