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 FillComboIntervention() { try { DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter(); DataSet1.clientDataTable tab1 = new DataSet1.clientDataTable(); clientAdaptater.Fill(tab1); List <ListItem> listitem = new List <ListItem>(); listitem.Add(new ListItem("Indifferent", 0)); foreach (DataSet1.clientRow Row in tab1.Rows) { listitem.Add(new ListItem(Row.name, Row.id_client)); } comboIntervention.DataSource = listitem; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonValiderClient_Click(object sender, EventArgs e) { if (isModif == false) { DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter(); DataSet1TableAdapters.clientTableAdapter intervetionAdaptater = new DataSet1TableAdapters.clientTableAdapter(); DataSet1.clientDataTable tab1 = new DataSet1.clientDataTable(); clientAdaptater.Insert(denominationClient.Text); MessageBox.Show("Client crée avec succès"); client_initialize(); denominationClient.Text = ""; //ToggleFormClient(); groupBoxClient.Enabled = false; } else { int selectedrowindex = dataGrid_Listing_Client.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = dataGrid_Listing_Client.Rows[selectedrowindex]; int idClient = Convert.ToInt32(selectedRow.Cells[0].Value); SqlCommand cmd = connection.CreateCommand(); string name = denominationClient.Text; //cmd.CommandText = "UPDATE client SET name = "+ name +" WHERE id_client = "+idClient; cmd.CommandText = "UPDATE client SET name = @name WHERE id_client= " + idClient; cmd.Parameters.AddWithValue("name", name); SqlDataAdapter adap = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adap.Fill(ds); client_initialize(); MessageBox.Show("Client modifié avec avec succès"); isModif = false; // ToggleFormClient(); denominationClient.Text = ""; groupBoxClient.Enabled = false; } }
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 FillComboIntervention() { try { DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter(); DataSet1.clientDataTable tab1 = new DataSet1.clientDataTable(); clientAdaptater.Fill(tab1); List<ListItem> listitem = new List<ListItem>(); listitem.Add(new ListItem("Indifferent", 0)); foreach (DataSet1.clientRow Row in tab1.Rows) { listitem.Add(new ListItem(Row.name, Row.id_client)); } comboIntervention.DataSource = listitem; } catch (Exception ex) { MessageBox.Show(ex.Message); } }