using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; /***** CONNEXION SGBD EX1 (20/11/2009) *****/ namespace Connecter { public partial class Connexion : Form { bool connexion = false; public Connexion() { InitializeComponent(); } public static SqlConnection sqlConnect; public bool Connect() { string data = "41010-5221291"; string catalog = "papyrus"; sqlConnect = new SqlConnection(); sqlConnect.ConnectionString "Data Source"+data+";initial Catalog = "+catalog+";Integrated Security=true"; try { sqlConnect.Open(); connexion = true; } catch (Exception ce) { //MessageBox.Show("Erreur de connexion à la base", "Connexion", MessageBoxButtons.OK, MessageBoxIcon.Information); connexion = false; textBox1.Text = ce.Message; } return connexion; } }
private SqlCommand sqlCde; //Création de la commande sqlCde = new SqlCommand(); sqlCde.Connection = Connexion.sqlConnect;
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { string Requete="SELECT lib_scat FROM sous-categorie WHERE cde_cat ="+Convert.ToInt32(comboBox1.SelectedValue); //ici tu execute ta requete! }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionprivate void lstCategorie_SelectedIndexChanged(object sender, EventArgs e) { OleDbConnection dataconnection = new OleDbConnection(); try { lstScategorie.Items.Clear(); dataconnection.ConnectionString = "Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password= yassou;User ID=yassou123"; dataconnection.Open(); OleDbCommand lstScatComm = new OleDbCommand(); lstScatComm.Connection = dataconnection; string requete "SELECT libelle_scategorie, code_scategorie FROM scategorie WHERE code_categorie " + Convert.ToInt32(lstCategorie.SelectedValue); lstScatComm.CommandText = requete; //MessageBox.Show("on va exécuter la commande: " + lstScatComm.CommandText); OleDbDataReader lstScatReader = lstScatComm.ExecuteReader(); while (lstScatReader.Read()) { //Comment remplir la combobox //avec la valeur affichée est libelle_categorie //et celle passée en valeur de la combobox est code_scategorie?? } } catch (Exception ex) { MessageBox.Show("Erreur lors de l'accès à la base de données:" + ex.Message); }
while (lstScatReader.Read()) { ComboBox1.Item.Add(lstScatReader.GetValue(0).ToString(); }