Fórum Executar uma storage procedure do sqlserver dentro do vb.net #19913

  Dim conn As New SqlConnection()
        conn.ConnectionString = "Data Source=ServerName;Initial Catalog=Northwind;Persist Security Info=True;User ID=<user name>;Password=<your password>"

        Dim cmd As New SqlCommand()
        cmd.Connection = conn
        cmd.CommandType = CommandType.StoredProcedure
        cmd.CommandText = "CustOrderHist"

        ´ Create a SqlParameter for each parameter in the stored procedure.
        Dim customerIDParam As New SqlParameter("@NomeParametro", "Valor")
        Dim customerIDParam2  As New SqlParameter("@NomeParametro", "Valor")
         Dim customerIDParam3  As New SqlParameter("@NomeParametro", "Valor")

        cmd.Parameters.Add(customerIDParam)
        cmd.Parameters.Add(customerIDParam2)
        cmd.Parameters.Add(customerIDParam3)

        Dim rowCount As Integer
        Dim previousConnectionState As ConnectionState
        previousConnectionState = conn.State
        Try
            If conn.State = ConnectionState.Closed Then
                conn.Open()
            End If
            rowCount = cmd.ExecuteNonQuery()

        Finally
            If previousConnectionState = ConnectionState.Closed Then
                conn.Close()
            End If
        End Try