select s.LIBELE_STATION,na.LIBELE_NA,sa.SEUIL_ALERTE from NIVEAU_ALERTE na, ALARME_STATION sa, PARAMETRE_MESURE pm , STATION s where sa.ID_NA=na.ID_NA and sa.ID_PM=pm.ID_PM and sa.ID_STATION=s.ID_STATION and s.ID_STATION='Ain Sebou' and pm.LIBELE_PM='Niveau'
var alar = from sa in context.ALARME_STATION join na in context.NIVEAU_ALERTE on sa.ID_NA equals na.ID_NA join pm in context.PARAMETRE_MESURE on sa.ID_PM equals pm.ID_PM join s in context.STATIONs on sa.ID_STATION equals s.ID_STATION where pm.LIBELE_PM == val && s.ID_STATION == drp_state.SelectedValue select new { libel = pm.LIBELE_PM, na = na.LIBELE_NA, seul = sa.SEUIL_ALERTE };
Quote:thank you it work now i change id of my grid view because in my webform i have 2 grid and i bind the first one now it works thanks o lot
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)