private void buttonSearch_Click(object sender, EventArgs e) { string searchValue = textBoxCode.Text; try { ServiceReferenceCopy.ServiceExemplairesClient se = new ServiceReferenceCopy.ServiceExemplairesClient(); gridData.DataSource = se.SearchExemBiblio(comboBoxBiblio.SelectedValue.ToString(), textBoxCode.Text); if (gridData != null) { gridData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; gridData.Columns[gridData.ColumnCount - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } gridData.Columns["achat"].Visible = false; gridData.Columns["date_emprunt"].Visible = false; gridData.Columns["id_biblio"].Visible = false; gridData.Columns["idLivre"].Visible = false; } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void button1_Click(object sender, EventArgs e) { try { ServiceReferenceLecteur.ServiceLecteurClient s_lect = new ServiceReferenceLecteur.ServiceLecteurClient(); var x = s_lect.getAll(userTextBox.Text, textBoxPassword.Text, comboBoxBiblio.SelectedItem.ToString()); if (x.Count() > 0) { myuser = userTextBox.Text; mybiblio = comboBoxBiblio.SelectedValue.ToString(); gridData.DataSource = null; ServiceReferenceCopy.ServiceExemplairesClient se = new ServiceReferenceCopy.ServiceExemplairesClient(); gridData.DataSource = se.GetAllExemBiblio(comboBoxBiblio.SelectedValue.ToString()); gridData.Columns["achat"].Visible = false; gridData.Columns["date_emprunt"].Visible = false; gridData.Columns["id_biblio"].Visible = false; gridData.Columns["idLivre"].Visible = false; label1.Text = "Bonjour " + userTextBox.Text + ", vous êtes à " + comboBoxBiblio.SelectedValue.ToString(); if (gridData != null) { gridData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; gridData.Columns[gridData.ColumnCount - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } MessageBox.Show("Hello " + userTextBox.Text + ", you're now connected to " + comboBoxBiblio.SelectedValue.ToString()); panelLog.Hide(); MajorPanel.Show(); } else { MessageBox.Show("utisateur non connu "); } } catch (SqlException ex) { string myerror; switch (ex.Number) { case 18456: myerror = "mauvais user"; break; case 4060: myerror = "mauvaise db"; break; default: myerror = ex.Message; break; } MessageBox.Show("une erreur est survenue détails: " + myerror); } }