Public Sub charger_grid_view(ByVal maform As String, ByVal req As String, ByVal gv As DataGridView) Try dt.Clear() cmd.CommandText = req dr = cmd.ExecuteReader dt.Load(dr) With maform gv.DataSource = dt End With Catch ex As Exception MsgBox(ex.ToString) End Try dr.Close() End Sub '------------------------------------------------------- Public Sub connection() cmd.Connection = con cmd.CommandType = CommandType.Text Try con.Open() If con.State <> ConnectionState.Open Then MsgBox("Erreur de connection", 0 + 48, "Erreur") End If Catch ex As Exception MsgBox(ex.ToString) End Try End Sub
Private Sub Articles_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load connection() maform = Me.Name reqTot = "select article, um, idarticle from tbl_article" '------------------------------- charger_grid_view(maform, reqTot, TblArticle) TblArticle.Columns(0).Width = 180 TblArticle.Columns(1).Width = 100 TblArticle.Columns(2).Visible = False TblArticle.Columns(0).HeaderText = "ARTICLES" TblArticle.Columns(1).HeaderText = "UM" With TblArticle.ColumnHeadersDefaultCellStyle .Alignment = DataGridViewContentAlignment.MiddleCenter .BackColor = Color.CornflowerBlue .ForeColor = Color.BlueViolet .Font = New Font(.Font.FontFamily, .Font.Size, _ .Font.Style Or FontStyle.Bold, GraphicsUnit.Point) End With '------------------------------- End Sub
Private Sub ArticlesToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ArticlesToolStripMenuItem.Click Dim Articles As New Articles Articles.MdiParent = Me Articles.StartPosition = FormStartPosition.CenterScreen Articles.Show() End Sub
Imports System.Globalization Imports System.Threading Imports System.Data.OleDb Imports System.Windows.Forms Public Class Bareme Inherits System.Windows.Forms.Form Public maCI As CultureInfo = CultureInfo.CurrentCulture Public maCIclone As CultureInfo = CType(maCI.Clone(), Globalization.CultureInfo) Private Sub Bareme_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load maCIclone.NumberFormat.NumberDecimalSeparator = "." Thread.CurrentThread.CurrentCulture = maCIclone con.Close() connection() maform = Me.Name '-------------Charge DataGridView------------ reqTot = "SELECT animal, article, um, QteRation, idtauxration, Tbl_Animaux.IdAnimal, Tbl_Article.IdArticle FROM Tbl_Article" & _ " INNER JOIN (Tbl_Animaux INNER JOIN Tbl_TauxRation ON Tbl_Animaux.IdAnimal = Tbl_TauxRation.IdAnimal) ON Tbl_Article.IdArticle = Tbl_TauxRation.IdArticle" & _ " ORDER BY Animal, article" charger_grid_view(maform, reqTot, TblTaux) TblTaux.Columns(0).Width = 180 TblTaux.Columns(1).Width = 180 TblTaux.Columns(2).Width = 100 TblTaux.Columns(3).Width = 100 TblTaux.Columns(3).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight TblTaux.Columns(4).Visible = False TblTaux.Columns(5).Visible = False TblTaux.Columns(6).Visible = False TblTaux.Columns(0).HeaderText = "CAT.ANIMAL" TblTaux.Columns(1).HeaderText = "ARTICLE" TblTaux.Columns(2).HeaderText = "U.M" TblTaux.Columns(3).HeaderText = "TAUX" With TblTaux.ColumnHeadersDefaultCellStyle .Alignment = DataGridViewContentAlignment.MiddleCenter .BackColor = Color.CornflowerBlue .ForeColor = Color.BlueViolet .Font = New Font(.Font.FontFamily, .Font.Size, _ .Font.Style Or FontStyle.Bold, GraphicsUnit.Point) End With '-------------Charge Combo Animal------------ req = "select idanimal, animal from tbl_animaux order by animal" charger_combobox(maform, req, Combo_Animal, "animal", "idanimal") '-------------Charge Combo Article------------ req = "select idarticle, article from tbl_article order by article" charger_combobox(maform, req, Combo_Article, "article", "idarticle") '-------------Vider les Combos------------ Combo_Animal.SelectedValue = 0 Combo_Article.SelectedValue = 0 End Sub Sub activer() Combo_Animal.Enabled = True Combo_Article.Enabled = True Sai_Taux.Enabled = True End Sub Sub desactiver() Combo_Animal.Enabled = False Combo_Article.Enabled = False Sai_Taux.Enabled = False End Sub Sub vider() op = "N" xmodifie = "" Sai_IdTaux.Clear() Combo_Animal.SelectedValue = 0 Combo_Article.SelectedValue = 0 Sai_Taux.Clear() Sai_Recherche.Clear() End Sub Sub existedeja() If Combo_Animal.Text <> "" And Combo_Article.Text <> "" Then req = "SELECT animal, article, um, QteRation, idtauxration, Tbl_Animaux.IdAnimal, Tbl_Article.IdArticle FROM Tbl_Article" & _ " INNER JOIN (Tbl_Animaux INNER JOIN Tbl_TauxRation ON Tbl_Animaux.IdAnimal = Tbl_TauxRation.IdAnimal) ON Tbl_Article.IdArticle = Tbl_TauxRation.IdArticle" & _ " where Tbl_Animaux.IdAnimal=" & Combo_Animal.SelectedValue & " and Tbl_Article.IdArticle=" & Combo_Article.SelectedValue charger_grid_view(maform, req, TblTaux) If TblTaux.RowCount > 0 Then If op = "N" Then MessageBox.Show("Enregistrement Existe Déja", "Déja Saisie", MessageBoxButtons.OK, MessageBoxIcon.Information) desactiver() Btn_Nouveau.Enabled = True Btn_Valider.Enabled = False Btn_Supprimer.Enabled = False Btn_Annuler.Enabled = True End If If op = "M" Then MessageBox.Show("Enregistrement Existe Déja", "Déja Saisie", MessageBoxButtons.OK, MessageBoxIcon.Information) desactiver() Sai_Taux.Enabled = True Btn_Nouveau.Enabled = False Btn_Valider.Enabled = True Btn_Supprimer.Enabled = True Btn_Annuler.Enabled = True End If End If End If End Sub Private Sub Tblbareme_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles TblTaux.DoubleClick op = "M" If TblTaux.CurrentCell.RowIndex >= 0 Then Sai_IdTaux.Text = TblTaux(4, TblTaux.CurrentCell.RowIndex).Value Combo_Animal.SelectedValue = TblTaux(5, TblTaux.CurrentCell.RowIndex).Value Combo_Article.SelectedValue = TblTaux(6, TblTaux.CurrentCell.RowIndex).Value Sai_Taux.Text = TblTaux(3, TblTaux.CurrentCell.RowIndex).Value xmodifie = Sai_Taux.Text Combo_Animal.Enabled = False Combo_Article.Enabled = False Sai_Taux.Enabled = True Btn_Nouveau.Enabled = False Btn_Valider.Enabled = True Btn_Supprimer.Enabled = True Btn_Annuler.Enabled = True Sai_Taux.Focus() End If End Sub Private Sub Btn_Annuler_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_Annuler.Click vider() desactiver() Btn_Nouveau.Enabled = True Btn_Valider.Enabled = False Btn_Supprimer.Enabled = False Btn_Annuler.Enabled = True charger_grid_view(maform, reqTot, TblTaux) 'Btn_Annuler.Focus() End Sub Private Sub Btn_Fermer_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_Fermer.Click dr.Close() con.Close() Me.Close() End Sub Private Sub Btn_Supprimer_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_Supprimer.Click req = "delete * from tbl_tauxration where idtauxration=" + Sai_IdTaux.Text supprimer(req) charger_grid_view(maform, reqTot, TblTaux) Btn_Annuler_Click(sender, e) End Sub Private Sub Sai_Recherche_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles Sai_Recherche.Enter Btn_Annuler_Click(sender, e) End Sub Private Sub Sai_Recherche_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Sai_Recherche.TextChanged req = "SELECT animal, article, um, QteRation, idtauxration, Tbl_Animaux.IdAnimal, Tbl_Article.IdArticle FROM Tbl_Article" & _ " INNER JOIN (Tbl_Animaux INNER JOIN Tbl_TauxRation ON Tbl_Animaux.IdAnimal = Tbl_TauxRation.IdAnimal) ON Tbl_Article.IdArticle = Tbl_TauxRation.IdArticle" & _ " where animal like '%" & Sai_Recherche.Text.Trim & "%' or article like '%" & Sai_Recherche.Text & "%' or um like '%" & Sai_Recherche.Text & _ "%' or qteration= " & Val(Sai_Recherche.Text) & " ORDER BY Animal, article" If Sai_Recherche.Text <> "" Then charger_grid_view(maform, req, TblTaux) Else charger_grid_view(maform, reqTot, TblTaux) End If End Sub Private Sub Btn_Nouveau_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_Nouveau.Click vider() activer() Btn_Nouveau.Enabled = False Btn_Valider.Enabled = True Btn_Supprimer.Enabled = False Btn_Annuler.Enabled = True Sai_Recherche.Clear() charger_grid_view(maform, reqTot, TblTaux) Combo_Animal.Focus() End Sub Private Sub Btn_Valider_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_Valider.Click If Combo_Animal.SelectedValue > 0 And Combo_Article.SelectedValue > 0 And Sai_Taux.Text <> "" Then If op = "M" Then req = "update tbl_tauxration set idarticle=" & Combo_Article.SelectedValue & ", idanimal= " & Combo_Animal.SelectedValue & ", qteration= " & Sai_Taux.Text & " where idtauxration =" & Sai_IdTaux.Text Else req = "insert into tbl_tauxration (idanimal,idarticle,qteration) values (" & _ Combo_Animal.SelectedValue & "," & Combo_Article.SelectedValue & "," & Val(Sai_Taux.Text) & ")" End If enregistrer(req) charger_grid_view(maform, reqTot, TblTaux) Btn_Annuler_Click(sender, e) Else MessageBox.Show("Remplir Les Champs Animal, article et le taux de ration Avant ...!!!", "Chams Vide", MessageBoxButtons.OK, MessageBoxIcon.Exclamation) 'Sai_Animal.Focus() End If End Sub Private Sub Combo_Animal_Validated(ByVal sender As Object, ByVal e As System.EventArgs) Handles Combo_Animal.Validated existedeja() End Sub Private Sub Combo_Article_Validated(ByVal sender As Object, ByVal e As System.EventArgs) Handles Combo_Article.Validated existedeja() End Sub End Class
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionWith maform gv.DataSource = dt End WithLe With ne sert à rien, puisque gv est la référence à un DataGridView spécifique.
Public Sub charger_grid_view(ByVal req As String, ByVal gv As DataGridView) Try dt.Clear() cmd.CommandText = req dr = cmd.ExecuteReader dt.Load(dr) gv.DataSource = dt Catch ex As Exception MessageBox.Show(ex.ToString) End Try dr.Close() End Sub
13 août 2018 à 12:10
MODULE 1
FORM ARTICLE
MÊME PROCÉDURE POUR LES AUTRES FORMS
MENU STRIP
MERCI POUR VOTRE ATTENTION
15 août 2018 à 10:48
15 août 2018 à 12:51
Là c’est pas le cas.
Il faut attendre quelqu’un d’autre, ou que je rentre chez moi
15 août 2018 à 16:25