/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

40 votes142 views3 answers
Unity print to console
C#
2 votes101 views1 answer
C# program that uses array, yield keyword
C#
0 vote120 views1 answer
Unity deadzone
C#
0 vote152 views1 answer
How to run code without a gameobject unity
C#Unity
0 vote110 views1 answer
Populate toolstripitems to combobox
C#
0 vote106 views2 answers
Unity slider decimal 0.01
C#
0 vote102 views1 answer
Accord.io read .mat file
C#
0 vote112 views2 answers
Streamwriter c#
C#
1 vote111 views1 answer
Get 2d rotation from 2 position math
C#
1 vote142 views1 answer
C# unity get lines
C#Unity