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 FrmGSTFULL : Form
{
public FrmGSTFULL()
{
InitializeComponent();
}
int i = 0;
DataSet ds = new DataSet();
SqlDataAdapter sqlda = new SqlDataAdapter("select * from stagiaire", "data source=.;initial catalog = ecole; integrated security = true");
private void FrmGSTFULL_Load(object sender, EventArgs e)
{
//sqlda.DeleteCommand = new SqlCommand();
//sqlda.DeleteCommand.Connection = sqlda.SelectCommand.Connection;
//sqlda.DeleteCommand.CommandText = "Delete from stagiaire where code=@code";
//SqlParameter par1 = new SqlParameter();
//par1.ParameterName ="@code";
//par1.Direction=ParameterDirection.Input ;
//par1.DbType=DbType.Int32;
//sqlda.DeleteCommand.Parameters.Add(par1);
//sqlda.Fill(ds, "Stagiaire");
//MessageBox.Show(ds.Tables["Stagiaire"].Rows.Count.ToString());
//////SqlCommandBuilder sqlcb = new SqlCommandBuilder(sqlda);
//////MessageBox.Show(sqlcb.GetUpdateCommand().CommandText);
}
//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 btnvider_Click(object sender, EventArgs e)
{
this.txtCode.Clear();
this.txtNom.Clear();
this.txtPrenom.Clear();
this.txtcodesp.Clear();
this.txtrow.Clear();
}
private void btnajout_Click(object sender, EventArgs e)
{
DataRow drw;
int b = Rechercher(int.Parse(this.txtCode.Text));
if (b == -1)
{
drw = ds.Tables["Stagiaire"].NewRow();
drw[0] = int.Parse(txtCode.Text);
drw[1] = this.txtNom.Text;
drw[2] = this.txtPrenom.Text;
drw[3] = this.txtcodesp.Text;
ds.Tables["Stagiaire"].Rows.Add(drw);
MessageBox.Show("Ajoute(e) avec Success");
}
else
MessageBox.Show("exist");
}
private void btnprem_Click(object sender, EventArgs e)
{
i = 0;
if (ds.Tables["Stagiaire"].Rows[i].RowState.ToString() != "Deleted")
{
txtCode.Text = ds.Tables["Stagiaire"].Rows[i][0].ToString();
txtNom.Text = ds.Tables["Stagiaire"].Rows[i][1].ToString();
txtPrenom.Text = ds.Tables["Stagiaire"].Rows[i][2].ToString();
txtcodesp.Text = ds.Tables["Stagiaire"].Rows[i][3].ToString();
this.txtrow.Text = ds.Tables["Stagiaire"].Rows[i].RowState.ToString();
}
else
this.txtrow.Text = ds.Tables["Stagiaire"].Rows[i].RowState.ToString();
}
private void btnprec_Click(object sender, EventArgs e)
{
if (i > 0)
{
i--;
txtCode.Text = ds.Tables["Stagiaire"].Rows[i][0].ToString();
txtNom.Text = ds.Tables["Stagiaire"].Rows[i][1].ToString();
txtPrenom.Text = ds.Tables["Stagiaire"].Rows[i][2].ToString();
txtcodesp.Text = ds.Tables["Stagiaire"].Rows[i][3].ToString();
this.txtrow.Text = ds.Tables["Stagiaire"].Rows[i].RowState.ToString();
}
}
private void btndern_Click(object sender, EventArgs e)
{
i = ds.Tables["Stagiaire"].Rows.Count - 1;
txtCode.Text = ds.Tables["Stagiaire"].Rows[i][0].ToString();
txtNom.Text = ds.Tables["Stagiaire"].Rows[i][1].ToString();
txtPrenom.Text = ds.Tables["Stagiaire"].Rows[i][2].ToString();
txtcodesp.Text = ds.Tables["Stagiaire"].Rows[i][3].ToString();
this.txtrow.Text = ds.Tables["Stagiaire"].Rows[i].RowState.ToString();
}
private void bntsuiv_Click(object sender, EventArgs e)
{
if (i < ds.Tables["Stagiaire"].Rows.Count - 1)
{
i++;
txtCode.Text = ds.Tables["Stagiaire"].Rows[i][0].ToString();
txtNom.Text = ds.Tables["Stagiaire"].Rows[i][1].ToString();
txtPrenom.Text = ds.Tables["Stagiaire"].Rows[i][2].ToString();
txtcodesp.Text = ds.Tables["Stagiaire"].Rows[i][3].ToString();
this.txtrow.Text = ds.Tables["Stagiaire"].Rows[i].RowState.ToString();
}
}
private int Rechercher(int co)
{
int pos = -1;
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) pos = i;
}
return pos;
}
private void btnupgrd_Click(object sender, EventArgs e)
{
SqlCommandBuilder sqlBd = new SqlCommandBuilder(sqlda);
sqlda.Update(ds,"Stagiaire");
MessageBox.Show("Mise A jour Avec Success");
}
private void btnmodif_Click(object sender, EventArgs e)
{
int p = Rechercher(int.Parse(this.txtCode.Text));
if (p != -1)
{
ds.Tables["Stagiaire"].Rows[p][0] = this.txtCode.Text;
ds.Tables["Stagiaire"].Rows[p][1] = this.txtNom.Text;
ds.Tables["Stagiaire"].Rows[p][2] = this.txtPrenom.Text;
ds.Tables["Stagiaire"].Rows[p][3] = this.txtcodesp.Text;
MessageBox.Show("Modifie(é) avec Success");
}
else
MessageBox.Show("Non Trouve(e)");
}
private void btnsupp_Click_1(object sender, EventArgs e)
{
int posi = Rechercher(int.Parse(this.txtCode.Text));
if (posi != -1)
{
ds.Tables["Stagiaire"].Rows[posi].Delete();
MessageBox.Show("Suppression avec Success");
}
else MessageBox.Show("Stagiaire(e) Non Trouve(e)");
}
}
}
public partial class frm_exr : Form
{
public frm_exr()
{
InitializeComponent();
}
string reqcmd="";
SqlDataAdapter sqlda;
DataSet ds = new DataSet();
int i ;
private void frm_exr_Load(object sender, EventArgs e)
{
opttous.Checked = true;
}
private void opttous_CheckedChanged(object sender, EventArgs e)
{
if (opttous.Checked == true)
{
lblgrp.Text = "";
txtgrp.Enabled = false;
reqcmd = "select * from stagiaire";
sqlda = new SqlDataAdapter(reqcmd, "data source=.;initial catalog = ecole; integrated security = true");
sqlda.Fill(ds, "Stagiaire");
}
}
private void afficher()
{
txtCode.Text = ds.Tables["Stagiaire"].Rows[i][0].ToString();
txtNom.Text = ds.Tables["Stagiaire"].Rows[i][1].ToString();
txtPrenom.Text = ds.Tables["Stagiaire"].Rows[i][2].ToString();
txtcodesp.Text = ds.Tables["Stagiaire"].Rows[i][3].ToString();
this.txtrow.Text = ds.Tables["Stagiaire"].Rows[i].RowState.ToString();
}
private void btnprem_Click(object sender, EventArgs e)
{
i = 0;
afficher();
}
private void btnprec_Click(object sender, EventArgs e)
{
if (i > 0)
{
i--;
afficher();
}
}
private void bntsuiv_Click(object sender, EventArgs e)
{
if (i < ds.Tables["Stagiaire"].Rows.Count - 1)
{
i++;
afficher();
}
}
private void btndern_Click(object sender, EventArgs e)
{
i = ds.Tables["Stagiaire"].Rows.Count - 1;
afficher();
}
private int Rechercher(int co)
{
int pos = -1;
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) pos = i;
}
return pos;
}
private void optcode_CheckedChanged(object sender, EventArgs e)
{
if (optcode.Checked == true)
{
ds.Clear();
lblgrp.Text = "Code";
txtgrp.Enabled = true;
}
else
lblgrp.Text = "";
}
private void btncharger_Click(object sender, EventArgs e)
{
if (optcode.Checked == true)
{
int var = int.Parse(txtgrp.Text);
reqcmd = "select * from stagiaire where code=" + var;
sqlda = new SqlDataAdapter(reqcmd, "data source=.;initial catalog = ecole; integrated security = true");
sqlda.Fill(ds, "Stagiaire");
if (ds.Tables["Stagiaire"].Rows.Count != 0)
{
i = 0;
if (i == 0)
{
afficher();
}
}
else MessageBox.Show("Non Trouve(e)");
}
if (optnom.Checked == true)
{
reqcmd = "select * from stagiaire where nom like '"+txtgrp.Text+"%'";
sqlda = new SqlDataAdapter(reqcmd, "data source=.;initial catalog = ecole; integrated security = true");
sqlda.Fill(ds, "Stagiaire");
if (ds.Tables["Stagiaire"].Rows.Count != 0)
{
i = 0;
afficher();
}
else MessageBox.Show("Non Trouve(e)");
}
}
private void optnom_CheckedChanged(object sender, EventArgs e)
{
if (optnom.Checked == true)
{
ds.Clear();
lblgrp.Text = "Nom";
txtgrp.Enabled = true;
}
else
lblgrp.Text = "";
}
}
