SqlCeParameter Constructor (String, SqlDbType, Int32, Boolean, Byte, Byte, String, DataRowVersion, Object)
Initializes a new instance of the SqlCeParameter class with the parameter name, data type, length, and other properties. SQL Server Compact supports only 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
)
new :
parameterName:string *
dbType:SqlDbType *
size:int *
isNullable:bool *
precision:byte *
scale:byte *
sourceColumn:string *
sourceVersion:DataRowVersion *
value:Object -> SqlCeParameter
public function SqlCeParameter(
parameterName : String,
dbType : SqlDbType,
size : int,
isNullable : boolean,
precision : byte,
scale : byte,
sourceColumn : String,
sourceVersion : DataRowVersion,
value : Object
)
Parameters
- parameterName
Type: System.String
The name of the parameter.
- dbType
Type: System.Data.SqlDbType
One of the SqlDbType values.
- size
Type: System.Int32
The length of the parameter.
- 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.
- sourceVersion
Type: System.Data.DataRowVersion
One of the DataRowVersion values.
- value
Type: System.Object
An Object that is the value of the SqlCeParameter.
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.
Examples
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;