/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 vote322 views1 answer
CS0234 compile error c# unity fix scene managment
C#
0 vote331 views1 answer
Cs close opened form when reopened
C#
2 votes388 views1 answer
Get position of gameobject unity
C#Unity
0 vote340 views1 answer
Initalize C# project in VS Code
C#
0 vote326 views1 answer
Maximize window c# console
C#
0 vote379 views1 answer
Write last element of dictionary c#
C#
3 votes356 views2 answers
C# GetType
C#
0 vote332 views1 answer
How to determine whether Task.Run is completed within a loop in c#
C#
0 vote353 views1 answer
Internal static object ds
C#
5 votes337 views1 answer
How to change rotate with script unity
C#