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
| ''Tous les champs Tireurs + Id et nom Societe
sGrilleTireurs = "T_Nom, T_Prenom, T_Licence, T_DateNaiss, T_Npa, T_Localite, " & _
"S_NomSociete, T_IdTireur, T_IdSociete, S_IdSociete "
sStrSql = "SELECT " & sGrilleTireurs & "FROM Societe S, Tireurs T WHERE S.S_IdSociete = T.T_IdSociete " & _
"ORDER BY T_Nom, T_Prenom"
OuvreBase(sStrSql, "cl25m.mdb", "Tireurs")
''INIT GRID SELECTION TIREURS
''Ajoute ue ligne le DataGridView
dgvTireurs.ColumnCount = 9
For i = 0 To Cl25m_DataTable.Rows.Count() - 1
dgvTireurs.Rows.Add(Cl25m_DataTable.Rows(i).Item("T_nom"), Cl25m_DataTable.Rows(i).Item("T_Prenom"), _
Cl25m_DataTable.Rows(i).Item("T_Licence"), Cl25m_DataTable.Rows(i).Item("T_DateNaiss"), _
Cl25m_DataTable.Rows(i).Item("T_Npa"), Cl25m_DataTable.Rows(i).Item("T_Localite"), _
Cl25m_DataTable.Rows(i).Item("S_NomSociete"), Cl25m_DataTable.Rows(i).Item("T_IdTireur"), _
Cl25m_DataTable.Rows(i).Item("T_IdSociete"))
Next
With Me.dgvTireurs
.Columns(2).Width = 55
.Columns(3).Width = 85
.Columns(4).Width = 45
.Columns(5).Width = 131
.Columns(6).Width = 200
.Columns(0).HeaderText = "Nom"
.Columns(1).HeaderText = "Rrénom"
.Columns(2).HeaderText = "Licence"
.Columns(3).HeaderText = "Date Naiss"
.Columns(4).HeaderText = "Npa"
.Columns(5).HeaderText = "Localitél"
.Columns(6).HeaderText = "Société"
.Columns(7).Visible = False ''T_IdTireur
.Columns(8).Visible = False ''T_IdSociete
.Columns(2).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
.Columns(3).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
.Columns(4).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight
.SelectionMode = DataGridViewSelectionMode.FullRowSelect
.MultiSelect = False
''Empêche l'utilisateur de redimensionner la largeur des colonnes
.AllowUserToResizeColumns = False
.RowsDefaultCellStyle.BackColor = Color.White
.AlternatingRowsDefaultCellStyle.BackColor = Color.AliceBlue
End With |
Partager