private void Form1_Load(object sender, System.EventArgs e) { dataA.Open(); string sql = "select * from distinctYearDate"; SqlCommand cmd = new SqlCommand(sql, dataA); SqlDataReader dr = cmd.ExecuteReader(); List <string> priv = new List <string>(); // var columns = new List<String>(); // var reader = cmd.ExecuteReader(); //hidEmployee = "1"; while (dr.Read()) { priv.Add(dr[0].ToString().TrimEnd()); //String str = dr.GetValue(6); } foreach (string str in priv) { dateYearText.Items.Add(str); } dr.Close(); dataA.Close(); dataA.Open(); sql = "select * from distinctCountryHotel"; cmd = new SqlCommand(sql, dataA); dr = cmd.ExecuteReader(); priv = new List <string>(); // var columns = new List<String>(); // var reader = cmd.ExecuteReader(); //hidEmployee = "1"; while (dr.Read()) { priv.Add(dr[0].ToString().TrimEnd()); //String str = dr.GetValue(6); } foreach (string str in priv) { hotelCountryText.Items.Add(str); } dr.Close(); dataA.Close(); dataA.Open(); sql = "exec getClientDWCountry"; cmd = new SqlCommand(sql, dataA); dr = cmd.ExecuteReader(); priv = new List <string>(); // var columns = new List<String>(); // var reader = cmd.ExecuteReader(); //hidEmployee = "1"; while (dr.Read()) { priv.Add(dr[0].ToString().TrimEnd()); //String str = dr.GetValue(6); } foreach (string str in priv) { clientCountryText.Items.Add(str); } dr.Close(); dataA.Close(); dataA.Close(); dataA.Open(); sql = "select * from distinctProvinceHotel"; cmd = new SqlCommand(sql, dataA); dr = cmd.ExecuteReader(); priv = new List <string>(); // var columns = new List<String>(); // var reader = cmd.ExecuteReader(); //hidEmployee = "1"; while (dr.Read()) { priv.Add(dr[0].ToString().TrimEnd()); //String str = dr.GetValue(6); } foreach (string str in priv) { hotelProvinceText.Items.Add(str); } dr.Close(); dataA.Close(); dataA.Open(); sql = "select * from distinctProvinceClient"; cmd = new SqlCommand(sql, dataA); dr = cmd.ExecuteReader(); priv = new List <string>(); // var columns = new List<String>(); // var reader = cmd.ExecuteReader(); //hidEmployee = "1"; while (dr.Read()) { priv.Add(dr[0].ToString().TrimEnd()); //String str = dr.GetValue(6); } foreach (string str in priv) { clientProvinceText.Items.Add(str); } dr.Close(); dataA.Close(); dataA.Open(); sql = "select * from distinctCityHotel"; cmd = new SqlCommand(sql, dataA); dr = cmd.ExecuteReader(); priv = new List <string>(); // var columns = new List<String>(); // var reader = cmd.ExecuteReader(); //hidEmployee = "1"; while (dr.Read()) { priv.Add(dr[0].ToString().TrimEnd()); //String str = dr.GetValue(6); } foreach (string str in priv) { hotelCityText.Items.Add(str); } dr.Close(); dataA.Close(); dataA.Open(); sql = "select * from distinctCityClient"; cmd = new SqlCommand(sql, dataA); dr = cmd.ExecuteReader(); priv = new List <string>(); // var columns = new List<String>(); // var reader = cmd.ExecuteReader(); //hidEmployee = "1"; while (dr.Read()) { priv.Add(dr[0].ToString().TrimEnd()); //String str = dr.GetValue(6); } foreach (string str in priv) { clientCityText.Items.Add(str); } dr.Close(); dataA.Close(); }
public static void Main(string[] args) { Personne p1 = new Personne(); Personne p2 = new Personne("Jean", "Louis"); Personne p3 = new Personne() { Nom = "El", Prenom = "Jean" }; Personne p4 = p2.Clone() as Personne; //Personne p4 = (Personne) p2.Clone(); //Console.WriteLine(p1); Console.WriteLine(p2); Console.WriteLine(p4); p2.Nom = "Cronier"; p4.Prenom = "Antoine"; Console.WriteLine(p2); Console.WriteLine(p4); //Console.WriteLine(p3); Jeu <CardGame> jeu = new Bataille(); // A proscrire je ne connais pas le type réel => Jeu<CardGame> //var jeu = new Bataille(); jeu.play(); // new sur abstract impossible. //Jeu jeu1 = new Jeu(); // var ici est possible car membre de droite connu var jeux = new List <Jeu <CardGame> >(); jeux.Add(jeu); jeux.Add(new Bataille()); foreach (var item in jeux) { item.play(); // Attention ne pas modifier les valeurs d'item dans le foreach } for (int i = 0; i < jeux.Count; i++) { jeux.ElementAt(i).play(); } Console.WriteLine(Extension.Add(10, 12)); int a = 10; Console.WriteLine(a.Add(12)); String b = "aizpepoazipe"; Console.WriteLine(b.Add("11111")); Func <String> func1 = new Func <string>(() => { return("func1"); }); Console.WriteLine(func1.Invoke()); Func <int, int, String> func2 = new Func <int, int, String>((i, j) => { return("produit i et j => " + (i * j)); }); Console.WriteLine(func2.Invoke(10, 12)); func2 = func2Test; Console.WriteLine(func2.Invoke(10, 12)); Action a1 = new Action(() => { Console.WriteLine("in a1"); Console.WriteLine(func2.Invoke(10, 12)); }); a1.Invoke(); Task.Factory.StartNew(() => { for (int i = 0; i < 10000; i++) { Console.WriteLine(i); } }); jeux.Where(x => x.Name.Equals("bataille")); Console.ReadKey(); }