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
|
Public Class edition_adherent_toute_cloture_pour_un_bureau
Dim connect As SqlConnection
Dim commande As SqlCommand
Dim reader As SqlDataReader
Private Sub edition_adherent_toute_cloture_pour_un_bureau_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
commande = New SqlCommand
connect = New SqlConnection
connect.ConnectionString = "server=XXXXXXXXX;Initial Catalog=XXXXXXX;User Id=XXXXXX; password =XXXXXXX ;"
commande.Connection = connect
connect.Open()
'affichage des numéros de dossier dans la combobox
'on fait la requete
commande.CommandText = "SELECT lib_agence FROM agence ORDER BY lib_agence ASC "
'on enregistre le resultat de la requete dans le reader
reader = commande.ExecuteReader
'on boucle tant qu'il y a des numéros de dossier
Do While reader.Read
combo_bureau.Items.Add(reader.GetValue(0))
Loop
'On ferme le reader à la fin de la boucle
reader.Close()
End Sub
Private Sub combo_bureau_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles combo_bureau.SelectedIndexChanged
Dim Report As New ReportDocument
Dim Dataset2 As New DataSet
Dim Conn As New SqlClient.SqlConnection("server=XXXXXX;Initial Catalog=XXXXXX;User Id=XXXXXX; password =XXXXXX ;")
Dim Dadap As New SqlClient.SqlDataAdapter("SELECT dossier.num_dossier, dossier.nom_client, dossier.prenom_client, dossier.date_adhesion, activite.lib_activite, regime.lib_regime, agence.lib_agence FROM dossier INNER JOIN activite ON dossier.code_activite = activite.code_activite INNER JOIN regime ON dossier.code_regime = regime.code_regime INNER JOIN agence ON dossier.code_agence = agence.code_agence WHERE (agence.lib_agence = '" & combo_bureau.Items.ToString & "')", Conn)
'ici on charge le rapport
Report.Load("F:\Resources\etat_adhesion_annee_par_bureau.rpt")
Try
'ici on charge le dataset
Dadap.Fill(Dataset2, "dossier, activite, regime, agence")
'On modifie la source de données
Report.SetDataSource(Dataset2)
'cas d'une impression direct avec l'imprimante par défaut
'Report.PrintToPrinter(Nbcopie, False, 0, 0)
'cas de la visualistaion dans le reportview
crv_multitable.ReportSource = Report
Catch ex As Exception
MessageBox.Show(ex.Message, ex.Source, MessageBoxButtons.OK)
End Try
End Sub
End Class |
Partager