/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 vote378 views1 answer
On collision enter by layer 2d unity
C#Unity
0 vote333 views1 answer
Select distinct two columns entity framework c#
C#
2 votes348 views1 answer
Linq query select top 1 c#
C#
6 votes315 views6 answers
Rigidbody velocity
C#
1 vote322 views2 answers
Unity change material at runtime
C#
9 votes337 views3 answers
Switch case with 2 variables c#
C#
20 votes342 views4 answers
How to change scenes in unity
C#Unity
8 votes384 views1 answer
Point to mouse 2D Unity
C#Unity
0 vote308 views2 answers
Declare prop array c#
C#
-1 vote303 views1 answer
C# reverse a string for loop
C#