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();
}
}
