/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 vote230 views3 answers
Logical operators in c#
C#
0 vote222 views1 answer
How to make a block disappear in unity
C#
8 votes246 views4 answers
C# get last two characters of string
C#
0 vote239 views1 answer
Tempdata serializer cannot erorr
C#
0 vote238 views1 answer
Wpf bind to self
C#
1 vote239 views1 answer
Decalre an int list mvc
C#
0 vote243 views1 answer
Mvc c# return renderPartial
C#
-1 vote279 views1 answer
How to fix error cs1513 in unity
C#Unity
0 vote242 views1 answer
Sqlsinifi.baglanti.open()
C#
1 vote233 views1 answer
Iactionresult
C#