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 继承。） |
|
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 继承。） |
|
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. （从 SmoCollectionBase 继承。） |
|
GetHashCode | （从 Object 继承。） |
|
GetType | （从 Object 继承。） |
|
ItemById | Extracts a member from the StoredProcedureParameterCollection object using a system-defined, unique identifier. |
|
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 继承。） |
页首
字段
| 名称 | 说明 | |
|---|---|---|
.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 中的 Shared）成员在多线程操作中是安全的。但不保证所有实例成员都是线程安全的。
示例
线程安全
此类型的任何公共 static（在 Visual Basic 中为 Shared） 成员都是线程安全的。不保证所有实例成员都是线程安全的。