SqlCeParameterCollection.Clear Method

Removes all items from the collection.

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

Syntax

'Declaration
Public Overrides Sub Clear
'Usage
Dim instance As SqlCeParameterCollection

instance.Clear()
public override void Clear()
public:
virtual void Clear() override
abstract Clear : unit -> unit 
override Clear : unit -> unit 
public override function Clear()

Implements

IList.Clear()

Examples

The following example copies elements of SqlCeParameterCollection to an array and clears the collection.

' ...
' create SqlCeCommand cmd
' ...
Dim myParamArray(cmd.Parameters.Count) As SqlCeParameter
cmd.Parameters.CopyTo(myParamArray, 0)
cmd.Parameters.Clear()
// ...
// create SqlCeCommand cmd
// ...
SqlCeParameter[] myParamArray = new SqlCeParameter[cmd.Parameters.Count];
cmd.Parameters.CopyTo(myParamArray, 0);
cmd.Parameters.Clear();

See Also

Reference

SqlCeParameterCollection Class

System.Data.SqlServerCe Namespace