/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

3 votes308 views4 answers
C# initialize empty array
C#
0 vote312 views1 answer
Force overwrite c#
C#
0 vote277 views1 answer
Visual studio console.writeline not showing in output window
C#
0 vote315 views1 answer
C# solution path
C#
7 votes323 views4 answers
Open folder dialog c#
C#
30 votes279 views3 answers
C# if file exists
C#
2 votes301 views1 answer
Play a sound c#
C#
1 vote297 views1 answer
C# ascii to char
C#
1 vote282 views1 answer
Unity C# make object face away
C#
5 votes286 views2 answers
How to exit application c# console
C#