Torna al Thread

Dim _cmd As SqlClient.SqlCommand = New SqlClient.SqlCommand("SPGETSPPARAMETERS", Connessione) _cmd.CommandType = CommandType.StoredProcedure _cmd.Parameters.AddWithValue("@StoredProcedure", StoredProcedure) Dim _adapter As SqlDataAdapter = New SqlDataAdapter(_cmd) Dim _parametri As New DataTable _adapter.Fill(_parametri) Dim Comando As SqlCommand = New SqlCommand(StoredProcedure) For i As Int16 = 0 To _parametri.Rows.Count - 1 If ClasseForm.Controls.Item(Mid(_parametri.Rows(i).Item("Nome").ToString, 2)) IsNot Nothing Then Comando.Parameters.AddWithValue(_parametri.Rows(i).Item("Nome").ToString, ClasseForm.Controls.Item(Mid(_parametri.Rows(i).Item("Nome").ToString, 2)).Text) Select Case _parametri.Rows(i).Item("Direzione").ToString Case "IN" Comando.Parameters.Item(_parametri.Rows(i).Item("Nome").ToString).Direction = ParameterDirection.Input Case "INOUT" Comando.Parameters.Item(_parametri.Rows(i).Item("Nome").ToString).Direction = ParameterDirection.InputOutput End Select End If Next Return Comando
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5