Torna al Thread

Private Sub ExecuteSqlStatement(param As String, connString As String) Using conn As New SqlConnection(connString) conn.Open() Using cmd As New SqlCommand("SELECT * FROM Fornitori WHERE RagioneSociale LIKE @RagioneSociale + '%'", conn) Dim dt As New DataTable() cmd.Parameters.AddWithValue("@RagioneSociale", param) Using da As New SqlDataAdapter(cmd) da.Fill(dt) dataGridView1.DataSource = dt End Using End Using conn.Close() End Using End Sub
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5