OleDbParameterCollection.Add 方法

定义

命名空间:: System.Data.OleDb

程序集:: System.Data.OleDb.dll

程序集:: System.Data.dll

包:: System.Data.OleDb v11.0.0-preview.5.26302.115

重要

一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。

向 . OleDbParameter添加一个 OleDbParameterCollection 。

重载

名称	说明
Add(OleDbParameter)	将指定的OleDbParameter值添加到 .OleDbParameterCollection
Add(Object)	将指定的OleDbParameter对象添加到 .OleDbParameterCollection
Add(String, OleDbType)	在给定参数名称和数据类型的情况下，向 OleDbParameter添加一个OleDbParameterCollection。
Add(String, Object)	已过时. 已过时. 向给定的参数名称和值添加一个OleDbParameter OleDbParameterCollection值。
Add(String, OleDbType, Int32)	向给定的参数名称、数据类型和列长度添加一个OleDbParameter OleDbParameterCollection值。
Add(String, OleDbType, Int32, String)	向给定的参数名称、数据类型、列长度和源列名添加一个OleDbParameter OleDbParameterCollection值。

Add(OleDbParameter)

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

将指定的OleDbParameter值添加到 .OleDbParameterCollection

public:
 System::Data::OleDb::OleDbParameter ^ Add(System::Data::OleDb::OleDbParameter ^ value);

public System.Data.OleDb.OleDbParameter Add(System.Data.OleDb.OleDbParameter value);

override this.Add : System.Data.OleDb.OleDbParameter -> System.Data.OleDb.OleDbParameter

member this.Add : System.Data.OleDb.OleDbParameter -> System.Data.OleDb.OleDbParameter

Public Function Add (value As OleDbParameter) As OleDbParameter

参数

value: OleDbParameter

OleDbParameter要添加到集合中。

OleDbParameter

新 OleDbParameter 对象的索引。

例外

ArgumentException

参数OleDbParametervalue中指定的已添加到此或另一个OleDbParameterCollection参数中。

ArgumentNullException

参数 value 为 null。

示例

以下示例创建 OleDbParameterCollection 并添加一个 OleDbParameter。

public void CreateParameters()
{
    OleDbCommand command = new OleDbCommand(
        "SELECT * FROM Customers WHERE CustomerID = ?", connection);
    OleDbParameterCollection paramCollection = command.Parameters;
    OleDbParameter myParm = paramCollection.Add(
        new OleDbParameter("CustomerID", OleDbType.VarChar));
}

Public Sub CreateParameters(connection As OleDbConnection)
  Dim command As New OleDbCommand( _
    "SELECT * FROM Customers WHERE CustomerID = ?", connection)
  Dim paramCollection As OleDbParameterCollection = command.Parameters
  Dim myParm As OleDbParameter = paramCollection.Add( _
    New OleDbParameter("CustomerID", OleDbType.VarChar))
End Sub

另请参阅

适用于

Add(Object)

Source:: OleDbParameterCollectionHelper.cs

Source:: OleDbParameterCollectionHelper.cs

Source:: OleDbParameterCollectionHelper.cs

Source:: OleDbParameterCollectionHelper.cs

将指定的OleDbParameter对象添加到 .OleDbParameterCollection

public:
 override int Add(System::Object ^ value);

public:
 virtual int Add(System::Object ^ value);

public override int Add(object value);

public int Add(object value);

override this.Add : obj -> int

abstract member Add : obj -> int
override this.Add : obj -> int

Public Overrides Function Add (value As Object) As Integer

Public Function Add (value As Object) As Integer

参数

value: Object

Object。

Int32

集合中新 OleDbParameter 对象的索引。

实现

Add(Object)

另请参阅

适用于

Add(String, OleDbType)

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

在给定参数名称和数据类型的情况下，向 OleDbParameter添加一个OleDbParameterCollection。

public:
 System::Data::OleDb::OleDbParameter ^ Add(System::String ^ parameterName, System::Data::OleDb::OleDbType oleDbType);

public System.Data.OleDb.OleDbParameter Add(string? parameterName, System.Data.OleDb.OleDbType oleDbType);

public System.Data.OleDb.OleDbParameter Add(string parameterName, System.Data.OleDb.OleDbType oleDbType);

override this.Add : string * System.Data.OleDb.OleDbType -> System.Data.OleDb.OleDbParameter

member this.Add : string * System.Data.OleDb.OleDbType -> System.Data.OleDb.OleDbParameter

Public Function Add (parameterName As String, oleDbType As OleDbType) As OleDbParameter

参数

parameterName: String

参数的名称。

oleDbType: OleDbType

其中一个 OleDbType 值。

OleDbParameter

新 OleDbParameter 对象的索引。

示例

以下示例创建 OleDbParameterCollection 并添加一个 OleDbParameter。

public void CreateParameters()
{
    OleDbCommand command = new OleDbCommand(
        "SELECT * FROM Customers WHERE CustomerID = ?", connection);
    OleDbParameterCollection paramCollection = command.Parameters;
    OleDbParameter myParm = paramCollection.Add(
        "CustomerID", OleDbType.VarChar);
}

Public Sub CreateParameters(connection As OleDbConnection)
  Dim command As New OleDbCommand( _
    "SELECT * FROM Customers WHERE CustomerID = ?", connection)
  Dim paramCollection As OleDbParameterCollection = command.Parameters
  Dim myParm As OleDbParameter = paramCollection.Add( _
    "CustomerID", OleDbType.VarChar)
End Sub

另请参阅

适用于

Add(String, Object)

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

注意

Add(String parameterName, Object value) has been deprecated. Use AddWithValue(String parameterName, Object value) instead.

注意

Add(String parameterName, Object value) has been deprecated. Use AddWithValue(String parameterName, Object value). http://go.microsoft.com/fwlink/?linkid=14202

向给定的参数名称和值添加一个OleDbParameter OleDbParameterCollection值。

public:
 System::Data::OleDb::OleDbParameter ^ Add(System::String ^ parameterName, System::Object ^ value);

[System.Obsolete("Add(String parameterName, Object value) has been deprecated. Use AddWithValue(String parameterName, Object value) instead.")]
public System.Data.OleDb.OleDbParameter Add(string? parameterName, object? value);

public System.Data.OleDb.OleDbParameter Add(string parameterName, object value);

[System.Obsolete("Add(String parameterName, Object value) has been deprecated.  Use AddWithValue(String parameterName, Object value).  http://go.microsoft.com/fwlink/?linkid=14202", false)]
public System.Data.OleDb.OleDbParameter Add(string parameterName, object value);

[<System.Obsolete("Add(String parameterName, Object value) has been deprecated. Use AddWithValue(String parameterName, Object value) instead.")>]
override this.Add : string * obj -> System.Data.OleDb.OleDbParameter

member this.Add : string * obj -> System.Data.OleDb.OleDbParameter

[<System.Obsolete("Add(String parameterName, Object value) has been deprecated.  Use AddWithValue(String parameterName, Object value).  http://go.microsoft.com/fwlink/?linkid=14202", false)>]
override this.Add : string * obj -> System.Data.OleDb.OleDbParameter

Public Function Add (parameterName As String, value As Object) As OleDbParameter

参数

parameterName: String

参数的名称。

value: Object

Value OleDbParameter要添加到集合中的项。

OleDbParameter

新 OleDbParameter 对象的索引。

属性: ObsoleteAttribute

例外

InvalidCastException

参数 value 不是 OleDbParameter.

注解

使用此方法重载 Add 指定整数参数值时请小心。由于此重载采用某种 value 类型 Object，因此在值为零时必须将值转换为类型 Object 。如果不执行此转换，编译器将假定你正在尝试调用 Add 重载。

另请参阅

适用于

Add(String, OleDbType, Int32)

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

向给定的参数名称、数据类型和列长度添加一个OleDbParameter OleDbParameterCollection值。

public:
 System::Data::OleDb::OleDbParameter ^ Add(System::String ^ parameterName, System::Data::OleDb::OleDbType oleDbType, int size);

public System.Data.OleDb.OleDbParameter Add(string? parameterName, System.Data.OleDb.OleDbType oleDbType, int size);

public System.Data.OleDb.OleDbParameter Add(string parameterName, System.Data.OleDb.OleDbType oleDbType, int size);

override this.Add : string * System.Data.OleDb.OleDbType * int -> System.Data.OleDb.OleDbParameter

member this.Add : string * System.Data.OleDb.OleDbType * int -> System.Data.OleDb.OleDbParameter

Public Function Add (parameterName As String, oleDbType As OleDbType, size As Integer) As OleDbParameter

参数

parameterName: String

参数的名称。

oleDbType: OleDbType

其中一个 OleDbType 值。

size: Int32

列的长度。

OleDbParameter

新 OleDbParameter 对象的索引。

示例

以下示例创建一个 OleDbParameterCollection、将集合的 OleDbParameter 实例添加到集合中，并返回对新 OleDbParameter项的引用。

public void CreateParameters(OleDbConnection connection)
{
    OleDbCommand command = new OleDbCommand(
        "SELECT * FROM Customers WHERE CustomerID = ?", connection);
    OleDbParameterCollection paramCollection = command.Parameters;
    OleDbParameter parameter = paramCollection.Add(
        "CustomerID", OleDbType.VarChar, 5);
}

Public Sub CreateParameters(connection As OleDbConnection)
  Dim command As New OleDbCommand( _
    "SELECT * FROM Customers WHERE CustomerID = ?", connection)
  Dim paramCollection As OleDbParameterCollection = command.Parameters
  Dim parameter As OleDbParameter = paramCollection.Add( _
    "CustomerID", OleDbType.VarChar, 5)
End Sub

另请参阅

适用于

Add(String, OleDbType, Int32, String)

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

Source:: OleDbParameterCollection.cs

向给定的参数名称、数据类型、列长度和源列名添加一个OleDbParameter OleDbParameterCollection值。

public:
 System::Data::OleDb::OleDbParameter ^ Add(System::String ^ parameterName, System::Data::OleDb::OleDbType oleDbType, int size, System::String ^ sourceColumn);

public System.Data.OleDb.OleDbParameter Add(string? parameterName, System.Data.OleDb.OleDbType oleDbType, int size, string? sourceColumn);

public System.Data.OleDb.OleDbParameter Add(string parameterName, System.Data.OleDb.OleDbType oleDbType, int size, string sourceColumn);

override this.Add : string * System.Data.OleDb.OleDbType * int * string -> System.Data.OleDb.OleDbParameter

member this.Add : string * System.Data.OleDb.OleDbType * int * string -> System.Data.OleDb.OleDbParameter

Public Function Add (parameterName As String, oleDbType As OleDbType, size As Integer, sourceColumn As String) As OleDbParameter

参数

parameterName: String

参数的名称。

oleDbType: OleDbType

其中一个 OleDbType 值。

size: Int32

列的长度。

sourceColumn: String

源列的名称。

OleDbParameter

新 OleDbParameter 对象的索引。

示例

以下示例创建一个 OleDbParameterCollection、将集合的 OleDbParameter 实例添加到集合中，并返回对新 OleDbParameter项的引用。

public void CreateParameters(OleDbConnection connection)
{
    OleDbCommand command = new OleDbCommand(
        "SELECT * FROM Customers WHERE CustomerID = ?", connection);
    OleDbParameterCollection paramCollection = command.Parameters;
    OleDbParameter parameter = paramCollection.Add(
        "CustomerID", OleDbType.VarChar, 5, "CustomerID");
}

Public Sub CreateParameters(connection As OleDbConnection)
  Dim command As New OleDbCommand( _
    "SELECT * FROM Customers WHERE CustomerID = ?", connection)
  Dim paramCollection As OleDbParameterCollection = command.Parameters
  Dim parameter As OleDbParameter = paramCollection.Add( _
    "CustomerID", OleDbType.VarChar, 5, "CustomerID")
End Sub

另请参阅

适用于

反馈

此页面是否有帮助？