/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 vote158 views1 answer
New guid c# always returns 0
C#
2 votes137 views1 answer
Add all elements in a list c#
C#
0 vote138 views1 answer
C# Create Swiss QR-Bill API
C#
0 vote122 views1 answer
Eager loading c#
C#
28 votes173 views3 answers
Delay in unity
C#Unity
0 vote124 views1 answer
C# read GroupComponent using regex
C#
1 vote128 views1 answer
Unity 2d player move
C#
0 vote164 views1 answer
Unity 2D mouse look at cursor
C#Unity
0 vote144 views2 answers
Linq datatable
C#
0 vote135 views1 answer
Resharper render pages folder asp.net core
C#