Torna al Thread

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(); }
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5