private void b1_click(object sender, RoutedEventArgs e) { Trace st = dg.SelectedItem as Trace; if (st != null) { String gag1 = st.nom; cnx.Open(); string readString3 = "select * from Trace where nom ='" + gag1 + "'"; SqlCommand readCommand3 = new SqlCommand(readString3, cnx); int nbs = 1000; using (SqlDataReader dataRead3 = readCommand3.ExecuteReader()) { if (dataRead3 != null) { while (dataRead3.Read()) { string xas = dataRead3["Id"].ToString(); nbs = int.Parse(xas); string xas2 = dataRead3["echelle"].ToString(); double eche = double.Parse(xas2); string xas22 = dataRead3["echellecarte"].ToString(); double echecarte = double.Parse(xas22); string xas4 = dataRead3["equidistance"].ToString(); int equi = int.Parse(xas4); string xas6 = dataRead3["min"].ToString(); double mi = Double.Parse(xas6); string xas8 = dataRead3["max"].ToString(); double ma = Double.Parse(xas8); string xas10 = dataRead3["creation"].ToString(); string xas105 = dataRead3["modification"].ToString(); aym = nbs; string xasa = dataRead3["image"].ToString(); Uri ur = new Uri(xasa); imgg = new BitmapImage(ur); Trace trace5 = new Trace(gag1, xas10, xas105, mi, ma, eche, echecarte, equi, xasa); trr = trace5; } } } cnx.Close(); tracecourbes imp = new tracecourbes(imgg, trr); var parent = (Grid)this.Parent; parent.Children.Clear(); parent.Children.Add(imp); } else { MessageBox.Show("Veillez selectionner un tracé."); } }
private void recherche() { cnx.Open(); string readString3 = "select * from Trace where nom ='" + nomTrace.Text + "'"; SqlCommand readCommand3 = new SqlCommand(readString3, cnx); int nbs = 1000; using (SqlDataReader dataRead3 = readCommand3.ExecuteReader()) { if (dataRead3 != null) { while (dataRead3.Read()) { string xas = dataRead3["Id"].ToString(); nbs = int.Parse(xas); string xas2 = dataRead3["echelle"].ToString(); double eche = double.Parse(xas2); string xas22 = dataRead3["echellecarte"].ToString(); double echecarte = double.Parse(xas22); string xas4 = dataRead3["equidistance"].ToString(); int equi = int.Parse(xas4); string xas6 = dataRead3["min"].ToString(); double mi = Double.Parse(xas6); string xas8 = dataRead3["max"].ToString(); double ma = Double.Parse(xas8); string xas10 = dataRead3["creation"].ToString(); string xas105 = dataRead3["modification"].ToString(); aym = nbs; string xasa = dataRead3["image"].ToString(); Uri ur = new Uri(xasa); imgg = new BitmapImage(ur); Trace trace5 = new Trace(nomTrace.Text, xas10, xas105, mi, ma, eche, echecarte, equi, xasa); trr = trace5; } } } cnx.Close(); if (aym == -1) { MessageBox.Show(" Aucun tracé ne correspond au nom saisi."); } else { tracecourbes imp = new tracecourbes(imgg, trr); var parent = (Grid)this.Parent; parent.Children.Clear(); parent.Children.Add(imp); } }