OleDbParameterCollection.Add Method (String, OleDbType)

 

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
)

Parameters

parameterName
Type: System.String

The name of the parameter.

oleDbType
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
Show: