OleDbParameterCollection.Add Método

Definição

Sobrecargas

Add(OleDbParameter)

Adiciona o OleDbParameter especificado ao OleDbParameterCollection.Adds the specified OleDbParameter to the OleDbParameterCollection.

Add(Object)

Adiciona o objeto OleDbParameter especificado ao OleDbParameterCollection.Adds the specified OleDbParameter object to the OleDbParameterCollection.

Add(String, OleDbType)

Adiciona um OleDbParameter ao OleDbParameterCollection, dado o nome do parâmetro o tipo de dados.Adds an OleDbParameter to the OleDbParameterCollection, given the parameter name and data type.

Add(String, Object)
Obsoleto.

Adiciona um OleDbParameter ao OleDbParameterCollection dado o nome e o valor do parâmetro.Adds an OleDbParameter to the OleDbParameterCollection given the parameter name and value.

Add(String, OleDbType, Int32)

Adiciona um OleDbParameter ao OleDbParameterCollection dado o nome do parâmetro, o tipo de dados e o comprimento da coluna.Adds an OleDbParameter to the OleDbParameterCollection given the parameter name, data type, and column length.

Add(String, OleDbType, Int32, String)

Adiciona um OleDbParameter ao OleDbParameterCollection, considerando o nome de parâmetro, tipo de dados, tamanho da coluna e nome da coluna de origem.Adds an OleDbParameter to the OleDbParameterCollection given the parameter name, data type, column length, and source column name.

Add(OleDbParameter)

Adiciona o OleDbParameter especificado ao OleDbParameterCollection.Adds the specified OleDbParameter to the 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

Parâmetros

value
OleDbParameter

O OleDbParameter a adicionar à coleção.The OleDbParameter to add to the collection.

Retornos

OleDbParameter

O índice do novo objeto OleDbParameter.The index of the new OleDbParameter object.

Exceções

O OleDbParameter especificado no parâmetro value já foi adicionado a este ou a outro OleDbParameterCollection.The OleDbParameter specified in the value parameter is already added to this or another OleDbParameterCollection.

O parâmetro value é nulo.The value parameter is null.

Exemplos

O exemplo a seguir cria um OleDbParameterCollection e adiciona um OleDbParameter .The following example creates an OleDbParameterCollection and adds an 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 

Aplica-se a

Add(Object)

Adiciona o objeto OleDbParameter especificado ao OleDbParameterCollection.Adds the specified OleDbParameter object to the 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

Parâmetros

value
Object

Um Object.A Object.

Retornos

Int32

O índice do novo objeto OleDbParameter na coleção.The index of the new OleDbParameter object in the collection.

Implementações

Aplica-se a

Add(String, OleDbType)

Adiciona um OleDbParameter ao OleDbParameterCollection, dado o nome do parâmetro o tipo de dados.Adds an OleDbParameter to the OleDbParameterCollection, given the parameter name and data type.

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

Parâmetros

parameterName
String

O nome do parâmetro.The name of the parameter.

oleDbType
OleDbType

Um dos valores de OleDbType.One of the OleDbType values.

Retornos

OleDbParameter

O índice do novo objeto OleDbParameter.The index of the new OleDbParameter object.

Exemplos

O exemplo a seguir cria um OleDbParameterCollection e adiciona um OleDbParameter .The following example creates an OleDbParameterCollection and adds an 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 

Aplica-se a

Add(String, Object)

Cuidado

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

Adiciona um OleDbParameter ao OleDbParameterCollection dado o nome e o valor do parâmetro.Adds an OleDbParameter to the OleDbParameterCollection given the parameter name and value.

public:
 System::Data::OleDb::OleDbParameter ^ Add(System::String ^ parameterName, System::Object ^ value);
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);
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

Parâmetros

parameterName
String

O nome do parâmetro.The name of the parameter.

value
Object

O Value do OleDbParameter para adicionar à coleção.The Value of the OleDbParameter to add to the collection.

Retornos

OleDbParameter

O índice do novo objeto OleDbParameter.The index of the new OleDbParameter object.

Atributos

Exceções

O parâmetro value não é um OleDbParameter.The value parameter is not an OleDbParameter.

Comentários

Tenha cuidado ao usar essa sobrecarga do Add método para especificar valores de parâmetro de número inteiro.Use caution when using this overload of the Add method to specify integer parameter values. Como essa sobrecarga usa um value tipo de Object , você deve converter o valor em um Object tipo quando o valor for zero, como demonstra o exemplo de C# a seguir.Because this overload takes a value of type Object, you must convert the value to an Object type when the value is zero, as the following C# example demonstrates.

parameters.Add("@pname", Convert.ToInt32(0));  

Se você não executar essa conversão, o compilador irá pressupor que você está tentando chamar a Add sobrecarga.If you do not perform this conversion, the compiler will assume you are attempting to call the Add overload.

Aplica-se a

Add(String, OleDbType, Int32)

Adiciona um OleDbParameter ao OleDbParameterCollection dado o nome do parâmetro, o tipo de dados e o comprimento da coluna.Adds an OleDbParameter to the OleDbParameterCollection given the parameter name, data type, and column length.

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

Parâmetros

parameterName
String

O nome do parâmetro.The name of the parameter.

oleDbType
OleDbType

Um dos valores de OleDbType.One of the OleDbType values.

size
Int32

O comprimento da coluna.The length of the column.

Retornos

OleDbParameter

O índice do novo objeto OleDbParameter.The index of the new OleDbParameter object.

Exemplos

O exemplo a seguir cria um OleDbParameterCollection , adiciona uma instância do OleDbParameter à coleção e retorna uma referência para o novo OleDbParameter .The following example creates an OleDbParameterCollection, adds an instance of OleDbParameter to the collection, and returns a reference to the new 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

Aplica-se a

Add(String, OleDbType, Int32, String)

Adiciona um OleDbParameter ao OleDbParameterCollection, considerando o nome de parâmetro, tipo de dados, tamanho da coluna e nome da coluna de origem.Adds an OleDbParameter to the OleDbParameterCollection given the parameter name, data type, column length, and source column name.

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

Parâmetros

parameterName
String

O nome do parâmetro.The name of the parameter.

oleDbType
OleDbType

Um dos valores de OleDbType.One of the OleDbType values.

size
Int32

O comprimento da coluna.The length of the column.

sourceColumn
String

O nome da coluna de origem.The name of the source column.

Retornos

OleDbParameter

O índice do novo objeto OleDbParameter.The index of the new OleDbParameter object.

Exemplos

O exemplo a seguir cria um OleDbParameterCollection , adiciona uma instância do OleDbParameter à coleção e retorna uma referência para o novo OleDbParameter .The following example creates an OleDbParameterCollection, adds an instance of OleDbParameter to the collection, and returns a reference to the new 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 

Aplica-se a