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
| 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