System.Data.OleDb Namespace
Represents the collection of parameters for an OleDbCommand.
| Visibility |
Name |
Parameters |
Return Type |
| public |
Add |
(
String
parameterName
,
OleDbType
oleDbType
,
Int32
size
)
|
OleDbParameter
|
| public |
Add |
(
String
parameterName
,
OleDbType
oleDbType
,
Int32
size
,
String
sourceColumn
)
|
OleDbParameter
|
| public |
Add |
(
Object
value
)
|
Int32
|
| public |
Add |
(
String
parameterName
,
OleDbType
oleDbType
)
|
OleDbParameter
|
| public |
Add |
(
OleDbParameter
value
)
|
OleDbParameter
|
| public |
Add |
(
String
parameterName
,
Object
value
)
|
OleDbParameter
|
| public |
AddRange |
(
Array
values
)
|
Void
|
| public |
AddRange |
(
OleDbParameter
values
)
|
Void
|
| public |
AddWithValue |
(
String
parameterName
,
Object
value
)
|
OleDbParameter
|
| public |
Clear |
( )
|
Void
|
| public |
Contains |
(
String
value
)
|
Boolean
|
| public |
Contains |
(
OleDbParameter
value
)
|
Boolean
|
| public |
Contains |
(
Object
value
)
|
Boolean
|
| public |
CopyTo |
(
Array
array
,
Int32
index
)
|
Void
|
| public |
CopyTo |
(
OleDbParameter
array
,
Int32
index
)
|
Void
|
| public |
GetEnumerator |
( )
|
IEnumerator
|
| protected |
GetParameter |
(
Int32
index
)
|
DbParameter
|
| protected |
GetParameter |
(
String
parameterName
)
|
DbParameter
|
| public |
IndexOf |
(
Object
value
)
|
Int32
|
| public |
IndexOf |
(
OleDbParameter
value
)
|
Int32
|
| public |
IndexOf |
(
String
parameterName
)
|
Int32
|
| public |
Insert |
(
Int32
index
,
OleDbParameter
value
)
|
Void
|
| public |
Insert |
(
Int32
index
,
Object
value
)
|
Void
|
| public |
Remove |
(
Object
value
)
|
Void
|
| public |
Remove |
(
OleDbParameter
value
)
|
Void
|
| public |
RemoveAt |
(
String
parameterName
)
|
Void
|
| public |
RemoveAt |
(
Int32
index
)
|
Void
|
| protected |
SetParameter |
(
String
parameterName
,
DbParameter
value
)
|
Void
|
| protected |
SetParameter |
(
Int32
index
,
DbParameter
value
)
|
Void
|
|
The OleDbParameterCollection represents the set of parameters defined for a given OleDbCommand. This collection is accessed via the OleDbCommand.Parameters property.
Like most data collections in ADO.NET, the OleDbParameterCollection uses standard collection methods such as Add, Clear, and Remove. In addition, the Contains method can be used to check for the existence of a particular parameter in the collection.
The number of parameters in the collection must be equal to the number of parameter placeholders within the command text; otherwise, the OLE DB .NET Data Provider raises an error.
OleDbParameter OleDbCommand.Parameters
