1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
static void Main(string[] args)
{
//-------------------------------ORACLE 10G XE---------------------------------------------------------
string Ochaine = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.3)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)));User Id=Damien;Password=Damien;Connection Lifetime=120;Persist Security Info=False;";
OracleConnection OConnexion = new OracleConnection();
OConnexion.ConnectionString = Ochaine;
try
{
OConnexion.Open();
Console.WriteLine("Connexion Oracle ouverte");
OracleCommand query = new OracleCommand();
query.Connection = OConnexion;
query.CommandText = "SELECT * FROM etudiant";
OracleDataReader reader;
reader = query.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader[0].ToString());
}
OConnexion.Close();
Console.WriteLine("Connexion Oracle fermée");
}
catch(Exception e)
{
Console.WriteLine(e);
}
Console.WriteLine("");
//---------------------------MySql---------------------------------------------
string Pchaine = "Server=192.168.0.3;Database=test;Uid=Dam;Pwd=Dam;";
MySqlConnection Pconnexion = new MySqlConnection();
Pconnexion.ConnectionString = Pchaine;
try
{
Pconnexion.Open();
Console.WriteLine("Connexion MySql ouverte");
MySqlCommand cmd = Pconnexion.CreateCommand();
MySqlDataReader reader;
cmd.CommandText = "SELECT * FROM essai";
reader = cmd.ExecuteReader();
while(reader.Read())
{
Console.WriteLine(reader[0].ToString());
}
Pconnexion.Close();
Console.WriteLine("Connexion MySql fermée");
}
catch(Exception e)
{
Console.WriteLine(e);
}
} |
