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

public int Add( 
   string name,
   object value
)

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

Return Value

This method will create a new instance of an IDataParameter of the underlying type that matches the data provider specified by the default DbProvider, or the one passed into the constructor. For example, if the data provider is Microsoft SQL Server, this method will add a SqlParameter to the collection.

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. Consult the database vendor's documentation or the .NET Framework SDK documentation for these special considerations.

Reference

DataParameterCollection Class
DataParameterCollection Members
Overload List