/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 vote188 views1 answer
C# split include separators
C#
0 vote194 views1 answer
C# substring until character single
C#
24 votes217 views2 answers
How to destroy an object in unity
C#
0 vote170 views1 answer
Solidity get address of contract
C#
12 votes194 views6 answers
Ternary operator c#
C#
0 vote184 views1 answer
C# apend row in text fole txt
C#
0 vote229 views1 answer
C# change to different form
C#
0 vote180 views1 answer
C# loop through repeater items
C#
0 vote185 views1 answer
C# find a wav file
C#
0 vote179 views1 answer
Query associative table ef6
C#