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
|
try
{
string strSql;
MySqlConnection mycon = new MySqlConnection(_MySql.Connection);
mycon.Open();
strSql = "SELECT sp.id_sport, " +
" sp.description, " +
" a.ind_actif, " +
" a.couleur " +
"FROM Sports sp, " +
" Athletes_Sports a " +
"WHERE sp.id_sport = a.id_sport " +
"AND a.id_athlete = " + _athlete.IdAthlete;
MySqlDataAdapter daSports = new MySqlDataAdapter(strSql, mycon);
daSports.Fill(dsSports, "Sports");
this.bsSports.DataSource = dsSports.Tables["Sports"];
this.dgSports.DataSource = this.bsSports;
}
catch (MySqlException ex)
{
} |
Partager