/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

1 vote185 views1 answer
Ef core set identity_insert off
C#
0 vote139 views1 answer
Händelsereportage
C#
0 vote185 views1 answer
Upgrade asp.net core to 5.0
C#
0 vote198 views1 answer
Unity ignore collision between two objects
C#
0 vote174 views2 answers
How to use K2 games Games parallax background
C#
1 vote201 views1 answer
C# datagridview row delete
C#
0 vote176 views1 answer
C# create class from parent class
C#
0 vote179 views1 answer
Unity magnetize a 3d object to cursor
C#
0 vote171 views1 answer
Wpf keyboard press event
C#
1 vote186 views1 answer
Time.timescale
C#