/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

10 votes298 views3 answers
C# input
C#
8 votes313 views2 answers
Scaffold-DbContext
C#
5 votes310 views2 answers
C# download file
C#
0 vote313 views1 answer
Tune off exit button wpf
C#
0 vote303 views1 answer
How to uncheck a radio button in c#
C#
0 vote335 views1 answer
How to remove all comma from string c#
C#
0 vote332 views1 answer
Worldtimebuddy
C#
2 votes301 views1 answer
C# previous method
C#
0 vote320 views1 answer
On GAMEOBJECT enable unity
C#
1 vote281 views1 answer
Get last element in a list vb.net
C#