OleDbParameterCollection.Add Method (String, OleDbType)


The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Adds an OleDbParameter to the OleDbParameterCollection, given the parameter name and data type.

Namespace:   System.Data.OleDb
Assembly:  System.Data (in System.Data.dll)

public OleDbParameter Add(
	string parameterName,
	OleDbType oleDbType


Type: System.String

The name of the parameter.

Type: System.Data.OleDb.OleDbType

One of the OleDbType values.

Return Value

Type: System.Data.OleDb.OleDbParameter

The index of the new OleDbParameter object.

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);

.NET Framework
Available since 1.1
Return to top