/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 vote199 views1 answer
How to get relative path in c#
C#
7 votes178 views5 answers
C# or
C#
3 votes182 views1 answer
C# save pdf stream to file
C#
22 votes181 views5 answers
C# list of strings
C#
0 vote212 views1 answer
C# wpf image source from resource programmatically
C#
0 vote189 views1 answer
C# get all namespaces in assembly
C#
2 votes206 views1 answer
How to make a resizable window in monogame
C#
26 votes178 views2 answers
Declare dictionary c#
C#
34 votes217 views3 answers
Setactive unity
C#
46 votes186 views6 answers
Instantiate prefab unity
C#