Database connection with asp.net 3.5 using c#

Question

Hi friends, I want to know the db connection code for connecting oracle 11g with asp.net 3.5 using c# from the basic. Pls help me.

Sam Hobbs · Answer

ODBC is older technology and ADO is newer; it is better to use ADO .Net. There are things that Visual Studio can do for you to make things easier. I know that sometimes it is necessary to configure the VS Toolbox to make some tools available and I think that tools for Oracle are like that; in other words, I think that VS has some tools that you would not know about unless you configure VS for them.

Suthish Nair · Answer

The link posted by Krishna will help you to find actual connection string and Amit reply will help to query DB.

Amit Choudhary · Answer

Hi friend, using System.Data.Odbc; OdbcConnection con = new OdbcConnection(" "); try { con.Open(); } catch (System.Exception ex) { //Log your exception here for Connection could not created } OdbcCommand cmd = new OdbcCommand(" ",con); OdbcDataReader rdr= cmd.ExecuteReader(); Hope it helps you. Thanks. Please mark "Do you like this post?" if it helps you.

Krishna Garad · Answer

Hi see Here different ways of getting connection string. Refer

Syed Shakeer · Answer

Hi lakshmi, Check the below link for more details: http://www.connectionstrings.com/oracle

Database connection with asp.net 3.5 using c#

Answers (5)