/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 vote162 views1 answer
How to get executable path in wpf
C#
0 vote139 views1 answer
Query associative table ef6
C#
0 vote145 views1 answer
How to sign in with your unity id in unity hub
C#
0 vote134 views1 answer
SonarQube UnitTests
C#
9 votes203 views2 answers
Quit button unity
C#Unity
0 vote155 views1 answer
SQLite Execute
C#
1 vote148 views1 answer
C# put string to clipboard
C#
2 votes136 views2 answers
C# loop backwards
C#
7 votes140 views1 answer
Unity change tag in script
C#
1 vote148 views1 answer
C# public static string
C#