Comments by abdou_31 (Top 29 by date)

 public partial class Modifier : Form
    {
        public DataSet ds = new DataSet();
        public DataSet ds2 = new DataSet();
        public SqlCeConnection conn = new SqlCeConnection(@"Data Source =\Program Files\projetpfe\Inventaire.sdf");
        public SqlCeDataAdapter da, da2;
        public SqlCeCommand cmd, cmd2;
        public SqlCeDataReader dr,dr2;
        public Modifier()
        {
            InitializeComponent();

            this.da = new SqlCeDataAdapter("Select Code_locale from Bureau", conn);
           // this.da2 = new SqlCeDataAdapter("Select DISTINCT Adresse from Bureau ", conn);
            this.cmd = new SqlCeCommand("Select Service from Bureau where Code_locale ='" + comboBox1.SelectedItem + "'", conn);
            this.cmd2 = new SqlCeCommand("Select Nom_resp from Bureau where Code_locale='" + comboBox1.SelectedItem + "'", conn);
         
            
          
        }

        private void Modifier_Load(object sender, EventArgs e)
        {

            conn.Open();
            this.ds.Tables.Clear();
            this.da.Fill(this.ds, "Bureau");
            comboBox1.DataSource = this.ds.Tables["Bureau"];
            comboBox1.DisplayMember = "Code_locale";
            this.ds2.Tables.Clear();
            this.da2.Fill(this.ds2, "Bureau");
            comboBox2.DataSource = this.ds2.Tables["Bureau"];
            comboBox2.DisplayMember = "Adresse";*/
            dr = cmd.ExecuteReader();
            dr2 = cmd2.ExecuteReader();
            textBox1.Text = dr.ToString();
       
            
        }