protected void btnMAJ_Click(object sender, EventArgs e) { String selectedUsername = txtUsername.Text; String password = txtPassword.Text; String email = txtEmail.Text; using (MySqlConnection con = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen")) { using (MySqlCommand cmd = new MySqlCommand("UPDATE bachelor SET username = @Username WHERE id = @idUser")) { using (MySqlDataAdapter sda = new MySqlDataAdapter()) { /* * cmd.Parameters.AddWithValue("@username", username); * cmd.Parameters.AddWithValue("@password", password); * cmd.Parameters.AddWithValue("@email", email); */ cmd.Parameters.AddWithValue("@Username", new LiteralControl(selectedUsername)); cmd.Parameters.AddWithValue("@idUser", ((Bachelor)Session["profile"]).Id); cmd.Connection = con; con.Open(); int nombreDeLignesAffectees = cmd.ExecuteNonQuery(); if (nombreDeLignesAffectees > 0) { bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-success\"><strong>BRAVO !</strong> Vos informations ont été modifiées.</div>")); Bachelor temp = (Bachelor)Session["profile"]; temp.Username = txtUsername.Text; temp.Password = txtPassword.Text; temp.Email = txtEmail.Text; Session["profile"] = temp; } else { bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-danger\"><strong>ERREUR !</strong> Vos informations n'ont pas pu être modifiées...</div>")); } con.Close(); } } } /*//int x = 0; * using (DbDataReader dbrdr = cmd.ExecuteReader()) * { * if (dbrdr.Read()) * { * } * //Page_Load(object sender, EventArgs e); * lblMessage.Text = "<h3 style=\"color:green\">Profile Updated !!</h3>"+cmd.CommandText; * this.Load += this.Page_Load; * }*/ }
protected void Page_Load(object sender, EventArgs e) { if (Session["isConnected"] == null) Response.Redirect("login.aspx"); /* if (IsPostBack) { int idMusicGenres = 0; if (Request.Form["musicGenres"] != null) { int.TryParse(Request.Form["musicGenres"].ToString(), out idMusicGenres); } int idBookGenres; if (Request.Form["bookGenres"] != null) { int.TryParse(Request.Form["bookGenres"].ToString(), out idBookGenres); } int idMovieGenres; int.TryParse(Request.Form["movieGenres"].ToString(), out idMovieGenres); int idBrands; int.TryParse(Request.Form["brands"].ToString(), out idBrands); int idHobbies; int.TryParse(Request.Form["hobbies"].ToString(), out idHobbies); int idSports; int.TryParse(Request.Form["Sports"].ToString(), out idSports); MySqlConnection cnx0 = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen"); cnx0.Open(); MySqlCommand cmd0 = cnx0.CreateCommand(); cmd0.CommandType = CommandType.Text; cmd0.CommandText = "UPDATE bachelor SET idmusicgenres=@idMusicGenres WHERE id=@idUser"; cmd0.Parameters.AddWithValue("@idMusicGenres", idMusicGenres); cmd0.Parameters.AddWithValue("@idUser", ((Bachelor)Session["profile"]).Id); int nombreLignesAffectees = cmd0.ExecuteNonQuery(); if (nombreLignesAffectees > 0) bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-success\"><strong>BRAVO !</strong> Vos intérêts ont été modifiés.</div>")); else bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-danger\"><strong>ERREUR !</strong> Vos intérêts n'ont pas pu être modifiés...</div>")); cnx0.Close(); } */ if (Session["profile"] != null) { unBachelor = (Bachelor)Session["profile"]; txtId.Text = unBachelor.Id.ToString(); txtUsername.Text = unBachelor.Username; txtPassword.Text = unBachelor.Password; txtEmail.Text = unBachelor.Email; txtNumberOfLikes.Text = unBachelor.NumberOfLikes.ToString(); pbxImage.ImageUrl = unBachelor.Image; pbxImage.Height = 300; pbxImage.Width = 530; } MySqlConnection cnx = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen"); cnx.Open(); MySqlCommand cmd = cnx.CreateCommand(); cmd.CommandType = CommandType.Text; // Chercher les champs d'intérêt de l'utilisateur cmd.CommandText = "SELECT * FROM bachelor WHERE id = @idBachelor"; cmd.Parameters.AddWithValue("@idBachelor", unBachelor.Id); Bachelor temp = new Bachelor(); using (DbDataReader dbrdr = cmd.ExecuteReader()) { if (dbrdr.Read()) { int id; int.TryParse(dbrdr["idbookgenres"].ToString(), out id); temp.IdBookGenres = id; int.TryParse(dbrdr["idbrands"].ToString(), out id); temp.IdBrands = id; int.TryParse(dbrdr["idhobbies"].ToString(), out id); temp.IdHobbies = id; int.TryParse(dbrdr["idmoviegenres"].ToString(), out id); temp.IdMovieGenres = id; int.TryParse(dbrdr["idmusicgenres"].ToString(), out id); temp.IdMusicGenres = id; int.TryParse(dbrdr["idsports"].ToString(), out id); temp.IdSports = id; } } // bookgenres cmd.CommandText = "SELECT * FROM bookgenres ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } if (ddlBooks.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdBookGenres)) { ddlBooks.Items.Add(uneListeDeChampInterets[i].Nom); ddlBooks.SelectedIndex = ddlBooks.Items.IndexOf(ddlBooks.Items.FindByText(uneListeDeChampInterets[i].Nom)); } else ddlBooks.Items.Add(uneListeDeChampInterets[i].Nom); } } } // brands uneListeDeChampInterets = new List<Interest>(); cmd.CommandText = "SELECT * FROM brands ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } if (ddlBrands.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdBrands)) { ddlBrands.Items.Add(uneListeDeChampInterets[i].Nom); ddlBrands.SelectedIndex = ddlBrands.Items.IndexOf(ddlBrands.Items.FindByText(uneListeDeChampInterets[i].Nom)); } else ddlBrands.Items.Add(uneListeDeChampInterets[i].Nom); } } } // hobbies uneListeDeChampInterets = new List<Interest>(); cmd.CommandText = "SELECT * FROM hobbies ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } if (ddlHobbies.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdHobbies)) { ddlHobbies.Items.Add(uneListeDeChampInterets[i].Nom); ddlHobbies.SelectedIndex = ddlHobbies.Items.IndexOf(ddlHobbies.Items.FindByText(uneListeDeChampInterets[i].Nom)); } else ddlHobbies.Items.Add(uneListeDeChampInterets[i].Nom); } } } // musicGenres uneListeDeChampInterets = new List<Interest>(); cmd.CommandText = "SELECT * FROM musicgenres ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } //LiteralControl chaineHtml = new LiteralControl(); //chaineHtml.Text = "<select id=\"musicGenres\" width=\"100%\" class=\"form-control\">"; if (ddlMusic.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdMusicGenres)) { //chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Id + "\" selected=\"selected\">" + uneListeDeChampInterets[i].Nom + "</option>"; ddlMusic.Items.Add(uneListeDeChampInterets[i].Nom); ddlMusic.SelectedIndex = ddlMusic.Items.IndexOf(ddlMusic.Items.FindByText(uneListeDeChampInterets[i].Nom));// source de: http://stackoverflow.com/questions/3496456/setting-dropdownlist-selecteditem-programmatically } else //chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Id + "\">" + uneListeDeChampInterets[i].Nom + "</option>"; ddlMusic.Items.Add(uneListeDeChampInterets[i].Nom); } } //chaineHtml.Text += "</select>"; //musicGenres.Controls.Add(chaineHtml); } // sports uneListeDeChampInterets = new List<Interest>(); cmd.CommandText = "SELECT * FROM sports ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } if (ddlSports.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdSports)) { ddlSports.Items.Add(uneListeDeChampInterets[i].Nom); ddlSports.SelectedIndex = ddlSports.Items.IndexOf(ddlSports.Items.FindByText(uneListeDeChampInterets[i].Nom)); } else ddlSports.Items.Add(uneListeDeChampInterets[i].Nom); } } } // movieGenres uneListeDeChampInterets = new List<Interest>(); cmd.CommandText = "SELECT * FROM moviegenres ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } if (ddlMovies.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdMovieGenres)) { ddlMovies.Items.Add(uneListeDeChampInterets[i].Nom); ddlMovies.SelectedIndex = ddlMovies.Items.IndexOf(ddlMovies.Items.FindByText(uneListeDeChampInterets[i].Nom)); } else ddlMovies.Items.Add(uneListeDeChampInterets[i].Nom); } } } cnx.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["isConnected"] == null) Response.Redirect("login.aspx"); if (Session["profile"] != null) { unBachelor = (Bachelor)Session["profile"]; txtId.Text = unBachelor.Id.ToString(); txtUsername.Text = unBachelor.Username; txtPassword.Text = unBachelor.Password; txtEmail.Text = unBachelor.Email; txtNumberOfLikes.Text = unBachelor.NumberOfLikes.ToString(); pbxImage.ImageUrl = unBachelor.Image; pbxImage.Height=300; pbxImage.Width = 530; } MySqlConnection cnx = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen"); cnx.Open(); MySqlCommand cmd = cnx.CreateCommand(); cmd.CommandType = CommandType.Text; // bookgenres cmd.CommandText = "SELECT * FROM bookgenres ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } LiteralControl chaineHtml = new LiteralControl(); chaineHtml.Text = "<select id=\"booksGenres\" width=\"100%\">"; for (int i = 0; i < uneListeDeChampInterets.Count; i++) { //if(uneListeDeChampInterets[i].Id.Equals(unBachelor.); chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>"; } chaineHtml.Text += "</select>"; bookGenres.Controls.Add(chaineHtml); } // brands uneListeDeChampInterets = new List<Interest>(); cmd.CommandText = "SELECT * FROM brands ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } LiteralControl chaineHtml = new LiteralControl(); chaineHtml.Text = "<select id=\"brands\" width=\"100%\">"; for (int i = 0; i < uneListeDeChampInterets.Count; i++) chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>"; chaineHtml.Text += "</select>"; brands.Controls.Add(chaineHtml); } // hobbies uneListeDeChampInterets = new List<Interest>(); cmd.CommandText = "SELECT * FROM hobbies ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } LiteralControl chaineHtml = new LiteralControl(); chaineHtml.Text = "<select id=\"hobbies\" width=\"100%\">"; for (int i = 0; i < uneListeDeChampInterets.Count; i++) chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>"; chaineHtml.Text += "</select>"; hobbies.Controls.Add(chaineHtml); } // musicGenres uneListeDeChampInterets = new List<Interest>(); cmd.CommandText = "SELECT * FROM musicgenres ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } LiteralControl chaineHtml = new LiteralControl(); chaineHtml.Text = "<select id=\"musicGenres\" width=\"100%\">"; for (int i = 0; i < uneListeDeChampInterets.Count; i++) chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>"; chaineHtml.Text += "</select>"; musicGenres.Controls.Add(chaineHtml); } // sports uneListeDeChampInterets = new List<Interest>(); cmd.CommandText = "SELECT * FROM sports ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } LiteralControl chaineHtml = new LiteralControl(); chaineHtml.Text = "<select id=\"sports\" width=\"100%\">"; for (int i = 0; i < uneListeDeChampInterets.Count; i++) chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>"; chaineHtml.Text += "</select>"; sports.Controls.Add(chaineHtml); } // moveiGenres uneListeDeChampInterets = new List<Interest>(); cmd.CommandText = "SELECT * FROM moviegenres ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } LiteralControl chaineHtml = new LiteralControl(); chaineHtml.Text = "<select id=\"movieGenres\" width=\"100%\">"; for (int i = 0; i < uneListeDeChampInterets.Count; i++) chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Nom + "\">" + uneListeDeChampInterets[i].Nom + "</option>"; chaineHtml.Text += "</select>"; movieGenres.Controls.Add(chaineHtml); } cnx.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["isConnected"] == null) { Response.Redirect("login.aspx"); } if (Session["profile"] != null) { Bachelor unBachelor = (Bachelor)Session["profile"]; lblMessageDeBienvenue.Text = "<h1>Bonjour " + unBachelor.Username + ", bienvenue sur Amélia</h1>"; } MySqlConnection cnx = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen"); cnx.Open(); MySqlCommand cmd = cnx.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT * FROM bachelor ORDER BY numberOfLikes DESC LIMIT 10"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String username = dbrdr["username"].ToString(); String password = dbrdr["password"].ToString(); String email = dbrdr["email"].ToString(); int numberOfLikes; int.TryParse(dbrdr["numberOfLikes"].ToString(), out numberOfLikes); String imagePath = dbrdr["image"].ToString(); int idBookGenres; int.TryParse(dbrdr["idbookgenres"].ToString(), out idBookGenres); int idBrands; int.TryParse(dbrdr["idbrands"].ToString(), out idBrands); int idHobbies; int.TryParse(dbrdr["idHobbies"].ToString(), out idHobbies); int idMovieGenres; int.TryParse(dbrdr["idmoviegenres"].ToString(), out idMovieGenres); int idMusicGenres; int.TryParse(dbrdr["idmusicgenres"].ToString(), out idMusicGenres); int idSports; int.TryParse(dbrdr["idsports"].ToString(), out idSports); uneListeDeBacheliers.Add(new Bachelor(id, username, password, email, numberOfLikes, imagePath, idBookGenres, idBrands, idHobbies, idMovieGenres, idMusicGenres, idSports)); //lblMessage.Text += id + username + password + email + numberOfLikes; } LiteralControl chaineHtml = new LiteralControl(); chaineHtml.Text = "<table border=\"1px solid black\" style=\"float:left;padding:10px\">"; chaineHtml.Text += "<tr><th>Rang</th><th>username</th><th>Likes</th></tr>"; for (int i = 0; i < uneListeDeBacheliers.Count; i++) { chaineHtml.Text += "<tr>"; chaineHtml.Text += "<td>" + (i + 1) + "</td>"; //chaineHtml.Text += "<td>" + uneListeDeBacheliers[i].Id + "</td>"; chaineHtml.Text += "<td>" + uneListeDeBacheliers[i].Username + "</td>"; chaineHtml.Text += "<td>" + uneListeDeBacheliers[i].NumberOfLikes + "</td>"; chaineHtml.Text += "</tr>"; } chaineHtml.Text += "</table>"; leaderboard.Controls.Add(chaineHtml); } cnx.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["isConnected"] == null) { Response.Redirect("login.aspx"); } /* * if (IsPostBack) * { * int idMusicGenres = 0; * if (Request.Form["musicGenres"] != null) * { * int.TryParse(Request.Form["musicGenres"].ToString(), out idMusicGenres); * } * int idBookGenres; * if (Request.Form["bookGenres"] != null) * { * int.TryParse(Request.Form["bookGenres"].ToString(), out idBookGenres); * } * int idMovieGenres; * int.TryParse(Request.Form["movieGenres"].ToString(), out idMovieGenres); * int idBrands; * int.TryParse(Request.Form["brands"].ToString(), out idBrands); * int idHobbies; * int.TryParse(Request.Form["hobbies"].ToString(), out idHobbies); * int idSports; * int.TryParse(Request.Form["Sports"].ToString(), out idSports); * MySqlConnection cnx0 = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen"); * cnx0.Open(); * MySqlCommand cmd0 = cnx0.CreateCommand(); * cmd0.CommandType = CommandType.Text; * cmd0.CommandText = "UPDATE bachelor SET idmusicgenres=@idMusicGenres WHERE id=@idUser"; * cmd0.Parameters.AddWithValue("@idMusicGenres", idMusicGenres); * cmd0.Parameters.AddWithValue("@idUser", ((Bachelor)Session["profile"]).Id); * int nombreLignesAffectees = cmd0.ExecuteNonQuery(); * if (nombreLignesAffectees > 0) * bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-success\"><strong>BRAVO !</strong> Vos intérêts ont été modifiés.</div>")); * else * bootstrapMessage.Controls.Add(new LiteralControl("<div class=\"alert alert-danger\"><strong>ERREUR !</strong> Vos intérêts n'ont pas pu être modifiés...</div>")); * cnx0.Close(); * } */ if (Session["profile"] != null) { unBachelor = (Bachelor)Session["profile"]; txtId.Text = unBachelor.Id.ToString(); txtUsername.Text = unBachelor.Username; txtPassword.Text = unBachelor.Password; txtEmail.Text = unBachelor.Email; txtNumberOfLikes.Text = unBachelor.NumberOfLikes.ToString(); pbxImage.ImageUrl = unBachelor.Image; pbxImage.Height = 300; pbxImage.Width = 530; } MySqlConnection cnx = new MySqlConnection("server=localhost;user=root;password=root;database=katnisseverdeen"); cnx.Open(); MySqlCommand cmd = cnx.CreateCommand(); cmd.CommandType = CommandType.Text; // Chercher les champs d'intérêt de l'utilisateur cmd.CommandText = "SELECT * FROM bachelor WHERE id = @idBachelor"; cmd.Parameters.AddWithValue("@idBachelor", unBachelor.Id); Bachelor temp = new Bachelor(); using (DbDataReader dbrdr = cmd.ExecuteReader()) { if (dbrdr.Read()) { int id; int.TryParse(dbrdr["idbookgenres"].ToString(), out id); temp.IdBookGenres = id; int.TryParse(dbrdr["idbrands"].ToString(), out id); temp.IdBrands = id; int.TryParse(dbrdr["idhobbies"].ToString(), out id); temp.IdHobbies = id; int.TryParse(dbrdr["idmoviegenres"].ToString(), out id); temp.IdMovieGenres = id; int.TryParse(dbrdr["idmusicgenres"].ToString(), out id); temp.IdMusicGenres = id; int.TryParse(dbrdr["idsports"].ToString(), out id); temp.IdSports = id; } } // bookgenres cmd.CommandText = "SELECT * FROM bookgenres ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } if (ddlBooks.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdBookGenres)) { ddlBooks.Items.Add(uneListeDeChampInterets[i].Nom); ddlBooks.SelectedIndex = ddlBooks.Items.IndexOf(ddlBooks.Items.FindByText(uneListeDeChampInterets[i].Nom)); } else { ddlBooks.Items.Add(uneListeDeChampInterets[i].Nom); } } } } // brands uneListeDeChampInterets = new List <Interest>(); cmd.CommandText = "SELECT * FROM brands ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } if (ddlBrands.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdBrands)) { ddlBrands.Items.Add(uneListeDeChampInterets[i].Nom); ddlBrands.SelectedIndex = ddlBrands.Items.IndexOf(ddlBrands.Items.FindByText(uneListeDeChampInterets[i].Nom)); } else { ddlBrands.Items.Add(uneListeDeChampInterets[i].Nom); } } } } // hobbies uneListeDeChampInterets = new List <Interest>(); cmd.CommandText = "SELECT * FROM hobbies ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } if (ddlHobbies.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdHobbies)) { ddlHobbies.Items.Add(uneListeDeChampInterets[i].Nom); ddlHobbies.SelectedIndex = ddlHobbies.Items.IndexOf(ddlHobbies.Items.FindByText(uneListeDeChampInterets[i].Nom)); } else { ddlHobbies.Items.Add(uneListeDeChampInterets[i].Nom); } } } } // musicGenres uneListeDeChampInterets = new List <Interest>(); cmd.CommandText = "SELECT * FROM musicgenres ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } //LiteralControl chaineHtml = new LiteralControl(); //chaineHtml.Text = "<select id=\"musicGenres\" width=\"100%\" class=\"form-control\">"; if (ddlMusic.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdMusicGenres)) { //chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Id + "\" selected=\"selected\">" + uneListeDeChampInterets[i].Nom + "</option>"; ddlMusic.Items.Add(uneListeDeChampInterets[i].Nom); ddlMusic.SelectedIndex = ddlMusic.Items.IndexOf(ddlMusic.Items.FindByText(uneListeDeChampInterets[i].Nom));// source de: http://stackoverflow.com/questions/3496456/setting-dropdownlist-selecteditem-programmatically } else { //chaineHtml.Text += "<option value=\"" + uneListeDeChampInterets[i].Id + "\">" + uneListeDeChampInterets[i].Nom + "</option>"; ddlMusic.Items.Add(uneListeDeChampInterets[i].Nom); } } } //chaineHtml.Text += "</select>"; //musicGenres.Controls.Add(chaineHtml); } // sports uneListeDeChampInterets = new List <Interest>(); cmd.CommandText = "SELECT * FROM sports ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } if (ddlSports.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdSports)) { ddlSports.Items.Add(uneListeDeChampInterets[i].Nom); ddlSports.SelectedIndex = ddlSports.Items.IndexOf(ddlSports.Items.FindByText(uneListeDeChampInterets[i].Nom)); } else { ddlSports.Items.Add(uneListeDeChampInterets[i].Nom); } } } } // movieGenres uneListeDeChampInterets = new List <Interest>(); cmd.CommandText = "SELECT * FROM moviegenres ORDER BY id"; using (DbDataReader dbrdr = cmd.ExecuteReader()) { while (dbrdr.Read()) { int id; int.TryParse(dbrdr["id"].ToString(), out id); String nom = dbrdr["nom"].ToString(); uneListeDeChampInterets.Add(new Interest(id, nom)); } if (ddlMovies.Items.Count <= 1) { for (int i = 0; i < uneListeDeChampInterets.Count; i++) { if (uneListeDeChampInterets[i].Id.Equals(temp.IdMovieGenres)) { ddlMovies.Items.Add(uneListeDeChampInterets[i].Nom); ddlMovies.SelectedIndex = ddlMovies.Items.IndexOf(ddlMovies.Items.FindByText(uneListeDeChampInterets[i].Nom)); } else { ddlMovies.Items.Add(uneListeDeChampInterets[i].Nom); } } } } cnx.Close(); }