Torna al Thread

public void button1_Click(object sender, EventArgs e) { List<string> RisultatoPrimo = new List<string>(); List<string> RisultatoCristina = new List<string>(); if (primo.Checked) { SqlConnection sqlConnection1 = new SqlConnection(@"Data Source=(LocalDB)\v12.0;AttachDbFilename= C:\Users\Giovanni Camera\Documents\Visual Studio 2015\Projects\WindowsFormsApplication7\WindowsFormsApplication7\prova.MDF; Integrated Security = True"); SqlCommand comm = new SqlCommand("SELECT NomeRicette FROM Prova WHERE Primo = 'Y' ", sqlConnection1); SqlDataAdapter da = new SqlDataAdapter(comm); DataTable dt = new DataTable(); try { sqlConnection1.Open(); da.Fill(dt); foreach (DataRow row in dt.Rows) { RisultatoPrimo.Add(Convert.ToString(row["NomeRicette"])); } RisultatoRicercaRicette.Items.AddRange(RisultatoPrimo.ToArray()); sqlConnection1.Close(); } catch (Exception ex) { textBox2.Text = ex.Message; MessageBox.Show(ex.Message); } } if (cristina.Checked) { SqlConnection sqlConnection1 = new SqlConnection(@"Data Source=(LocalDB)\v12.0;AttachDbFilename= C:\Users\Giovanni Camera\Documents\Visual Studio 2015\Projects\WindowsFormsApplication7\WindowsFormsApplication7\prova.MDF; Integrated Security = True"); SqlCommand comm = new SqlCommand("SELECT NomeRicette FROM Prova WHERE Cristina = 'Y' ", sqlConnection1); SqlDataAdapter da = new SqlDataAdapter(comm); DataTable dt = new DataTable(); try { sqlConnection1.Open(); da.Fill(dt); foreach (DataRow row in dt.Rows) { RisultatoCristina.Add(Convert.ToString(row["NomeRicette"])); } RisultatoRicercaRicette.Items.AddRange(RisultatoCristina.ToArray()); sqlConnection1.Close(); } catch (Exception ex) { textBox2.Text = ex.Message; MessageBox.Show(ex.Message); } /* bool a = true; for (int i = 0; i < RisultatoPrimo.Count; i++) { a = RisultatoPrimo.ElementAt(i) == RisultatoCristina.ElementAt(i); } RisultatoRicercaRicette.Items.AddRange(a.);*/ } }
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5