private void FillFormCombo()
{
try
{
//TYPE MATERIEL //
DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter();
DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable();
typeAdaptater.Fill(tab1);
List <ListItem> listitem = new List <ListItem>();
foreach (DataSet1.typeRow Row in tab1.Rows)
{
listitem.Add(new ListItem(Row.nom, Row.id_type));
}
formFieldTypeMateriel.DataSource = listitem;
//CLIENT //
DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter();
DataSet1.clientDataTable tab2 = new DataSet1.clientDataTable();
clientAdaptater.Fill(tab2);
List <ListItem> listitem2 = new List <ListItem>();
foreach (DataSet1.clientRow Row in tab2.Rows)
{
listitem2.Add(new ListItem(Row.name, Row.id_client));
}
formFieldClient.DataSource = listitem2;
//SITE//
DataSet1TableAdapters.siteTableAdapter siteAdaptater = new DataSet1TableAdapters.siteTableAdapter();
DataSet1.siteDataTable tab3 = new DataSet1.siteDataTable();
siteAdaptater.Fill(tab3);
List <ListItem> listitem3 = new List <ListItem>();
foreach (DataSet1.siteRow Row in tab3.Rows)
{
listitem3.Add(new ListItem(Row.nom, Row.id_site));
}
formFieldSite.DataSource = listitem3;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// dbConnection.Close();
}
private void FillFormCombo()
{
try
{
//TYPE MATERIEL //
DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter();
DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable();
typeAdaptater.Fill(tab1);
List<ListItem> listitem = new List<ListItem>();
foreach (DataSet1.typeRow Row in tab1.Rows)
{
listitem.Add(new ListItem(Row.nom, Row.id_type));
}
formFieldTypeMateriel.DataSource = listitem;
//CLIENT //
DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter();
DataSet1.clientDataTable tab2 = new DataSet1.clientDataTable();
clientAdaptater.Fill(tab2);
List<ListItem> listitem2 = new List<ListItem>();
foreach (DataSet1.clientRow Row in tab2.Rows)
{
listitem2.Add(new ListItem(Row.name, Row.id_client));
}
formFieldClient.DataSource = listitem2;
//SITE//
DataSet1TableAdapters.siteTableAdapter siteAdaptater = new DataSet1TableAdapters.siteTableAdapter();
DataSet1.siteDataTable tab3 = new DataSet1.siteDataTable();
siteAdaptater.Fill(tab3);
List<ListItem> listitem3 = new List<ListItem>();
foreach (DataSet1.siteRow Row in tab3.Rows)
{
listitem3.Add(new ListItem(Row.nom, Row.id_site));
}
formFieldSite.DataSource = listitem3;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// dbConnection.Close();
}
