/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 vote271 views1 answer
Substring c#
C#
0 vote255 views2 answers
Sars
C#
1 vote230 views3 answers
C# regex extract string between brackets
C#
0 vote204 views1 answer
Binary tree c#
C#
0 vote241 views1 answer
Monodevelop ubuntu 20.04
C#
0 vote219 views1 answer
Percentage random c#
C#
1 vote233 views1 answer
C# size of enum
C#
0 vote235 views1 answer
Defaultrequestheaders.authorization basic auth
C#
0 vote209 views1 answer
C# handle dbnull value
C#
0 vote214 views4 answers
C# code to check anagram
C#