예제 #1
0
        public void load_metroGrid()
        {
            DataSet        ds  = new DatabaseDataSet();
            SqlDataAdapter sda = new SqlDataAdapter("Select * from Client", Conteneur.conn);

            sda.Fill(ds, "Client");
            this.metroGrid.DataSource = ds;
            this.metroGrid.DataMember = "Client";
            this.metroGrid.ClearSelection();
            this.buttonModifier.BackColor  = Color.LightGray;
            this.buttonSupprimer.BackColor = Color.LightGray;
            ds.Dispose();
        }
예제 #2
0
        public void load_metroGrid()
        {
            this.buttonSupprimer.Enabled   = false;
            this.buttonModifier.Enabled    = false;
            this.buttonImprimer.Enabled    = false;
            this.buttonModifier.BackColor  = Color.LightGray;
            this.buttonSupprimer.BackColor = Color.LightGray;
            this.buttonImprimer.BackColor  = Color.LightGray;

            DataSet        ds  = new DatabaseDataSet();
            SqlDataAdapter sda = new SqlDataAdapter("select * from Devis", Conteneur.conn);

            sda.Fill(ds, "Devis");
            this.metroGrid.DataSource = ds;
            this.metroGrid.DataMember = "Devis";

            this.metroGrid.ClearSelection();
            ds.Dispose();
        }
예제 #3
0
        public void load_metroGrid()
        {
            this.buttonModifier.Enabled    = false;
            this.buttonSupprimer.Enabled   = false;
            this.buttonModifier.BackColor  = Color.LightGray;
            this.buttonSupprimer.BackColor = Color.LightGray;
            this.totalTTC.Text             = "";
            this.totalHT.Text = "";
            this.TVAText.Text = "";

            DataSet        ds  = new DatabaseDataSet();
            SqlDataAdapter sda = new SqlDataAdapter("select * from Facture", Conteneur.conn);

            sda.Fill(ds, "Facture");
            this.metroGrid.DataSource = ds;
            this.metroGrid.DataMember = "Facture";

            this.metroGrid.ClearSelection();
            this.searchTextBox.Text = "";
            ds.Dispose();
        }