private void button5_Click(object sender, EventArgs e)
{
if (!DScnxBd.verifierExitanceCNE(textBox3.Text))
{
DataRow ligne = DScnxBd.ds.Tables["etudiant"].NewRow();
ligne[0] = textBox3.Text;
ligne[1] = textBox5.Text;
ligne[2] = textBox4.Text;
if (radioButton1.Checked)
{
ligne[3] = 'f';
}
else
{
ligne[3] = 'h';
}
ligne[4] = (DateTime)dateTimePicker1.Value;
ligne[5] = textBox6.Text;
ligne[6] = textBox7.Text;
ligne[7] = comboBox3.SelectedValue;
DScnxBd.ds.Tables["etudiant"].Rows.Add(ligne);
}
else
{
MessageBox.Show("l'etudiant eexiste deja");
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
DScnxBd bd = new DScnxBd();
Application.Run(new Form1());
}
private void button2_Click(object sender, EventArgs e)
{
for (int i = 1; i <= ws.UsedRange.Rows.Count; i++)
{
if (!DScnxBd.verifierExitanceCNE(ws.Cells[i, 1].Value))
{
DataRow ligne = DScnxBd.ds.Tables["etudiant"].NewRow();
for (int j = 1; j <= ws.UsedRange.Columns.Count; j++)
{
if (j == 5)
{
ligne[j - 1] = (DateTime)ws.Cells[i, j].Value;
}
else if (j == 8)
{
for (int k = 0; k < DScnxBd.ds.Tables["filliere"].Rows.Count; k++)
{
if (DScnxBd.ds.Tables["filliere"].Rows[k][1].ToString().Trim() == ws.Cells[i, j].Value)
{
ligne[j - 1] = DScnxBd.ds.Tables["filliere"].Rows[k][0];
}
}
}
else
{
ligne[j - 1] = ws.Cells[i, j].Value;
}
}
DScnxBd.ds.Tables["etudiant"].Rows.Add(ligne);
}
else
{
MessageBox.Show("L'etudiant numero " + i + "existe deja");
}
}
this.Dispose();
}
