Classe StoredProcedureParameterCollection
The StoredProcedureParameterCollection class represents a collection of StoredProcedureParameter objects that represent all the stored procedure parameters defined on a table.
Hiérarchie d'héritage
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .AbstractCollectionBase
Microsoft.SqlServer.Management.Smo. . :: . .SmoCollectionBase
Microsoft.SqlServer.Management.Smo. . :: . .ArrayListCollectionBase
Microsoft.SqlServer.Management.Smo. . :: . .ParameterCollectionBase
Microsoft.SqlServer.Management.Smo..::..StoredProcedureParameterCollection
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public NotInheritable Class StoredProcedureParameterCollection _
Inherits ParameterCollectionBase
'Utilisation
Dim instance As StoredProcedureParameterCollection
public sealed class StoredProcedureParameterCollection : ParameterCollectionBase
public ref class StoredProcedureParameterCollection sealed : public ParameterCollectionBase
[<SealedAttribute>]
type StoredProcedureParameterCollection =
class
inherit ParameterCollectionBase
end
public final class StoredProcedureParameterCollection extends ParameterCollectionBase
Le type StoredProcedureParameterCollection expose les membres suivants.
Propriétés
Nom | Description | |
---|---|---|
Count | Gets the number of objects in the referenced collection. (hérité de SmoCollectionBase.) | |
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (hérité de SmoCollectionBase.) | |
Item[ ( [ ( Int32] ) ] ) | Gets a StoredProcedureParameter object in the collection by index number. | |
Item[ ( [ ( String] ) ] ) | Gets a StoredProcedureParameter object in the collection by name. | |
Parent | Gets the StoredProcedure object that is the parent of the StoredProcedureParameter object. | |
SyncRoot | Gets an object that can be used to synchronize access to the collection. (hérité de SmoCollectionBase.) |
Haut de la page
Méthodes
Nom | Description | |
---|---|---|
Add(StoredProcedureParameter) | Adds a StoredProcedureParameter object to the StoredProcedureParameterCollection object. | |
Add(StoredProcedureParameter, Int32) | Adds a StoredProcedureParameter object to the StoredProcedureParameterCollection object. | |
Add(StoredProcedureParameter, String) | Adds a StoredProcedureParameter object to the StoredProcedureParameterCollection object. | |
AddExisting | Adds an object to the collection. (hérité de AbstractCollectionBase.) | |
AddImpl | Adds an object or member to this collection at the specified index. (hérité de ArrayListCollectionBase.) | |
Contains | Validates whether the parameter collection contains a member with a name equal to the specified string. (hérité de ParameterCollectionBase.) | |
CopyTo | Copies the collection objects to a one-dimensional array starting at the index value specified. | |
Equals | (hérité de Object.) | |
Finalize | (hérité de Object.) | |
GetCollectionElementType | Gets the Collection Element Type. (hérité de SmoCollectionBase.) | |
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (hérité de SmoCollectionBase.) | |
GetHashCode | (hérité de Object.) | |
GetItemById(Int32) | Extracts a member from the referenced collection using a system-defined, unique identifier. (hérité de SmoCollectionBase.) | |
GetItemById(Int32, String) | Extracts a member from the referenced collection using a system-defined, unique identifier and name. (hérité de SmoCollectionBase.) | |
GetObjectByIndex | Extracts a member from the referenced collection using a system-defined, unique identifier. (hérité de SmoCollectionBase.) | |
GetType | (hérité de Object.) | |
ImplAddExisting | Adds an object to a collection. (hérité de ParameterCollectionBase.) | |
InitializeChildCollection() () () () | Initializes the child collections of the referenced collection. (hérité de SmoCollectionBase.) | |
InitializeChildCollection(Boolean) | Initializes the child collections of the referenced collection with the option to refresh the properties of the referenced collection. (hérité de SmoCollectionBase.) | |
InitInnerCollection | Initializes a collection. (hérité de ParameterCollectionBase.) | |
ItemById | Extracts a member from the StoredProcedureParameterCollection object using a system-defined, unique identifier. | |
MemberwiseClone | (hérité de Object.) | |
Refresh() () () () | Refreshes the referenced collection. (hérité de SmoCollectionBase.) | |
Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (hérité de SmoCollectionBase.) | |
Remove(String) | Removes a member from the collection with the specified name. (hérité de ParameterCollectionBase.) | |
Remove(StoredProcedureParameter) | Removes a StoredProcedureParameter object from the StoredProcedureParameterCollection object. | |
ToString | (hérité de Object.) | |
ValidateParentObject | Validates the parent object exists. (hérité de SmoCollectionBase.) |
Haut de la page
Champs
Nom | Description | |
---|---|---|
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (hérité de AbstractCollectionBase.) |
Haut de la page
Implémentations d'interfaces explicites
Nom | Description | |
---|---|---|
ICollection. . :: . .CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (hérité de SmoCollectionBase.) |
Haut de la page
Notes
A StoredProcedureParameterCollection object can be used to gain access to a set of stored procedure parameters. You can use the Item property to return a specific StoredProcedureParameter object.
Thread Safety
Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.
Sécurité des threads
Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.