/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 vote137 views1 answer
C# find process by name
C#
1 vote172 views1 answer
How to stop a coroutine unity c#
C#Unity
0 vote182 views1 answer
Take photo function in unity
C#Unity
6 votes181 views1 answer
Unity call function on animation finish
C#Unity
0 vote161 views1 answer
C# filter non alphanumeric characters
C#
3 votes144 views1 answer
Unity how to get y value
C#
1 vote254 views2 answers
String to xml c#
C#
54 votes201 views10 answers
Throw new error(
C#
0 vote136 views1 answer
When creating a new boolean column in an existing table how to set the default value as true in c# models code first
C#
3 votes143 views1 answer
Convert html to pdf c#
C#