Torna al Thread

Private Ds As DataSet Private ConnString As String = "TuaStringa di connessione" Private Conn As SqlClient.SqlConnection Private Da As SqlClient.SqlDataAdapter Private Cmd As SqlClient.SqlCommand Private Sub PopolaDataset() Conn = New SqlClient.SqlConnection(ConnString) Cmd = New SqlClient.SqlCommand("SELECT IDAna, Dal, Operativa FROM Operativa WHERE IDAna = @IDAna order by Dal", Conn) Cmd.Parameters.Add(New SqlClient.SqlParameter With {.ParameterName = "@IDAna", .SqlDbType = SqlDbType.Int, .Value = Combobox1.selectedvalue}) Da = New SqlClient.SqlDataAdapter(Cmd) Ds = New DataSet Da.Fill(Ds, "Tabella1") End Sub
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5