Export (0) Print
Expand All

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)

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

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.

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

The following example creates a SqlCeParameter and displays the ParameterName.

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

param.IsNullable = true;


Show:
© 2014 Microsoft