Partilhar via

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

  • Artigo

Initializes a new instance of the SqlCeParameter class with the parameter name, data type, length, and other properties. Microsoft SQL Server 2005 Compact Edition 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, _
    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 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, isNullable, precision, scale, sourceColumn, sourceVersion, value)

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

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

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

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

Not applicable.

Parameters

  • parameterName
    The name of the parameter.
  • size
    The length of the parameter.
  • isNullable
    true if the value of the field can be null; otherwise, false.
  • precision
    The total number of digits to the left and right of the decimal point to which Value is resolved.
  • scale
    The total number of decimal places to which Value is resolved.
  • sourceColumn
    The name of the source column.

Remarks

Size and Precision are inferred from the value of the dataType parameter if they are not explicitly set in the size and precision parameters.

Example

The following example creates a SqlCeParameter and displays the ParameterName.

Dim param As New SqlCeParameter("@Description", SqlDbType.NVarChar, 11, True, 0, 0, "Description", DataRowVersion.Current, "garden hose")
param.IsNullable = True

SqlCeParameter param = new SqlCeParameter(
    "@Description", SqlDbType.NVarChar, 11, true, 0, 0,
    "Description", DataRowVersion.Current, "garden hose");

param.IsNullable = true;

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

Version Information

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

See Also

Reference

SqlCeParameter Class
SqlCeParameter Members
System.Data.SqlServerCe Namespace