DB2ParameterCollection.Clear 方法

名称空间：

IBM.Data.DB2

组合件：

IBM.Data.DB2（在 IBM.Data.DB2.dll 中）

语法

[Visual Basic]
NotOverridable Public Sub Clear() Implements IList.Clear
[C#]
public void Clear();
[C++]
public: __sealed void Clear();
[JScript]
public function Clear();

实现：

IList.Clear

示例

[Visual Basic, C#] 以下示例将创建 DB2ParameterCollection，将 DB2Parameter 的实例添加至该集合，显示该集合的 DB2Parameter 对象的名称，然后清除该集合。

[Visual Basic]
Public Sub CreateDB2ParamColl(myCommand As DB2Command)
    Dim myParamCollection As DB2ParameterCollection = myCommand.Parameters
    myParamCollection.Add("EMPNO", DB2Type.Char)
    myParamCollection.Add("PHOTO_FORMAT", DB2Type.VarChar)
    myParamCollection.Add("PICTURE", DB2Type.Blob) 
    Dim myParamNames As String = ""
    Dim i As Integer
    For i = 0 To myParamCollection.Count - 1
        myParamNames += myParamCollection(i).ToString() + ControlChars.Cr
    Next i
    MessageBox.Show(myParamNames)
    myParamCollection.Clear()
    MessageBox.Show(myParamCollection.Count)
End Sub 'CreateDB2ParamColl

[C#]
public void CreateDB2ParamColl(DB2Command myCommand) 
{
    DB2ParameterCollection myParamCollection = myCommand.Parameters;
    myParamCollection.Add("EMPNO", DB2Type.Char);
    myParamCollection.Add("PHOTO_FORMAT", DB2Type.VarChar);
    myParamCollection.Add("PICTURE", DB2Type.Blob);
    string myParamNames = "";
    for (int i=0; i < myParamCollection.Count; i++)
       myParamNames += myParamCollection[i].ToString() + "\n";
    MessageBox.Show(myParamNames);
    myParamCollection.Clear();
    MessageBox.Show(myParamCollection.Count)
 }