StoredProcedureParameterCollection 類別
The StoredProcedureParameterCollection class represents a collection of StoredProcedureParameter objects that represent all the stored procedure parameters defined on a table.
繼承階層
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
命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
Public NotInheritable Class StoredProcedureParameterCollection _
Inherits ParameterCollectionBase
'用途
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
StoredProcedureParameterCollection 型別公開下列成員。
屬性
| 名稱 | 說明 | |
|---|---|---|
.gif "公用屬性") |
Count | Gets the number of objects in the referenced collection. (繼承自 SmoCollectionBase。) |
|
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (繼承自 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. (繼承自 SmoCollectionBase。) |
上層
方法
| 名稱 | 說明 | |
|---|---|---|
.gif "公用方法") |
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. |
.gif "受保護的方法") |
AddExisting | Adds an object to the collection. (繼承自 AbstractCollectionBase。) |
|
AddImpl | Adds an object or member to this collection at the specified index. (繼承自 ArrayListCollectionBase。) |
|
Contains | Validates whether the parameter collection contains a member with a name equal to the specified string. (繼承自 ParameterCollectionBase。) |
|
CopyTo | Copies the collection objects to a one-dimensional array starting at the index value specified. |
|
Equals | (繼承自 Object。) |
|
Finalize | (繼承自 Object。) |
|
GetCollectionElementType | Gets the Collection Element Type. (繼承自 SmoCollectionBase。) |
|
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (繼承自 SmoCollectionBase。) |
|
GetHashCode | (繼承自 Object。) |
|
GetItemById(Int32) | Extracts a member from the referenced collection using a system-defined, unique identifier. (繼承自 SmoCollectionBase。) |
|
GetItemById(Int32, String) | Extracts a member from the referenced collection using a system-defined, unique identifier and name. (繼承自 SmoCollectionBase。) |
|
GetObjectByIndex | Extracts a member from the referenced collection using a system-defined, unique identifier. (繼承自 SmoCollectionBase。) |
|
GetType | (繼承自 Object。) |
|
ImplAddExisting | Adds an object to a collection. (繼承自 ParameterCollectionBase。) |
|
InitializeChildCollection() () () () | Initializes the child collections of the referenced collection. (繼承自 SmoCollectionBase。) |
|
InitializeChildCollection(Boolean) | Initializes the child collections of the referenced collection with the option to refresh the properties of the referenced collection. (繼承自 SmoCollectionBase。) |
|
InitInnerCollection | Initializes a collection. (繼承自 ParameterCollectionBase。) |
|
ItemById | Extracts a member from the StoredProcedureParameterCollection object using a system-defined, unique identifier. |
|
MemberwiseClone | (繼承自 Object。) |
|
Refresh() () () () | Refreshes the referenced collection. (繼承自 SmoCollectionBase。) |
|
Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (繼承自 SmoCollectionBase。) |
|
Remove(String) | Removes a member from the collection with the specified name. (繼承自 ParameterCollectionBase。) |
|
Remove(StoredProcedureParameter) | Removes a StoredProcedureParameter object from the StoredProcedureParameterCollection object. |
|
ToString | (繼承自 Object。) |
|
ValidateParentObject | Validates the parent object exists. (繼承自 SmoCollectionBase。) |
上層
欄位
| 名稱 | 說明 | |
|---|---|---|
.gif "受保護的欄位") |
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (繼承自 AbstractCollectionBase。) |
上層
明確 繼承 實作
| 名稱 | 說明 | |
|---|---|---|
.gif "明確介面實作") .gif "私用方法") |
ICollection. . :: . .CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (繼承自 SmoCollectionBase。) |
上層
備註
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
此型別的任何公用靜態 (在 Microsoft Visual Basic 為共用) 成員具備多執行緒作業安全。不保證所有執行個體成員都是安全執行緒。
執行緒安全性
這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。