| 12
 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
 
 | private void recherche_Click(object sender, EventArgs e){
            try {                
                string chaineDeConnection = "dsn=exam";
                Connection = new OdbcConnection(chaineDeConnection);                                                            
                Connection.ConnectionString = chaineDeConnection;                
                Connection.Open();
                string stCmd = "SELECT * FROM dept where deptno=" + code.Text;
                OdbcCommand ODC = new OdbcCommand(stCmd, Connection);
                OdbcDataReader ODR;
                ODR = ODC.ExecuteReader();
                if (ODR.HasRows)
                {
                    while (ODR.Read())
                    {
                        int v1 = ODR[0];
                        string v2 = ODR[1];                     
                        Form2 ff = new Form2(v1, v2);
                        ff.Show();
 
                    }
 
                }
                else
                {
                    MessageBox.Show("aucun résultat");
 
                }
 
 
            }
            catch (OdbcException ex)            {
                MessageBox.Show("Probleme de source de données");
            }
            finally
            {             
            }
 
        } | 
Partager