/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 vote192 views2 answers
C# string verbatim
C#
0 vote195 views1 answer
SendFileAsync discord
C#
0 vote248 views1 answer
Gravity script unity
C#Unity
0 vote195 views1 answer
C# generate guid from hash
C#
0 vote193 views1 answer
C# ienumerable unassigned
C#
0 vote199 views1 answer
Unity reset random seed
C#
0 vote190 views1 answer
Linq find object from id
C#
0 vote174 views1 answer
Convert list of tuples to dictionary c#
C#
0 vote184 views1 answer
Lcm of list of number
C#
0 vote262 views1 answer
Unity slider not empty
C#Unity