OleDbParameterCollection.Add Method (String, OleDbType, Int32, String)


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

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

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


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.

Type: System.String

The name of the source 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, "CustomerID");

.NET Framework
Available since 1.1
Return to top