Firebird ADO.NET Provider SDK Documentation - v1.7

FbParameterCollection Class

A collection of parameters associated to a FbCommand. This class cannot be inherited.

For a list of all members of this type, see FbParameterCollection Members.

System.Object
   System.MarshalByRefObject
      FirebirdSql.Data.Firebird.FbParameterCollection

[Visual Basic]
<ListBindable(ListBindable:=False), _  Editor(EditorBaseTypeName:="System.Drawing.Design.UITypeEditor, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a", EditorTypeName:="FirebirdSql.Data.Firebird.Design.FbParameterCollectionEditor, FirebirdSql.Data.Firebird, Version=1.7.0.0, Culture=neutral, PublicKeyToken=fa843d180294369d"), _  DefaultMember(MemberName:="Item")>
NotInheritable Public Class FbParameterCollection
    Inherits MarshalByRefObject
    Implements IDataParameterCollection, IList, ICollection, IEnumerable
[C#]
[ListBindable(ListBindable=False)]
[Editor(EditorBaseTypeName="System.Drawing.Design.UITypeEditor, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a", EditorTypeName="FirebirdSql.Data.Firebird.Design.FbParameterCollectionEditor, FirebirdSql.Data.Firebird, Version=1.7.0.0, Culture=neutral, PublicKeyToken=fa843d180294369d")]
[DefaultMember(MemberName="Item")]
public sealed class FbParameterCollection : MarshalByRefObject, IDataParameterCollection, IList, ICollection, IEnumerable

Thread Safety

Public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.

Remarks

The number of the parameters in the collection must be equal to the number of parameter placeholders and/or named parameters in the command text, or Firebird will raise an exceptionraises an error.

Example

public void AddFbParameters() 
{
// ...
// create myDataSet and myDataAdapter
// ...

myDataAdapter.SelectCommand.Parameters.Add("@CategoryName", FbDbType.VarChar, 80).Value = "toasters";
myDataAdapter.SelectCommand.Parameters.Add("@SerialNum", FbDbType.Integer).Value = 239;
myDataAdapter.Fill(myDataSet);

}    
                

Requirements

Namespace: FirebirdSql.Data.Firebird

Assembly: FirebirdSql.Data.Firebird (in FirebirdSql.Data.Firebird.dll)

See Also

FbParameterCollection Members | FirebirdSql.Data.Firebird Namespace