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.);*/
}
}