/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

1 vote115 views1 answer
C# store strings in file
C#
-1 vote131 views1 answer
C# push numbers to array
C#
0 vote106 views1 answer
Binary search tree c# stackoverflow
C#
1 vote128 views1 answer
.net core add header to soap request
C#
1 vote134 views1 answer
Mvc list to jsonresult
C#
1 vote110 views1 answer
C# wpf change label text color
C#
0 vote139 views1 answer
.net framework cheat sheet
C#
17 votes147 views3 answers
Unity get list of children
C#Unity
4 votes122 views1 answer
How to destroy a gameobject in c#
C#
0 vote115 views1 answer
Unity animation length
C#