/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

6 votes118 views1 answer
How to make rb.addforce 2d
C#
3 votes118 views2 answers
C# add 2 arrays
C#
-1 vote114 views1 answer
C# datagridview count value
C#
6 votes117 views1 answer
Unity call function on animation end
C#
0 vote157 views1 answer
Unity invisible cube
C#Unity
0 vote112 views1 answer
On GAMEOBJECT enable unity
C#
0 vote156 views1 answer
Tooltip button winform
C#
0 vote184 views1 answer
C# move form without border
C#
1 vote122 views1 answer
How to change the extension of a file C#
C#
0 vote151 views1 answer
Find Center Of Transforms, Points, Multiple Objects
C#