Share via

SqlCeParameter Constructor (String, SqlDbType, Int32, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, Object)

  • Article

Initializes a new instance of the SqlCeParameter class with the parameter name, data type, length, parameter direction, and other properties. SQL Server Compact only supports input parameters.

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)

Syntax

'Declaration
Public Sub New ( _
    parameterName As String, _
    dbType As SqlDbType, _
    size As Integer, _
    direction As ParameterDirection, _
    isNullable As Boolean, _
    precision As Byte, _
    scale As Byte, _
    sourceColumn As String, _
    sourceVersion As DataRowVersion, _
    value As Object _
)
'Usage
Dim parameterName As String
Dim dbType As SqlDbType
Dim size As Integer
Dim direction As ParameterDirection
Dim isNullable As Boolean
Dim precision As Byte
Dim scale As Byte
Dim sourceColumn As String
Dim sourceVersion As DataRowVersion
Dim value As Object

Dim instance As New SqlCeParameter(parameterName, _
    dbType, size, direction, isNullable, _
    precision, scale, sourceColumn, sourceVersion, _
    value)

public SqlCeParameter(
    string parameterName,
    SqlDbType dbType,
    int size,
    ParameterDirection direction,
    bool isNullable,
    byte precision,
    byte scale,
    string sourceColumn,
    DataRowVersion sourceVersion,
    Object value
)

public:
SqlCeParameter(
    String^ parameterName, 
    SqlDbType dbType, 
    int size, 
    ParameterDirection direction, 
    bool isNullable, 
    unsigned char precision, 
    unsigned char scale, 
    String^ sourceColumn, 
    DataRowVersion sourceVersion, 
    Object^ value
)

new : 
        parameterName:string * 
        dbType:SqlDbType * 
        size:int * 
        direction:ParameterDirection * 
        isNullable:bool * 
        precision:byte * 
        scale:byte * 
        sourceColumn:string * 
        sourceVersion:DataRowVersion * 
        value:Object -> SqlCeParameter

public function SqlCeParameter(
    parameterName : String, 
    dbType : SqlDbType, 
    size : int, 
    direction : ParameterDirection, 
    isNullable : boolean, 
    precision : byte, 
    scale : byte, 
    sourceColumn : String, 
    sourceVersion : DataRowVersion, 
    value : Object
)

Parameters

  • isNullable
    Type: System.Boolean
    true if the value of the field can be null; otherwise, false.
  • precision
    Type: System.Byte
    The total number of digits to the left and right of the decimal point to which Value is resolved.
  • scale
    Type: System.Byte
    The total number of decimal places to which Value is resolved.
  • sourceColumn
    Type: System.String
    The name of the source column.

See Also

Reference

SqlCeParameter Class

SqlCeParameter Overload

System.Data.SqlServerCe Namespace