CreateParameter Method (DbProvider)

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

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

Creates a new IDbDataParameter of the specific underlying type for this database provider type (i.e. SqlHelper for MSSQL, etc)

Syntax

'Declaration

Public MustOverride Function CreateParameter( _
   ByVal _name_ As String, _
   ByVal _value_ As Object _
) As IDbDataParameter

public abstract IDbDataParameter CreateParameter( 
   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

An IDbDataParameter instance which can be added to a parameter collection for a query

Remarks

See DataParameterCollection for more information on how to use data parameters.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Reference

DbProvider Class
DbProvider Members
DataParameterCollection Class