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 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
|
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
namespace Production
{
public partial class Form1 : Form
{
OleDbConnection Connectionproduction = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\projet dedax\\gestion des projet\\gp.mdb");
DataSet datasetproduction = new DataSet();
OleDbDataAdapter production_planifier = new OleDbDataAdapter("SELECT * FROM production_planifier", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\projet dedax\\gestion des projet\\gp.mdb");// je sais vous allez me dire pourquoi tu crée oledbconnection si tu l'utilise pas (je l'utilise ailleurs)
BindingSource bindingproduction_planifier = new BindingSource();
OleDbCommandBuilder builderproduction_planifier = null;
public Form1()
{
InitializeComponent();
}
private void tableproduction_planifier(object sender, EventArgs e)
{
production_planifier.InsertCommand = new OleDbCommand("INSERT INTO production_planifier (cleproduction) VALUES (:cleproduction)", Connectionproduction);
production_planifier.InsertCommand.Parameters.Add(":cleproduction", OleDbType.Integer,4);
Connectionproduction.Open();
production_planifier.Fill(datasetproduction, "production_planifier");
builderproduction_planifier = new OleDbCommandBuilder(production_planifier);
Connectionproduction.Close();
gridopd.DataSource = datasetproduction;
gridopd.DataMember = "production_planifier";
bindingproduction_planifier.DataSource = datasetproduction;
bindingproduction_planifier.DataMember = "production_planifier";
}
private void Form1_Load(object sender, EventArgs e)
{
listeboxopd.SetSelected(0, true);
tableproduction_planifier(sender, e);
//racorder editquantite aparente et edit quentite avec qte en cours
editquantitéaparente.DataBindings.Add(new Binding("Text", bindingproduction_planifier, "qte_encours", true, DataSourceUpdateMode.OnPropertyChanged));
editquantite.DataBindings.Add(new Binding("Text", bindingproduction_planifier, "qte_encours", true, DataSourceUpdateMode.OnValidation));
}
private void boutonvaliderquantite_Click(object sender, EventArgs e)
{
panelquntité.Visible = false;
panelglobal.Enabled = true;
if (builderproduction_planifier != null)
{
production_planifier.UpdateCommand = builderproduction_planifier.GetUpdateCommand();
bindingproduction_planifier.MoveNext();
bindingproduction_planifier.MovePrevious();
production_planifier.Update(datasetproduction.Tables["production_planifier"]);
}
}
} |
Partager