SqlCeParameter Constructor (String, SqlDbType, Int32, String)
Initializes a new instance of the SqlCeParameter class with the parameter name, data type, length, and source column name.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)
Syntax
'Declaration
Public Sub New ( _
name As String, _
dataType As SqlDbType, _
size As Integer, _
sourceColumn As String _
)
'Usage
Dim name As String
Dim dataType As SqlDbType
Dim size As Integer
Dim sourceColumn As String
Dim instance As New SqlCeParameter(name, dataType, _
size, sourceColumn)
public SqlCeParameter(
string name,
SqlDbType dataType,
int size,
string sourceColumn
)
public:
SqlCeParameter(
String^ name,
SqlDbType dataType,
int size,
String^ sourceColumn
)
new :
name:string *
dataType:SqlDbType *
size:int *
sourceColumn:string -> SqlCeParameter
public function SqlCeParameter(
name : String,
dataType : SqlDbType,
size : int,
sourceColumn : String
)
Parameters
- name
Type: System.String
The name of the parameter to map.
- dataType
Type: System.Data.SqlDbType
One of the SqlDbType values.
- size
Type: System.Int32
The length of the parameter.
- sourceColumn
Type: System.String
The name of the source column.
Remarks
Size is inferred from the value of the dataType parameter if it is not explicitly set in the size parameter.
Examples
The following example creates a SqlCeParameter and sets some of its properties.
Dim param As New SqlCeParameter("@Description", SqlDbType.NVarChar, 88, "Description")
param.IsNullable = True
SqlCeParameter param = new SqlCeParameter("@Description", SqlDbType.NVarChar,
88, "Description");
param.IsNullable = true;