private void cmbentreprise_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbentreprise.SelectedIndex > -1)
{
cmbentreprisesource.SelectedIndex = cmbentreprise.SelectedIndex;
string sql = "SELECT fact_entreprise.*, typetva.taux as tauxtva, typetva.idtva FROM fact_entreprise LEFT JOIN typetva ON typetva.idtva = fact_entreprise.idtauxtva where identreprise =" + cmbentreprisesource.SelectedValue.ToString();
DeltaSQLCon.CommandText = sql;
MySqlDataReader mr = DeltaSQLCon.ExecuteReader();
if (mr.Read())
{
identreprisesel = cmbentreprisesource.SelectedValue.ToString();
decimal.TryParse(Util.GetValue(mr, "tauxtva"), out dtvachf);
int.TryParse(Util.GetValue(mr, "echeance"), out iecheance);
nombasecompta = Util.GetValue(mr, "basededonnees");
comptedebit = Util.GetValue(mr, "comptedebit");
compteb = Util.GetValue(mr, "compteb");
comptefacture = Util.GetValue(mr, "comptefacture");
}
mr.Close();
}
}