private void charger_inv()
{
DataSet dinvent = MaConnexion.ExecuteSelect(connectionString, "select * from inventaire where type='Comptable' and caract='Cloturé'");
foreach (DataRow row in dinvent.Tables[0].Rows)
{
structinvent str = new structinvent(row[0].ToString(), row[1].ToString());
invent.Items.Add(str);
}
}
public void charger_inventaire()
{
DataSet dsite = MaConnexion.ExecuteSelect(connectionString, "select * from inventaire where etat = 'Valide'");
foreach (DataRow row in dsite.Tables[0].Rows)
{
structinvent str = new structinvent(row[0].ToString(), row[1].ToString());
comboBoxinv.Items.Add(str);
}
try //selection du premier site
{
comboBoxinv.Text = dsite.Tables[0].Rows[0][1].ToString();
treeViewEmplacement.SelectedNode = treeViewEmplacement.Nodes[0];
}
catch (Exception) { } //pas de site dans la base de donnée
}
