/C#/Conncet oracle database in c# visual studio

Conncet oracle database in c# visual studio

string oradb = "Data Source=ORCL;User Id=hr;Password=hr;";
OracleConnection conn = new OracleConnection(oradb);  // C#
conn.Open(); 
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select department_name from departments where department_id = 10";
cmd.CommandType = CommandType.Text; 
OracleDataReader dr = cmd.ExecuteReader();
dr.Read();
label1.Text = dr.GetString(0);
conn.Dispose();

Source: oracle.com

Similar codes

0 vote232 views3 answers
Www.elking.net
C#
1 vote174 views1 answer
C# separate string by a new line
C#
1 vote218 views1 answer
System.io.directorynotfoundexception c#
C#
7 votes179 views2 answers
Open link c#
C#
0 vote177 views1 answer
Finding minimum in c#
C#
8 votes166 views3 answers
C# check if string is directory
C#
0 vote159 views1 answer
How to change something in the window using a thread wpf
C#
11 votes186 views4 answers
C# remove all whitespaces from string
C#
1 vote173 views1 answer
C# unity camera follow player horizontal axis
C#
0 vote166 views1 answer
Unity time.fixeddeltatime
C#