OleDbParameterCollection.Add Method (String, OleDbType, Int32)


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

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

public OleDbParameter Add(
	string parameterName,
	OleDbType oleDbType,
	int size


Type: System.String

The name of the parameter.

Type: System.Data.OleDb.OleDbType

One of the OleDbType values.

Type: System.Int32

The length of the column.

Return Value

Type: System.Data.OleDb.OleDbParameter

The index of the new OleDbParameter object.

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

.NET Framework
Available since 1.1
Return to top