oracle connectivity through asp.net

Question

i want a complete connection string of how to add oracle database to the website in asp.net...

Sanjeeb Lenka · Answer

check these links http://docs.oracle.com/cd/B28359_01/appdev.111/b28844/using_aspnt.htm or you can follow these steps 1) Add reference of Oracle database client library. Right click on "Add Reference" inside your project. From Add Reference dialog box click on ".Net" tab Select "System.Data.OracleClient" from Component Name Click "OK" button to add reference. 2) Inside Web.Config File, Add connection string connectionString="Data Source= ;User ID= ;Password= ;Persist Security Info=True;Connection Lifetime=10" providerName="System.Data.OracleClient"> Now you are ready to make oracle connection Add following function in your code file. 3) Function to read oracle connection string from web.config file. private OracleConnection GetConnection() { var conString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnStr"]; string strConnString = conString.ConnectionString; return new OracleConnection(strConnString); } 4) Call GetConnection function to use oracle connection in your code. //Sample code to open and close oracle connection protected void Page_Load(object sender, EventArgs e) { OracleConnection oConn = GetConnection(); if (oConn != null) { oConn.Open(); oConn.Close(); } }

oracle connectivity through asp.net

Answers (1)