SqlCeParameter.SqlDbType Property

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

Gets or sets the SqlDbType of the parameter.

  [Visual Basic]
  Public Property SqlDbType As SqlDbType
[C#]
public SqlDbType SqlDbType {get; set;}
[C++]
public: __property SqlDbType get_SqlDbType();
public: __property void set_SqlDbType(SqlDbType);
[JScript]
public function get SqlDbType() : SqlDbType;
public function set SqlDbType(SqlDbType);

Property Value

One of the SqlDbType values. The default is NVarChar.

Remarks

The SqlDbType and DbType are linked. Therefore, setting the DbType changes the SqlDbType to a supporting SqlDbType.

The SQL Server CE .NET Provider supports the following SqlDbTypes: SqlDbType.TinyInt, SqlDbType.SmallInt, SqlDbType.Int, SqlDbType.BigInt, SqlDbType.Real, SqlDbType.Float, SqlDbType.Money, SqlDbType.Bit, SqlDbType.Binary, SqlDbType.VarBinary, SqlDbType.UniqueIdentifier, SqlDbType.Image, SqlDbType.NText, SqlDbType.NChar, SqlDbType.NVarChar, SqlDbType.Decimal, SqlDbType.DateTime

For a list of the supported data types, see the appropriate DbType property. For more information, see Using Parameters with a DataAdapter.

Requirements

Platforms: .NET Compact Framework

.NET Framework Security:

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries From Partially Trusted Code

See Also

SqlCeParameter Class | SqlCeParameter Members | System.Data.SqlServerCe Namespace

Syntax based on .NET Framework version 1.1.
Documentation version 1.1.1.

Send comments on this topic.

© Microsoft Corporation. All rights reserved.