/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 vote295 views1 answer
C# see if string is int
C#
2 votes278 views1 answer
How to reset rotation in unity
C#
45 votes279 views3 answers
Scenemanager.loadscene
C#
0 vote313 views1 answer
Unity create cube in script
C#Unity
1 vote316 views1 answer
2d ray unity
C#Unity
0 vote291 views2 answers
Add buttons to taskbar thumbnail WPF
C#
0 vote279 views1 answer
How to detach the camera from the player after death unity
C#
17 votes211 views1 answer
Check if dictionary contains value c#
C#
10 votes263 views2 answers
C# unity get name of object
C#
1 vote260 views1 answer
C# winforms textbox readonly
C#