1 2 3 4 5 6 7 8 9 10 11 12
| req = "SELECT '" + logo + "'+ EQUIPES.logo + '" + logo_fin + "',Match.EQUIPE1,Match.EQUIPE2,cast(Match.but_1 as varchar(2))+ '-' +cast(Match.but_2 as varchar(2)) as score "
req = req + " FROM Match, EQUIPES"
req = req + " WHERE(Match.journee = 1)"
req = req + " AND Match.EQUIPE1 = EQUIPES.NOM"
req2 = "select nom_equipe as Equipe,Classement,Victoire, Nul, Defaite as Défaite,Points,Difference from classement_GEN order by CLASSEMENT asc"
Dim dt As New DataTable
Using query As New SqlCommand(req, sqlConnection1)
Using adapt As New SqlDataAdapter(query)
adapt.Fill(dt)
End Using
End Using |
Partager