/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 vote122 views1 answer
Double tryparse dot comma
C#
1 vote93 views1 answer
C# remove accents
C#
0 vote88 views1 answer
Cs string to enum
C#
13 votes78 views2 answers
Lock mouse unity
C#Unity
1 vote126 views1 answer
Get string name of dropdown in unity
C#Unity
7 votes102 views4 answers
C# append text to file
C#
1 vote96 views2 answers
Trnasform ubnity
C#
27 votes94 views4 answers
How to get a length of a string in c#
C#
3 votes87 views2 answers
How to move mouse in c#
C#
8 votes88 views2 answers
Float to int c#
C#