'Declaration
 
Public Overloads Function Add( _
   ByVal name As String, _
   ByVal value As Object, _
   ByVal direction As ParameterDirection _
) As Integer

public int Add( 
   string name,
   object value,
   ParameterDirection direction
)

Parameters

name

The name of the parameter to add (without the database-specific bind variable prefix such as @ for Microsoft SQL Server or : for Oracle)

value

The value of the parameter that will be passed to the database as part of the query

direction

Specifies a direction for the parameter. By default this is ParameterDirection.Input.

Return Value

The name parameter should be a simple name without any database-specific prefix such as "@" for SQL Server or ":" for Oracle. The SqlHelper will take care of adding the specific prefix.

The rules for the value parameter are dictated by the underlying data provider type. In general, basic types will be supported without problems, but database-specific values such as large binary arrays or text fields might require extra preparation. You can access the parameter collection via the Parameters property to perform database-specific work or add a custom parameter to the collection. Consult the database vendor's documentation or the .NET Framework SDK documentation for these special considerations.

Reference

DataParameterCollection Class
DataParameterCollection Members
Overload List