/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 vote286 views2 answers
C# linq unique by property
C#
0 vote277 views1 answer
Unity pickup and drop objects
C#Unity
0 vote253 views1 answer
Static variable in c#
C#
0 vote263 views1 answer
Monogame button
C#
0 vote294 views1 answer
Unity make a gambeobject array
C#Unity
2 votes252 views1 answer
Unity c# throw exception
C#
0 vote255 views1 answer
User control equivalent event for form.shown c#
C#
33 votes272 views5 answers
String to datetime c#
C#
0 vote258 views1 answer
Autho close in persian time picker
C#
0 vote251 views1 answer
Linq query languages
C#