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.SqlClient;
namespace Gst_Stg_insertion
{
    public partial class Insert : Form
    {
        public Insert()
        {
            InitializeComponent();
        }
        DataSet ds = new DataSet();
        SqlDataAdapter sqlda = new SqlDataAdapter("select * from stagiaire", "data source=.;initial catalog = ecole; integrated security = true");
        private void Form1_Load(object sender, EventArgs e)
        {
            sqlda.Fill(ds, "Stagiaire");
            MessageBox.Show(ds.Tables["Stagiaire"].Rows.Count.ToString());
        }
        private Boolean Rechercher(int co)
        {
            Boolean b = false;
            int i;
            DataRow dr;
            for (i = 0; i < ds.Tables["Stagiaire"].Rows.Count - 1; i++)
            {
                dr = ds.Tables["Stagiaire"].Rows[i];
                 if (dr[0].Equals(co) == true) b = true;
            }
            return b;
        }
        private void btnAjou_Click(object sender, EventArgs e)
        {
            DataRow drw;
            Boolean b = Rechercher(int.Parse(this.txtCode.Text));
            if (b == false )
            {
                drw = ds.Tables["Stagiaire"].NewRow();
                drw[0] = int.Parse(txtCode.Text);
                drw[1] = this.txtNom.Text;
                drw[2] = this.txtPrenom.Text;
                drw[3] = this.txtcode_sp.Text;
                ds.Tables["Stagiaire"].Rows.Add(drw);
                MessageBox.Show("Ajoute(e) avec Success");
            }
            else
            MessageBox.Show("exist");
           
        }
    }
}