private void button1_Click(object sender, EventArgs e)
{
Q4Etat q4 = new Q4Etat(TB_Matricule.Text);
Provider.Remplire("SELECT dbo.Dossier.* FROM dbo.Dossier where Matricule = '" + TB_Matricule.Text + "' and (Montant_Remboursement > '0' and Montant_Remboursement is not null) and year(Date_Traitement) = year(GetDate()) ", "Dossier");
q4.ShowDialog();
}
private void button2_Click(object sender, EventArgs e)
{
Q4Etat q4 = new Q4Etat(TB_Matricule.Text);
Provider.Remplire("SELECT dbo.Dossier.* FROM dbo.Dossier where Matricule = '" + TB_Matricule.Text + "' and (Montant_Remboursement <= '0' or Montant_Remboursement is null ) ", "Dossier");
q4.ShowDialog();
}
