SqlParameter.SqlDbType Property

Definition

Gets or sets the SqlDbType of the parameter.

[System.Data.Common.DbProviderSpecificTypeProperty(true)]
public System.Data.SqlDbType SqlDbType { get; set; }
[<System.Data.Common.DbProviderSpecificTypeProperty(true)>]
member this.SqlDbType : System.Data.SqlDbType with get, set
Public Property SqlDbType As SqlDbType

Property Value

SqlDbType

One of the SqlDbType values. The default is NVarChar.

Attributes

Remarks

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

For a list of the supported data types, see the appropriate SqlDbType member. For more information, see DataAdapter Parameters.

For information about streaming, see SqlClient Streaming Support.

Applies to