/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 vote324 views1 answer
C# inline question mark on object
C#
0 vote343 views1 answer
C# registrykey is null
C#
0 vote347 views1 answer
Read from textfile and fill in textbox
C#
0 vote376 views1 answer
Set time on audio source unity
C#Unity
0 vote380 views1 answer
How to prevent or terminate time's up screen from windows family safety windows service c#
C#
0 vote334 views1 answer
Provide inject vue
C#
0 vote349 views1 answer
C# decimal to fixed 2
C#
5 votes375 views1 answer
C# write variable in string
C#
0 vote346 views1 answer
Enum in method as argument c#
C#
1 vote405 views1 answer
Unity character controller ignore collision
C#Unity