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. :)

Categories: Geek Tags: , ,

ANTARA YANG MENARIK



[info] : Google Public Data Explorer


[facebook] : How to Download All Your Facebook Data


[info] : jQuery announce jQuery Mobile Project


[info] : Rumusan Framework dari PHP Meetup 2011 (Framework Shootout)
.

Apa pendapat anda?

Follow BEYTA.net di Twitter


18 queries. 0.538 seconds.
© 2011 BEYTA.network | Coders Republic - Certified by Microsoft as Profesional Developer
Beyta | Tajuzzaman bin Tajol Molok. MCPD. MCTS.