/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

4 votes112 views2 answers
C# remove word from string
C#
1 vote118 views1 answer
C# loop through array of objet
C#
-1 vote118 views4 answers
How to exit winforms application and shutdown pc in c#
C#
0 vote112 views1 answer
Get date of tomorrow c#
C#
3 votes107 views2 answers
Unity cos
C#
4 votes113 views1 answer
C# loop datatable rows
C#
0 vote108 views1 answer
C# list any retun indec
C#
2 votes128 views2 answers
Unity left mouse button
C#Unity
2 votes121 views1 answer
C# Switch and case
C#
1 vote127 views1 answer
The type or namespace name 'Scrollbar' could not be found
C#