protected void Button1_Click(object sender, EventArgs e) { int dateNissance = Calendar1.SelectedDate.Year; //SqlDataSource1 using (associationEntities1 bdd = new associationEntities1()) { List<Adherent> ListAdr = new List<Adherent>(); var Result3 = from p in bdd.Adherent join q in bdd.Cotisation on p.IDAdherent equals q.IDAdherent where q.AnneeCotis == dateNissance.ToString() select new {Nom=p.Nom, Prenom = p.Prenom, Genre=p.Genre, Naissance = p.Naissance,Photo = p.Photo, SituatFam = p.SituatFam, VilOrig= p.VilOrig, }; List<Adherent> listeAdherent = new List<Adherent>(); foreach (var item in Result3) { Adherent adr = new Adherent(); adr.Nom = item.Nom; adr.Prenom = item.Prenom; adr.Genre = item.Genre; adr.Naissance = item.Naissance; adr.Photo = item.Photo; adr.SituatFam = item.SituatFam; adr.VilOrig = item.VilOrig; listeAdherent.Add(adr); } GridView1.DataSource = listeAdherent; GridView1.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { //SqlDataSource1 using (associationEntities1 bdd = new associationEntities1()) { List<Villages_de_la_région> ListAdr = new List<Villages_de_la_région>(); var Result3 = from p in bdd.Villages_de_la_région select new { NumVillage = p.NumVillage, Villages = p.Villages, }; List<Villages_de_la_région> listeVillages_de_la_région = new List<Villages_de_la_région>(); foreach (var item in Result3) { Villages_de_la_région adr = new Villages_de_la_région(); adr.NumVillage = item.NumVillage; adr.Villages = item.Villages; } GridView1.DataSource = listeVillages_de_la_région; GridView1.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { int id = int.Parse(TextBoxnumeroArdherent.Text); //SqlDataSource1 using (associationEntities1 bdd = new associationEntities1()) { List<Adherent> ListAdr = new List<Adherent>(); var Result3 = from p in bdd.Adherent where id == p.IDAdherent select new { Nom = p.Nom, Prenom = p.Prenom, Genre = p.Genre, Naissance = p.Naissance, Photo = p.Photo, SituatFam = p.SituatFam, VilOrig = p.VilOrig, }; List<Adherent> listeAdherent = new List<Adherent>(); foreach (var item in Result3) { Adherent adr = new Adherent(); adr.Nom = item.Nom; adr.Prenom = item.Prenom; adr.Genre = item.Genre; adr.Naissance = item.Naissance; adr.Photo = item.Photo; adr.SituatFam = item.SituatFam; adr.VilOrig = item.VilOrig; listeAdherent.Add(adr); } GridView1.DataSource = listeAdherent; GridView1.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { int dateNissance = Calendar1.SelectedDate.Year; //SqlDataSource1 using (associationEntities1 bdd = new associationEntities1()) { List<Adherent> ListAdr = new List<Adherent>(); var Result3 = from p in bdd.Adherent join q in bdd.Coordonnees on p.IDAdherent equals q.IDAdherent select new { IDAdherent = p.IDAdherent, Genre = p.Genre, Nom = p.Nom, Prenom = p.Prenom, VilOrig = p.VilOrig, Adresse = q.Adresse, Adresse2 = q.Adresse2, CodePostal = q.CP, Ville = q.Ville, telleFix=q.TelFixe, Portable = q.Portable, Naissance = p.Naissance, Mail = q.Mail, }; // SqlDataSource2.DataBinding() = Result3; GridView2.DataSource = Result3; GridView2.DataBind(); } }