String str "SELECT * FROM GITE g, RESERVATION r, CONCERNER c WHERE g.IDGITE c.IDGITE AND r.NUMRESA = c.NUMRESA AND r.NUMRESA=2"; DataTable dt = new DataTable(); using (SqlConnection cnDataBase = new SqlConnection("Server=XPStudio-118.\\SQLEXPRESS;Database=gites;User ID=sa;Password=******;Trusted_Connection=False;")) { cnDataBase.Open(); SqlCommand cmTable = new SqlCommand(str, cnDataBase); SqlDataAdapter daTable = new SqlDataAdapter(cmTable); daTable.Fill(dt); listBox1.DataSource = dt; listBox1.DisplayMember = "IDGITE"; }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionString str "SELECT g.* FROM GITE g INNER JOIN CONCERNER c ON g.IDGITE c.IDGITE INNER JOIN RESERVATION r ON r.NUMRESA = c.NUMRESA " + "WHERE r.DATERESA BETWEEN '" + dATEARRIVEEDateTimePicker.Value.ToString() + "' AND '" + dATEDEPARTDateTimePicker.Value.ToString() + "'";
// soit la string str telle que tu l'as définie juste au-dessus // sauf que tu remplaces SELECT g.* par SELECT g.giteID // giteID étant la clé primaire de ta table (tu l'as peut-être appelée autrement) string rqt = "SELECT * FROM gites gg WHERE gg.giteID NOT IN (" + str + ")";
listBox1.DataSource = dt; listBox1.DisplayMember = "IDGITE";
String str = "SELECT g.* FROM GITE g WHERE g.IDGITE NOT IN("+ "SELECT g.IDGITE FROM GITE g INNER JOIN CONCERNER c ON g.IDGITE c.IDGITE INNER JOIN RESERVATION r ON r.NUMRESA c.NUMRESA " + "WHERE r.DATEARRIVEE BETWEEN '" + dATEARRIVEEDateTimePicker.Value.ToString() + "' AND '" + dATEDEPARTDateTimePicker.Value.ToString() + "'" + "OR r.DATEDEPART BETWEEN '" + dATEARRIVEEDateTimePicker.Value.ToString() + "' AND '" + dATEDEPARTDateTimePicker.Value.ToString() + "'" + "OR ('" + dATEARRIVEEDateTimePicker.Value.ToString() + "'<r.DATEARRIVEE AND '" + dATEDEPARTDateTimePicker.Value.ToString() + "'>r.DATEDEPART)" + "OR ('" + dATEARRIVEEDateTimePicker.Value.ToString() + "'>r.DATEARRIVEE AND '" + dATEDEPARTDateTimePicker.Value.ToString() + "'<r.DATEDEPART)"+ ")";
listBox1.DataSource = dt; listBox1.DisplayMember = "NOMGITE"; listBox1.ValueMember = "IDGITE"; villeTextBox.DataBinding.Add("Text", listBox1.SelectedItem, "Ville"); //etc...